Search results

stLinkCriteria

Hi On a form(withsubforms) I have created a cmd button to open a second form and display the full details from a table that relates to a particular field. I wish to use the field [company] in the original form [frmJobTracking] as the criterion for the record search in [tblSupplier] and display...

Thanks

Hi I have a command button on form (A) that I wish to use to open form (B) and display the record that relates to a specific field in form (A). I used the wizard, searched the forums and can't seem to find what I want. Can anyone suggest the code that I should be using in my on click event...

Hi Sorry, complete beginner here. I've created a set of my own nav buttons and they work with one exception. I am trying to stop the error messages when I am at the first record and click on previous or on my last record and click on next. I searched the forums and found a relevent article...

Hi Sorry, complete beginner here. I am trying to stop the error messages when I am at the first record and click on previous or on my last record and click on next. I searched the forums and found a relevent article, copied the code as it suggested and pasted it as shown. However, the event...

Thanks Thanks Steven811

Hi I have a sub form that correctly works (I think) with the master form with the exception that it does not display the record count. I have a small number of records that it will allow me to scroll and view correctly, but it says 'of .......' and no matter how long I wait, the space remains...

Versions of access Thanks for the offer of help. However I'm having problems with Access generally, I had 97 and 2000 loaded at the same time and it's all fallen over. The code now works but takes data from a record set that is not in the current view of the form, almost like it's cached and...

Hi I'm trying to run a simple module to export a record set to Word and I get this error message. Run-time error '-2147417851 (80010105)': Automation error The server threw an exception I have found the error message in the MS Knowledge Base article 242375 and it talks about late/early...

Tab Control Thanks for that. I need to use another subform nested in the sales subform and the overall view is quite cluttered, I would like to use tab control in the form. I have found that this only works with one data source and when I use a query constructed from 3 tables, I have this...

Hi I want to create a simple record set from a query for use in a form. A query that looks at 2 tables, one for customer and the second for their sales so that the form ultimately displays all the sales for each customer. The results from the query repeats the entry for the customer every...

Hi I'm trying to use a tab control in a form that will allow me to access more than one data source. I'm failing and don't understand why. I would like to dispay data from 3 tables under 3 different tabs in the same form. Is this possible. Thanks in advance for any help? Steven811