Search results

EmpIDLogin = DLookup("[empid]", "tblemployee", "[userid] ='" & Me.txtUserID.Value & "'") The expression you entered as a query parameter produced this error. What im trying to achieve is that each user has a tick against what cmdbutton they can access on the nav form. so i can add and take...

Hi I'm using the following to get a users id number once they login - that part the first line works. however now i want to use that number to check in the permissions table to see if there is a tick in the 'EnterTrade' field and if not then do some action however i cant seem to get it tot work...

Hi, Its printing out the whole string yet still fires a syntax/missing operator error, when i paste it into a blank query in builder and format it it runs as should?

Probably a really simple one however i just can spy the missing part hopefully one of you guys/girls can? Any help would be fantastic.. Dim AppendUsers As String AppendUsers = "INSERT INTO tblPermissions ( empid )" & _ "SELECT tblEmployee.empid" & _ "FROM...

Hi i now get undefined function 'getsystemid' in expression?

Hi i have the following function declared however cant get it to work in the sql string.. Public Function GetSystemID() As String GetSystemID = fOSUserName End Function however cant get it to return the required value in the SQL string.. DoCmd.RunSQL "INSERT INTO tblLogs (LoginUser...

hi, ill try to explain a little better, i input into a table deptid and required skill, i want to find a way on entering data that the same combination of deptid and skill cant be added twice? the code above is how i enter the data, a combo box for dept and a listbox (multi selection)

Hi, I currently assign multiple 'skills' to departments using a listbox and a combo using the following code Private Sub cmdSaveReq_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As Control Dim varItem...

Hi, Date(DTime) throws up an error with the wrong amount of criteria when i try to put it into a new column as field

Hi, I've tried to iput my tables and fields into that query to get it to work however im struggling, The first part i think ive got ok is; SELECT public_salesdetail.happened, [fname] & " " & [lname] AS employee, public_employee.id FROM public_employee INNER JOIN public_salesdetail ON...

Hi, thats what im looking for, any difference between times per empid that exceed 30 mins - there should only be one per employee per day.

Hi, I have a table which has a primary ID and then date/time then an empid field relating to an empid table, Is it possible to design a query to return all records per empid which exceed 30 minutes for the last 30 days? or even 'today' or a specified date whicever is easiest?

Hi, Apologies for a lack of info, this is the code i use on my other db for my report but altered to suit this one.. ' Create underlying recordset for report using criteria entered in ' EmployeeSalesDialogBox form. Dim intX As Integer Dim qdf As QueryDef Dim frm As Form...

Hi, When i try to open my crosstab report i get the above error, the same dynamic report works fine in another db file however im stumped by this one, anyone able to help?

Hi, When i run the following code to open my report a receive the following error.. error 3070 the microsoft access database engine does not recognise " as a valid field name or expression strDocName = "rptBarcodingMonthly" MsgBox strDocName DoCmd.OpenReport strDocName...

Hi, Thanks for your reply i was just about to mark this as solved as i had set the recordset wrongly in the report :) However im having another issue with this loading the report now strDocName = "rptBarcodingMonthly" MsgBox strDocName DoCmd.OpenReport strDocName, acViewPreview...

Hi, I'm using the following code on_open of a report which works fine in another DB however when using it here i get the above error. Private Sub Report_Open(Cancel As Integer) ' Create underlying recordset for report using criteria entered in ' EmployeeSalesDialogBox form...

Hi, In my main database i have many departments and each is measured on activity/time and in the current format which they want to keep is displayed as.. columns of dates, rows of names and activity/time (stats) displayed for each employee that day and then to format them in a way to show they...

Hi I've just tried your suggestions and im still getting the same problem, this is just an example file im working with at the minute before i implement it into my main database for work, ill upload a copy to let you see exactly what i have.

Hi Its in the crosstab query itself which runs when a cmdbutton is clicked.. PARAMETERS [Forms]![Switchboard]![txtdate] DateTime; TRANSFORM Count(tblReductionByPhysician.PatientID) AS NumberofPatients SELECT tblReductionByPhysician.ReductionGroup AS Reduction...