Search results

Was wondering if you could can set a data source for a form or report programatically based upon the certain criteria , which cannot be captured in 1 query for example if my criteria is a date range in Form A then open Form/Report B using query A if ny criteria is to filter on a customer in...

error message runtime error 2465 ms access cannot find the field "¦" in your expression just trying to append fields to an existing table

No doubt my syntact has errors, have changed it but still get the error message This was the original query created in access SQL View INSERT INTO TblTempContractInvoices ( nextInvoiceDate, Contractnr, CustomerId, [End], Invoicevalue, Invoicecycle, compname, compaddress, compcity, comppostcode...

I keep getting an error message when running the bolow code? Any idea why? strSQL = "INSERT INTO TblTempContractInvoices (TblContract.nextInvoiceDate, TblContract.Contractnr, TblContract.CustomerId, TblContract.End, " & _ " TblContract.contractvalue, TblContract.Invoicecycle...

If have trouble with my Dlook upcode and I am stuck Invoicelabour = Yes/No field ContractNr = Text field ServicecontractNr = text field When I run an after update event I get the runtype error type mismatch on the chargelabour = … line Dim Chargelabour As Boolean Chargelabour =...

I got a multilingual database. The translations are in a tbl TblTranslations I use a global variable to set the language (gblanguage) on login I have various reports which include subreports. The labels of the reports require to be displayed in the appropriate language. I use a query to filter...

thanks so obvious it is actually painfull but now I get the message "cannot find the field "|" refered to in your expression" changed code to Dim db As DAO.Database Dim rs As DAO.Recordset Dim f As Date Dim g As Integer g = 365 / (AvgRunHrs / ServiceInt) Set db =...

I have a table TblServicebySerialSummary one field is a next service date. the interva is based on the formula (365 / (AvgRunHrs / ServiceInt)) I want to take the first date in first record of the field [plannedServicedate] to stay as it is, but the next record the date should read + (365 /...

It is the coding that is required to filter the view of all these unbound boxes to show a specific employee

THANKS I want a filtered view for a specific employee, ideally I filter on the calendar form, hwr if that's not possible in this format then a filtered view when opening the calendar form.

Hope somebody can help me. The database shown in this thread is simple and very usefull. I would like to add however a functionality I could assign an entry to a specific employee. When I open the calendar form I would like to select which of employees entries I would like to see etc. I suppose...

I have some basic self taught knowledge of SQL query design, but unfortunately I require some more advanced knowledge. Can anyone recommend some (free) tutorial / help online?:confused:

I have a combo field that has its properties set to "Limit to List" = yes. I would like to add an on enter event where I could make an exception eg if me.type = "AAA" then notinlist = false else not in list = true end if Now from the above it is obvious that I don't know the code to switch the...

I run a vb script that finds and delete files. This works fine as long as the directory is correct. The problem is that I have users who uses different language versions of windows. The english version is C:\program files The German is C:\programme etc Can I use s System directory name that...

Yeah the strech is ok for enlarging, but not for shrinking. The problem is that some bmp or jpeg files are relatively big, when you want to use it for Logo's. Yes by using paint or other programs you can shrink the image, but I was wondering if it was possible in access. Word and excel are much...

When importing an image (jpeg or bmp) such as logo's access doesn't seem to resize the file/image to fit the object. I have an unbound object in a report that linkes to a path in one of the tables. When I change the path in order to change the imigae I want displayed the image file must have...

As usual I ended up taking the long route I tried Dim Location As String Location = Environ("ProgramFiles") & "\compair service management\Help CompAir Servicing.chm" Shell "HH.exe Location", vbNormalFocus it called the HTML Help program but did not displayed the contents ended up with...

In my database I have a help File which has been created using HTML helpworkshop I call the program using the following code 'Shell "HH.exe C:\program files\compair service management\Help CompAir Servicing.chm", vbNormalFocus The problem I have is that my database is distributed to Germany...

i distribute an database application with 1 front end and 2 backend databases to customers with reletive sensative pricing information. To keep it out of the wrong hands it is password protected, the shift key is disable etc, however when you link through a new database you can still see the...

Thanks, sorry for late reply but have been away from the work place for a while. It looks interesting. Would you have a sample of coding the function Not that familiar yet with ADO coding. Thanks