Search results

As usual, Thanks Paul.

I need to find the LATEST date in field Recdate that is 45 days or older in a query. I have tried <Date()-45, etc. but it returns all dates not just the last one. Does this require a range of dates to do this ? If not, how would I id the last date input ? Thanks

I know that, I mean can you set it to pop the list up when entering the box without clicking on the arrow ?

Thanks guys. Works Now what do you set to make the list auto appear when you enter the field/box ?

Probably a dumb question and not very clear but... When entering (clicking on, tabbing to, etc) a text box field on a form you have a box come up with possible selections for that field that when clicked on it enters the selection.... What is that called and is it difficult to set up ?

Thanks once again Paul. Hey, I may come to Vegas this summer. Any good deals only the locals know about ?

I would like to express my appreciation for all the help I have received from people on this site. I would list their names but I would surely leave someone out. I have been on a lot of forums for various subjects, and I must say this has to be one of the two friendliest and most helpful boards...

I really appreciate the help guys. I knew you would come through. Now is there a way I can sort records in a report without doing so in the query ? I need my invoices in Zip order.

Actually, my original plan was to store calculated balances and was advised, and rightly so, to do it this way. This particular query is a result of a lot of help on here. So I am really confused. I have my sister using the db in real world - didn't know about this problem until today. If there...

I use the same query calcs to print invoices depending on the billing category and don't print an invoice for zero balances. Also, for a debit credit report, it would take all three queries. Tried the make table way. Might cut it down 3 to 5 seconds but that is just running the third query for...

Not sure I understand why 3 instead of 1 query ? Yes, that seems to work - however, it DOES take a while to open the balance sheet. Not to mention having to use 3 different queries for my Debit/credit report. Also returns a zero balance which don't want since I use the same query for my invoice...

More testing It appears that once the credit sum reaches the charges sum, it adds the sum of charges again for each credit entry there is. Tested again. works the same way in reverse if there is a credit, it will keep adding in the same manner. Ok what gives guys ?????????????????

Thought this thing was working great. Seems this is happening: If the sum of credits exceed the sum of charges, the query doubles the sum of charges. The query- When I run the query, the SumofCharges calc is the culprit since it shows in that column. I can't dup it in the SumOfCredits, but...

I modified your procedure a bit and tried ONE combo with CID, Name, Addr, and Srvamt, which are the 4 fields of data I need to display in the main form. Sometimes she has checks with the CID sometimes not then has to go by name and if that is duplicated, then address. However, when I select one...

Thanks cyberlynx, I believe this part is confusing me: "Now, Based on the selection of the Customer Name from within the Customer Name ComboBox, the Address Textbox is automatically filled (via Code) in the Invoice ComboBox comes alive, again, from yet another Select query forced (via code)...

In Before Update, this is the code I use Private Sub Form_BeforeUpdate(Cancel As Integer) 'Provide the user with the option to save/undo 'changes made to the record in the form If MsgBox("Changes have been made to this record." _ & vbCrLf & vbCrLf & "Do you want to save these...

Well, I have found videos and such on the net on making combo boxes and list boxes and watched and read everything I can find. I still can not make a combo box work for me. It either won't list the records in a field or when I get it to, it doesn't sinc with other text boxes on the form or...

Didn't want to have to ask again but.... Have a form with 3 fields then a subform with input fields to input payments. (CID is the unique PK) All from one query Need to change the 3 fields in the main form to a combo box to facilitate quicker finding of record. Tried everything I can and...

No problem Now if I can figure how to change a main form with a subform to a combo box with the same subform, everything looks great.

I was curious about that. I usually work on the design in one directory but when I send it to her, I make sure the correct path on her pc is set in the options. Is there a problem with doing that ?