Search results

Hi, I have a form with multiple drop-down lists. Currently, when I go to each field, I still to use the mouse to click the "inverted triangle" to show the options in the list. I would like to just use the the arrow down key (instead of the mouse) to show the list. How do I go about that? imdl

hi, i have created a database being used by around 50 people. for security of forms and queries, i can hide the navigation pane through the office button > access options > current database > uncheck Display Navigation Pane. however, i need 3 people to have access to the navigation pane to be...

Hello, I'm using the code below to transfer a query to a specific Excel file. It works, and when I click the command button again, it overwrites the existing Excel sheet. However, after several times of overwriting the Excel sheet, it stops working or it does anymore overwrite. Is there an...

hi, i have a query with Trace Number in "ascending" order. when i use the code DoCmd.TransferSpreadsheet acExport, the output Excel data are NOT in ascending order by Trace Number. Why is it so? please see attached output Excel fie. imdl

Hi, I am currently developing a database of invoices. I'd like to know if there's a way to put a message box that whenever a user enters a new record with the same invoice number as an existing record, the message box should say, "A record with that invoice number already exists." imdl

I have the code below that works fine, except that the input box for the password displays the actual password, and not asterisks (*****). Private Sub cmdOpenForm_Click() Dim strInput As String Dim strMsg As String Beep strMsg = "Please contact your Administrator to reset your password." &...

I found the module [http://www.mvps.org/access/api/api0008.htm] and I have the text box =fosusername() that shows the user's login name. I need help on how to populate the user's log in name onto the field in the table whenever a new record is created. imdl

Help please...I can't open my database. It says, "Microsoft Office Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new...

Can someone advise on how to create a list box showing all the query names? Then, a button would be used to run a selected query. imdl ;)

I would like to have an MS Access form displayed in the body of an Outlook email message. Is there a way to do this? imdl :)

I got the code that enables an option group (opgOPCO) to pop-up whenever I input “0064” into the combo box (cboCCN). However, when I go to the next record (using record selector), the option group (opgOPCO) does not hide even though the combox box contains a value other than “0064.” Dim bShow As...

I used DLOOKUP for a text box in a form. However, to see the looked-up value, I still have to close and reopen the form. Is there any way to show the looked-up value in the text box by just a mere click? Say for example, I hit the "enter" or "tab" key, the text box would automatically update. :)