Search results

The subform needs to show only records for the item on screen, so needs to be linked. I'm not sure what this has to do with looping through these records?

Looping thru subform records Does anyone have any helpful hints for me on how to loop thru subform records?

Thanks for your reply, but my problem is not the syntax for referring to the subform, rather how do I loop through the records in the subform? I can get to the subform just fine, but it only looks at the first record. I need it to look at all the records in the subform for each condition...

I have a form where the user will do data entry. This form also contains a subform. I have a long If/End If statement that checks the user's data entry for errors. I then want to look at the subform to check to see if the user's data entry conflicts with the data on the subform. I can get my...

I have a button on a form that, when pressed, is checking the data entry done on the form by the user. I'm using If..Then statements. I need to include in all this a way to check each record of the subform as well for any conflicts. I am unsure how to include a loop inside of the If..Then...

I am building an equipment check-out database. On the check out form I have the user fill in check out date/time and projected return date/time. On the check out form I am also displaying in a subform any reservations for the selected piece of equipment. Upon pressing the Save button, I want...

Answer for Conditional Footer I found the answer to fix my conditional footer problem. I'm posting it here in case someone else needs to use it ... I found a related topic in one of Helen Feddema's Woody's Access Watch columns. ...Laurie intPageNo = Me.Page If intPageNo Mod 2 = 0...

I have a report that consists of a letter on page 1 and a certificate on page 2. This report runs many of these page 1/2 combinations at a time. I want to put my agency address in the page footer and have it only appear on the letter (page 1) and not the certificate (page 2). The agency...

Never mind, got it! I looked in SQL Books Online and found I needed to use the % character instead of *, so this works: DoCmd.OpenReport stDocName, acPreview, , "((tblPayee.FirstName) Like '%' & [Forms]![frmReportMenu]![txtSearchFor]& '%')" Thanks anyway! Laurie

I have code on a button in the On Click Event that fills a report title and gets data from a table. I get a type mismatch error on this line and believe it is having a problem with the "Like" operator. I took this code directly from the SQL statement from a query...why does it not work? How...

What a great idea! I do have the ssn.setfocus code in other areas. But your idea of setting the tab stop for the SSN field to no worked like a charm. And so simple. Thank you so much!!! On to other things........thanks again.

No, that didn't work ... same thing happens where the SSN message box pops up.

Yes, I tried adding the code "srchPayee.SetFocus" before this code on the On Click event of the delete button: DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 which didn't work either (still got the SSN message box)...

I have a form that has (among other things): 1) a delete button (to delete a record) 2) a Search Payee box (that lists all payee names) 3) an SSN text box I have code in the "On Enter" event of the SSN text box that pops up a message box asking which way to format the SSN (regular or as tax...

I looked and I don't have a sysmessages table ... is this something you make up yourself or is it already supposed to be with the other default SQL tables?

I am trying to figure this out as well. I have scoured the forums here as well as Microsoft's Knowledge Base. I have tried various modules, etc. suggested by Microsoft but nothing works. I will be interested to see if you get any different advice...Laurie

I am working on my first bound application between SQL Server and Access 2000. I am using a manual to try to set this up. The manual has given the following code to link one table/relink all tables. I assume I should run the relink all tables code every time a user opens the database ... but...

Success Ahhh, yes, that was it! Thank you!

ErrorList; module won't run I pasted the code you supplied into a module. When I try to compile it I get errors ... the first is: User-defined type not defined The piece of code "dbs as DAO.Database" is highlighted. I've tried figuring this out, but am stuck...I'm not an expert at...

Error List Thanks for the code...I'll give it a try!