Search results

Thanks for your help!

I have a few tables that my user will be importing from time to time. Is there a way to have the property for these tables, using vba or even a macro, automatically set to hidden, instead of manually right clicking on them and setting the property? Thanks!

Thanks for your help. I added the & "*" to the end of the statement. There are only 8 different users and none have a similar name so I should be ok. Thanks again!

I have a report that uses a query to pull data based on the user's name. Currently the report will prompt the user to enter in a name and then run the report based on that name. I would like the user to be able to run a report with wild cards. Instead of typing "John Doe" to view all his...

My code seems to be working correctly. I didn't make any changes to it. I think it was just Access acting up. If anyone know of a better way for me to do what I described above, I would be interested in knowing. Thanks.

I can't get my form to save a value that I pass into it. I have a form that promptsthe user to enter his/her name. After they enter in their name and press OK, the Log In screen is turned invisible and my company form is launched. Whenever a new record is added to the company form or data...

I used the Command Button Wizard to create a button that calls the Find Record window. Is there anyway to modify the vb code so that the default for the Match options is set to "Any Part of Field"? Also if it is possible, I would like for the Replace tab to be removed or disables. Thanks...

Thanks Drew. I took a 2 day Access class this week and saw something similar to this being done in the class. I was thinking about doing this while sitting in class, but I wasn't sure if I should or not. Guess you saved me from having to ask the forum. Thanks again!

Can anyone help me? I'm not too familiar with VB, plus it's been a while since I wrote this code. I believe that the strInput_User_Name is loosing its value as the user uses the program throughout the day. The InputBox launches whenever the database is opened. If the user does not enter...

Thanks

Thanks for your suggestions.

I have a macro that runs and opens a query in read only mode. I would like for these results to be exported into a Paradox 5 file. Is there a way to do this with a macro? Thanks!

I ended up combining the random number with the current data and time (hour minute seconds). Do you see any problem that I could run into by doing this? I can't use autonumber because 8 different people will have separate databases when they are out on the field. At the end of each week, they...

On one of my forms, I have a field named CallID that is the primary key for my table. For the default value, I have the following code: =[Forms]![1_Company_Form]![COMPANY_NUMBER] & Rnd() My code for generating a random number has been working great until now. For some reason it has been...

I figured out what was happening. Access would not saving the query, even though it would act as if it were saving the query. Rebooting the computer seems to have corrected this problem.

I figured out what was happening. Access would not saving the query, even though it would act as if it were saving the query. Rebooting the computer seems to have corrected this problem.

I figured out what was happening. Access would not saving the query, even though it would act as if it were saving the query. Rebooting the computer seems to have corrected this problem.

I'm trying to get the dates to show up in my subform in descending order. Some of you might be familiar with this form. It is the contact management database that the Access wizard can create. I let Access create these forms, then I added them to a database that I am working on. I...

Thanks for your help. I will have to do this the next time it occurs. Do you know what will happen if I lock my VB project from being viewed, when this error occurs again?

A few days ago, I copied a database that I'm working on to a user's computer so that he could review and test it. He received an error stating saying something like this, "Missing Visual FoxPro Type Lib info control" . In the VB editor, i clicked on Tools, References. I then uncheckd a box...