Search results

Hi, No it did not work, you land at the root!!

Thanks for your extensive answer, it makes it more clear. What is the difference between single and double quotes???

This is still the fixes string solution, I was looking to use a variable I can change over time without having to enter the code.

Thanks for the answer, but do I run the docmd.openquery before the docmd.openreport?? I want to print a single selection to a PDF!

It's clear the problem is the IIF, but i don't see the solution??

My version is Access 2016

good advise!! I do get the error "Operator missing" problem is in the IIF clause. When I took those out it worked. I do need the IIF to make the system readable!

Operator missing error I've set up a query to filter the results of the second Combobox. this works fine it I write the code by hand. When I use the query with a variable, it does not work anymore. the problem is probably the where clause, so I focus on that one: "WHERE tblCompany.CompName...

I get an error opening the database, no such Sub of Function on GetUserDefaultLCID()

To save and send a report I use: DoCmd.OutputTo acOutputReport, "rptReportName", acFormatPDF, strFullCurPathFile, False The variable strFullCurPathFile is the full path and file name where I want to have the file: "C:\Users\...458\CES3458.pdf" I do get an error processing the line: Error 2059...

I've found some code to find a directory with a browse function. It comes down to the next line: sBrowsingPath = strDefaultFolder Set objShell = CreateObject("Shell.Application") Set objfolder = objShell.BrowseForFolder _ (WINDOW_HANDLE, "Select a folder for exporting...

@Grumm, Thanks!! it was as simple as that. good lesson for the future!!

I can't open the example database browsing.mdb from ghudson as this was made in an earlier version. Any updates on that one or a work around

Below the lines of code I'd put in to find default settings after opening a database. Public strWindowUser As String strWindowUser = Environ("username") strSQL1 = "SELECT tblDefault.DefaultID, tblDefault.DefaultUserId, tblDefault.DefaultDate, tblDefault.DefaultCur...

Hi CJ, Get an error in Private Sub Report_Load() Dim lcid As Long lcid = GetUserDefaultLCID() Me.Label0.Caption = getcaption(lcid, "Title") Me.Label1.Caption = getcaption(lcid, "Name") Me.Label2.Caption = getcaption(lcid, "Surname") End Sub It does not recocnize the sub or finction...

Big Thanks!

Hi, I can't download the file, it sais attachemnet.php How can i get the file?

Hi CJ, So far I have nothing, I still need to build it, I'm trying to do this one time good, so I'm trying to find out how I best set this up. I know the language the report has to be in. I just want to use 1 report meaning I build the report with phrases depending on language from a...

Hi CJ, What I think is the best way is I have a table with X coloums, ID, Dutch, English, French, German,.. Depending on the clients native language I take the data for that language. I don't want to change the database layout, just the data in the report. I prever I have a single report...

That way I have to build each (I have many) report 3-4 times. I was looking for a single report solution, changing the contents based on the client language available in the query the report is based upon. This might be difficult, but that was the first goal.