Search results for query: *

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...

datefield is the value that appears in c1 on the spreadsheet, c1 is entered as a uk date on the spreadsheet Hope this is of use, Rob.[yoda]

Hi, I am trying to import data into excel and I am using a DAO copy function to get the data, but I am having a problem with dates, this is what i have tried with the sql string 'strSQL = "SELECT * FROM tblBPData WHERE ((Date)=date()-4);" ' this works 'strSQL = "SELECT * FROM " & TableName & "...

HI, I am struggling with getting automation of ie with vba, I have done it many times with url's and clicking links on a page, this is a different problem Everytime I go to a certain URL, it pops up straightaway with a Login and password box, all coding I have tried just halts at this point...

i'll try that tomorrow when I am next in the office Hope this is of use, Rob.[yoda]

Hi, I have a continuous form which displays a count of all records for all LineManagers in my database, I have six different columns depending on the AbsenceType's (sick, awol, late, etc) If I double click on the total column the desired form opens up with all the records for the LineManager...