Search results

I would test and see what value the dlookups are pulling in. My guess that is where your problem is. Add these to your code and the results will print in the immediate window of the vba editor. debug.print "Approver = " & Nz(DLookup("Approver", "tbl_approver", stWhere), "") debug.print...

The database is not protect. Try right clicking on the fBrowseDirectory form name and select the Design option to get inside it.

Check out my old Browse [Find a directory or file] sample to see how to call a browser and catch the users selection. Look at how the fBrowseDirectory form works and the code behind it.

Are you trying to open windows explorer to a specific sub directory from the value in a text box? i.e. X:\Main Directory\Sub Directory1\Sub Directory2\Sub Directory3\

Please tell me that you did change the ([YourLoginField]) to the name of your field when you tried my code? :confused: I just opened the sample from your link and I put my code in the onclick event of the cmdSignIn button and it work perfectly when I changed the [YourLoginField] to [txtSignIn]...

I prefer my simple routine for error trapping... Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open MsgBox "testing" Exit_Form_Open: Exit Sub Err_Form_Open: MsgBox Err.Number & " - " & Err.Description, vbCritical, "Form_Open()" Resume Exit_Form_Open End...

To simply open a file, you can use the Application.Hyperlink function. Application.FollowHyperlink "G:\Sales and Marketing\General\Export\Export Lookup.xls" I use the below to open files... Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hWnd As Long, ByVal...

I have yet to attempt to customize a ribbon but here are the commands I use to show or hide the ribbon... DoCmd.ShowToolbar "Ribbon", acToolbarYes DoCmd.ShowToolbar "Ribbon", acToolbarNo

air code... if nz([YourLoginField]) = "" then msgbox"you must select your user name first" exit sub end if

try... Is Not Null

You can delete your own postings. Click the Edit button on the first post in your thread and then select the delete option then click the delete button.

Nobody is offended by your posting. Bob was just letting you know that the reference to searching for you answers is in my signature (see below). I google for the majority of my questions on a daily basis. I post questions here when I have exhausted my searching and need help. Which is what...

try If Format([update],"mm/dd/yyyy") < Format(Now(),"mm/dd/yyyy") Then or If Format(CDate([update]),"mm/dd/yyyy") < Format(Now(),"mm/dd/yyyy") Then

You can use an append query to add a record from one database to a table in another another.

That does not make sense. If the user changes the value of a combo box, whether they move the focus off the combo box or not, the after update event of the combo box will be triggered.

Re: Drag & Drop Docs Form (.doc,.pdf,etc) and Automatically Copy File to Windows Fold Not sure about the drag an drop feature you want but you can do the rest of what you want. You need to design a custom browser into your database. Check out my old Browse [Find a directory or file] sample to...

You can do that in a query, form or a report. You should not store calculated values in a table. Pay attention to how you name your obects. This might help... About calculations in a query

Can you list an example of the different sheet names in your most current file? Is the date used in the second sheet name always the date of the current day?

Column 10 would then be Column(9) since the counter starts at 0.

Re: lete a workbook if it exist From Access Sure it works but it is not the proper way to program your code for handling errors. >>> Error Handling In VBA