Recent content by robcarr

Hi, I have a MySQL database which looks like this: ID | NAME | DESCRIPTION | DRESSINGS ---------------------------------------------------------------------------------------------------------------- ham_and_cheese | Ham and Cheese | A sandwich with...

majp - I checked that on the popup and it shows a record matching missingling - I will check and see what happens, that seems to make sense Hope this is of use, Rob.[yoda]

an auto generated number Hope this is of use, Rob.[yoda]

I use this function which I access via a button on my maintenance form Function LDBViewer2010() 'Reference Microsoft ActiveX Data Objects for this code to work Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Const conDatabase As String = "L:\HR Database\Employee Management...

Hi, Access 2010, split database, multi user (no more than 10) at a time, they access through the front end, the database is saved as accde format I have a user form which is used to log absence records at my place of work, the form can be accessed by clicking a button from the main form, or...

ill have a check and let you know, the annoying thing is works on 40 pcs but not the others Hope this is of use, Rob.[yoda]

it shows no spaces the * are exactly either side of the username on mine and on the user who cant get it load, but it does show his username in between and it still loads blank it cant locate him, and he does exist in the database table Hope this is of use, Rob.[yoda]

here is the coding for the form load event DoCmd.Maximize Forms!frmmainpage.Text22 = GetUserName If Not CommandBars.GetPressedMso("MinimizeRibbon") Then CommandBars.ExecuteMso "MinimizeRibbon" End If DoCmd.ShowToolbar "Ribbon", acToolbarNo Call SetEnabledState(False)...

Hi, I have a database that is used to log absences, I use the users network login to identify them and display data that is held about them within a specific table (tblusers), the database has started to fail when it opens for a random select group. the main form is a bound form using this...

that worked so simple when its in front of you Hope this is of use, Rob.[yoda]

Hi, I have a form that is used to enter absence records, fairly basic but does the job for that. When the form loads it loads to a new record, when an employee is chosen it checks the database to find all open records, these are then displayed in a sub form, this works fine. If a record is...

will look to change the reserved word for field names, thanks for reminding me Andrzejek. Skip it finally works, thanks for this. Rob. Hope this is of use, Rob.[yoda]

changed the coding so you can see all debug prints strSQL = "SELECT * FROM tblBPData WHERE ((Date)=date()-4);" ' this works strSQL1 = "SELECT * FROM " & TableName & " WHERE ((" & FieldName & ")=date()-4);" 'this works strSQL2 = "SELECT * FROM " & TableName & " WHERE ((" & FieldName & ")=#" &...

debug prints from the coding this is the first sql string SELECT * FROM tblBPData WHERE ((Date)=date()-4); this works this also works the second string SELECT * FROM tblBPData WHERE ((Date)=date()-4); this doesnt work strSQL = "SELECT * FROM " & TableName & " WHERE ((" & FieldName & ")=#"...

skip, I am getting concerened at all your answers on my threads, they are always in an aggressive tone, I am sorry I dont put the words/descrption down how you like it, I do my best. I had stated the date variable was set as date, and i tried it as a string "date has been defined as date...