Search results

I would like to have this code run on database open and then set it back to locked when the database closes. I don't think that I will be able to make any registry changes so if this can be done with VBA that would be great. Thanks for your help, Tyler:)

Can you explain the situation a little more? VBA is a little scary at first but with a little practice you will find that it is very versatile and allows you to do things that macros or wizards will never allow. If for instance you have a form and the values in the combo boxes together...

In my database I have created a shell database that's sole function is to determine the user's level of access based upon their Hash ID (personal ID) that is in the registry some where. When the employee logs into the computer it stores their ID number THis database has a form that just reads...

I have two separate databases. I need to be able to open database 2 using a criteria of a field on a form from Database 1. I have successfully used the shell command to actually open database 2 but I can't get the correct form with filtered information to open. I have used the following code...

If you set the on open procedure for your form so that if the current user <> admin then reportingbutton.visible=false. This will only hide the button for people that aren't admins. The only problem is I don't know if your db tracks who is logged on. If so you can use the current user name...

Allen brown has a nice piece of code that does a compounding search like you are talking about. You can download a Sample and adjust it to fit your fields here. http://allenbrowne.com/bin/Search2000.zip This is a great place to start. It shows you how to have search criteria that can handle...

Hope this helps I had the same thing. I have a combo box that lists a group of organizations that displays their members in a sub form. I wanted to be able to go to the Organization name combo box and select a different organization and then have the form requery to get all of their...

I am going to give this a BIG BUMP! as I desperately need to know how to be able to scroll through a memo field. Please, all you experts out there we need your help. Personally, I am fine with having to set the focus to the memo field first and then be able to scroll, but I know others want to...

No that won't work the 8 or nine digits are one number set so they can't be separated. I hate to resort to VBA to format the number. If you have any other ideas about how to make the number fill from the right so that all the spots are filled leaving the 9th spot as optional. I appreciate...

I have a number field that has three groups of 3 numbers: 123 456 789 or 12 345 678 (8 numbers). When there are only 8 numbers I need to have the first group of number contain 2 numbers and the other two groups to have the other six numbers. If my input mask filled from the right it would...

I would like to have a search box in which someone can type anything and it will search through a few tables to see if this word appears, and then return information from that record so I know who it belongs to. I have a query written that has all of the fields from all of the tables that I...

I tried this and it didn't change anything. Any other ideas?

I have a logo that is part of a very short avi movie clip. Iwould like to display the clip in a loop on open of the form. I found this code in the microsoft help, but it doesn't seem to work: Private Sub cmd1_Click() Dim AviFile As String 'Type the full path to the .avi file on the...

Like the title says I need to have a form that displays up to 20 pictures of people. I have a subject table that includes a yes/no field I have named Add. I use this in a query to say Select * FROM Subject WHERE [Add] = True. This query allows me to select the people I want for the picture...

Quote: The first table1 is like this: id Field1 Field2 Field3 1 TagNo44 Y Yes 2 TagNo5 C No 3 TagNo127 Q Maybe 4...

I would like to create some custom icons and use them in Access. Does anybody have an experience doing this that can start me down the right path? Thanks:)

Click on the properties for the form and look for the control box and put to no. This should get rid of the max min buttons.

ajetrumpet, Thank you for your advise. Can you explain to me how using the three fields together to get a primary key (unique Value) is important? Is that how you can separate contract information so that a query will look at the Contract of Corn Expiring in December of 2007 separate from the...

I have written this query to get the last 20 records of a commodity: SELECT TOP 20 CurrentMonthData.[Symbol], CurrentMonthData.[DeliveryMonth], CurrentMonthData.[DDate], CurrentMonthData.[Close] FROM CurrentMonthData WHERE (((CurrentMonthData.[Symbol])="AD") AND...

sysop470, If you could list the fields in the table that would help. Is this a database of employees? I ask because you said one person should be able to see all the records (a Manager?) If so then once you have all the fields in an Employee Table you want to ensure that their is a...