Recent content by 3Mark3

Hello all..I'm having some difficulty trying to figure out how to delete a space in a field if the first character is a space? I have a series of loan numbers..but some of them, when imported, have a space as the first character. How could I construct a query to look for those and delete that...

Good morning, I'm having a problem building a query on a type I've not worked before. Here's the situation. I have a field (we'll call this a FEE) within a table that contains multiple fees for a given loan number. I have another field (we'll call this a REMAINING AMOUNT) that contains an...

Hello all, I'm trying to figure out how to build a timed event that will close my access database at 6:30 in the evening. Now I know I can use the timer event and based on a certain intervals, but that won't work well. Can you advise of a solution? Thank you in advance! Mark

Hello all....I can't seem to find a way to query Odd or even days. I'm working with a date field....although I imagine it would work with a number as well... Could anyone help me? Thank you! Mark

Hello everyone. I have a problem I'm Trying to resolve. I have a control in a report called [Completed]. I have, at the bottom of my report footer, a count for that control. The range of values in this control is either "yes" or "no". I can't seem to count these individually. Can someone...

Hello all. I may be going about this the wrong way, but I'd like to password protect a control that will open another form. Is this possible? Or is there a better way to go about this?

Awesome....and a very quick response. Thank you PH!

I'm obviously doing this wrong..can anyone figure out how to fix my problem? Thank you! DatePart("yyyy",[date_maturity]-10)

Good morning everyone, I have a question I hope someone can help me with. I would like to delete any duplicates in a query. Now I understand I can use the "find duplicates" query to identify, however if I were to delete those records, woudln't that also delete all instances? How would I go...

Afternoon everyone and Happy Friday! I have a question I'm hoping someone can help with. I have a subform that is tied to a query. I would like to have a box which will ask the person their first name (I already know how to do this part). What I would like to do...is based on what name they put...

Thank you. Oddly it's not working right for me. It's showing everything on the same line with Squares between each piece of data. This is a memo field, does that have anything to do with it? Here's how my query looks: t_notes: [temp_table_MI]![t_notes] & Chr(10) & Chr(13) & "Topics...

Hello all, I'm trying to figure out how to add a return when pasting several controls into a memo field. what I'm trying to do is add return lines after each field. For instance: [Control1] [[Control2] [Control3] When I'm creating the query, I use: [Control1]+[Control2]+[Control3] How...

Ahh...excellent, thank you for the quick response!

I have an iif statement that I'm not doing right. Can someone correct this? Thank you! F5: IIf([Welc_AK20060328]![Field5]="000" Or "TX75087000","good","Not good") right now it just returns all "good"...even though there are all kinds of different data.

Does anyone know how to setup this query? I'm trying to find out how to delete the first, say 5 characters. Example would be Pre-qry 0001974668845 post-qry 74668845