Search results

Thanks. This only allows me to search for: *cad* *pdf* but does not allow me to search for" *cad* or *pdf* cad* or pdf* Not cad* <>cad* Any other ideas? Thanks!

Hello all: I have a form that is attached to a query. In my query, I have the following criteria: [Company] Like [Forms]![QBF_Form]![Sales] & "*" Or [Forms]![QBF_Form]![Sales] Is Null But it only allows me to search that particular field either when I put in a blank or when I put in...

Thanks Pat, I have included the default date thing. Thanks.

Hello all: Posted earlier in General, this form might be more appropriate. Every week I download new information into a table. The download has all the information, but the table will spill out any information from the download that is already existing in the table. The downloaded data does...

Hello all: Every week I download new information into a table. The download has all the information, but the table will spill out any information from the download that is already existing in the table. How do I print a query or report right after the download, that will provide a list of the...

Thanks much. I used the AcViewPreview and it worked, but the report stay in the background, I would like to bring it to the front. I checked a few posts, but nothing is working yet. here is my code : Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the...

Hello all, Please help with this: On opening my database, I have a switchboard that opens up. How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a...

It's solved...I played with creating something and it now works. Thanks all.

Thanks Smart. I am using Access 2003. I tried searching the forum but the suggestions are not working.. I can't even open a blank database without access asking me for password e.t.c. and the password is not working even though it is the correct password. If I reinstall my access, would it...

Hi all, I was playing with passwords for one of my access db. I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure...

Hello all, Is there a way to make sure only one user have access to change a database, whereas others just have access to view the forms, queries, reports e.t.c.? Thanks!

Hi Smart, No this doesn't do the trick. I am filling in the field in the form with my search criteria. This then runs the query. I can not fill in "like data* or like vent *" In the form field, I want to fill in: data* or vent* Any ideas on how to do this are very welcome, thanks again!

Hello all, I have a form that feeds a query with information, in my query I have this: [Company] Like [Forms]![QBF_Form]![Sales] & "*" Or [Forms]![QBF_Form]![Sales] Is Null When I fill in a value in the field e.g. "data*"the query brings up all information with the word "data" in it...

Hmmm Rickster57, I am learning something new....I didn't know I could do that... I tried it: Private Sub Command4_Click() DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.RunMacro "M1T1Macro" but it's not working...what am I missing? This code is in my execute...

Hi ghudson, I forgot to ask where to put the code above. I have a form C within a Form D. In my form C, I have a date field that has to be entered. When I click out of form C, I get the error 3314....cannot contain a null value. So, where do I put this code you suggested that would...

Thanks, I am going to check this out now.

Hi, you've lost me. My Execute button has a macro attached to it: On Click: MacroName My macro opens Form B, runs the query based on the form A and closes the query. Where do I put this new code you suggested?

Hi, how do I find out if I am using a save/refresh or save record? Thanks

Scott...thank you so much. the path code you gave me worked,\\Server\Folder.... I find that it is slower though compared to drive:\folder... Is there a way around it?:)

Hello all, I posted this earlier but got no response, please help! I have the following event procedure in my Reset button on my form: Private Sub cmdClearAll_Click() ' Clear All TextBoxes and Set all Check boxes to false (no tick) Dim ctl As Control For Each ctl In Me.Controls If...