Search results

thanks, John. it works. :) imdl

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

thanks for your help. i was able to split the database and create a back-end database where i can update tables. it works, when i open the front-end database, i could see the update. however, when i tried creating a query on the back-end, it does not show up on the front-end. is there a...

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...

thanks guys, for your replies. my understanding is that append means "add," right? it should overwrite the sheet and should not delete the file. i have actually two sheets in the Excel file. the first sheet contains formulas based on the second sheet being overwritten using the code...

:) thanks a lot

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...

thanks for your prompt reply. i've attached pictures of the query in datasheet and design view. please help. imdl

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

it works. thank a lot for your help ;)

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

thanks a lot for your replies. i put the combo box with the query names (from David's message :)). At the on click event of the command button, i put this code for each of the query names. If Me.[comboboxname] = "queryname" Then DoCmd.OpenQuery "queryname", acNormal, acEdit End If

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 got the same error. compile error: user: defined type not defined this line is highlighted - appWord As Word.Application please help. imdl

thanks, that's useful information. however, still, i've been trying my luck to find how to send a form as the "email body" (not as attachment). any further help would be appreciated. imdl

:) yeah, here's the code: Private Sub Form_BeforeInsert(Cancel As Integer) Me.txtName = fOSUserName() End Sub (txtName is the text box on the form) :) imdl

Never mind, i found the answer. =)

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...

thanks, david. i was able to create the list box of query names. further, i would like to run the query upon selection of the name in the list box, or there could be button to run the selected query. can you help again? imdl