Search results for query: *

I am appreciating all the help i am getting guys and thanks allot. Willir i used the code you gave me and i put it within the on click even of the button in question theseare the errors i received and this is the part of the code it is refering to have i pasted it wrong or something...

for the site_table the primary key is site_id which is an auto number, for the form i wish to open on a specific record it is called product_table and the primary key for that is product_id which is an autonumber

the reationship is one to many yes but thats not what it is complaining about it is saying that the expression is wrong, i used the wizard and it doesn't like it its reay annoying gggggrrrrrrrr

i am using the right code, and the names for the forms are correct but for some reason it returns the error message sysntax error (missing operator) in query expression '[site_name]=TAVERN FAYRE'. the tavern fayre bit is the name it is taking from the site database to look up products (that the...

The starting form is called site_name a button on this form called products opens another form called proucts. I want it to open the form products and open on all records with the same sitename or the first record witht that sitename. also aceman that code u gave me doesn't work it comes up...

Hey In the onchange event of your combo box you need to put an if statement like this if me.(name of the combo box) = (value)then me.(name of element1 to disabe).enabed = false me.(name of element2 to disabe).enabed = false me.(name of element3 to disabe).enabed = false end if for different...

no this code is from a button on a form called site_name the button is supposed ot open another form called product_table with a record of the same site name the idea is u can see what that site has bought

Here is the code for my link to another form, and the data entry propert on the form i am linking to is set to no Private Sub products_Click() On Error GoTo Err_products_Click Dim stDocName As String Dim stLinkCriteria As String Dim stFormName As String stDocName =...

i used the access wizard to create a button to link from one form and open another form on a specific record or records and it is not working. it is opening the form but it seems to be opening it and showing a new record what is the probem and how do i solve it? thanks!!! whoever you shall be

When setting a field as required in design view, how do you change the error message for when a user has not filled the field

from what i am aware you are ony able to switch them off within access so only your form itself is visible, maybe in visual basic there may be a property for changing color and maybe perhaps style?!!!

when a user wishes to create a new record it is sometimes helpfull for some items from the record their viewing to be autopopulated into the new record how is this possible?

cheers been waiting for ages for an answeer to that one

im looking for a way so when the user performs a search by default the match is any part of field in stead of whole field, also any possible solutions on how to make it easier for the user to search any field

Cheers wilir it turned out the forms that were remaining blank were the ones which contained no data in the tables, they worked fine after i had put test data into them. Cheers i would not have been able to have known that without your help. one other problem though is, if someone enters the...

the sub form that appears for the search button created using the wizard i want to be able to set it as default to search any part of field instead of whole field and remove the replace tab so it is purey for search alone

When i put a shortcut to my database on another machine, it opened okay and was read ony which is what i expected and wanted but some forms show up as they should and other forms show up blank with just the style that i am using for the forms any ideas?????

I don't want any changes to a record to be made unless the user presses the save button what can i do to stop this i am using forms cheers

I am looking for how to select the time and date rather than enter it, i can add a calander but i wish to have a calander that pops up when you select it or the text box, how woud i do this. I am using acess 2000

What would i put into criteria so that the query would show all records that have less than 30days till the expiry date is reached. This fied is in date and time format Cheers