Search results

Hi dave. This is more for my own learning than a task. I'd like to show my boss the benifits of what access can bring in a workable solution. If he agreeds to take it further then I would speak to a professional. I'm just getting involved as I enjoy learning and find all this really intresting.

Yes sorry i did mean delete the records not the table, has anyone got any links to info on getting that information split into the other tables??

I attached a pdf of the relationship report.

right this is now what ive got this is what im importing and if its needed TblFuelUsage ID Keep Account Keep DateDrawn Keep Card Keep SiteName Keep Transaction No Keep RegAtSite Keep RegOnCard Not Needed DriverOnCard Not...

So export everything into a table, move parts into there relevant tables then clear the temp table??

Hi all im designing my first ever database, and would like to know the best way to import data from excel which isnt normalised. below are the headings in excel and also what time of information which would be in each column, this report comes from Esso every month, so i dont really want to play...

Great explanation, i could understand why i wasnt able to pickup the ID if i had the first and last name, as i didnt understand that the cbo was a query so needed the ID in that query, but i guess its like everything with access now you have explained it, it seems so obvious that thats how it...

so your putting the id column in the sql statement so you can select it from the bound column. without that added you would just return your statement so it would be Dean Robinson?? Sorry i know im asking alot of questions but i dont like the idea of just copying a line of code and not trying...

ok so i cant still user the PK for that record as my bound column Below are my first 4 columns in TBLTechs. The number is want to return is 1 in the ID column but show Dean Robinson in the drop down. ID TechID FirstName Surname 1 82740 Dean Robinson

Thank you for that, one question, where does the TBL_Address come from?? so does this create create a virtual field somewhere for the cbo to lookup??

How would that be typed in the Row Source Property??

Hi all im trying to open a form which will only show records where the CardNumber has not been entered, im using the below code but its openning the form and filtering ALL records???? any ideas. Private Sub Command9_Click() DoCmd.Close acForm, "FrmFuelCardManagement", acSavePrompt...

Thanks Dave. I decided to take the following approach, on my new starter forms there is the fuel card required tick box, if that is ticked then it generate an email to order a card and uses a slq insert into to add a record in the fuel card table stating the date ordered. then i added a...

Hi, ive got a problem with a combo box, its in an assignments form, so on one side i have the tech, and the other a fuel card. both are on drop down boxes for my techs without a card and cards that have not been assigned My question is i want the combo box to display two fields, i can get two...

ive now done that with the below code Private Sub NewStarterSubmit_Click() Dim sSQL As String DoCmd.RunCommand acCmdSaveRecord DoCmd.SendObject acForm, "frmNewStarterForm", "Excel97-Excel2003Workbook(*.xls)", "deanrobinson@comex", "pauldavis@comex", "", "Please Can You Order A Tech ID...

ive still managed to do it wrong?? sSQL = "INSERT INTO TblFuelCard (DateOrdered,OrderReason) values (Date(),""Card Ordered For New Starter " & [FirstName] & " " & [Surname] Im getting a syntax error

Sorry one more question, how can i concatenate two fields from the form into one of the value fields of the sql statement. in the field order reason, i want it to say Card Ordered For New Starter & "FirstName" & "Surname"

ok thank you, ive now got it working with Private Sub NewStarterSubmit_Click() Dim sSQL As String DoCmd.RunCommand acCmdSaveRecord DoCmd.SendObject acForm, "frmNewStarterForm", "Excel97-Excel2003Workbook(*.xls)", "deanrobinson@comex2000uk.com", "", "", "new start", "new", True, ""...

Sql Statement Syntax error????? Hi all id like to be able to enter a record in my fuelcardtable when i click a button on a form, im using the below code, which is run with the RunCode part of a macro. The object doesn't contain the automation object 'clsFuelCard.' You tried to run a Visual...

Hi all, what im trying to do is link some tables used to order a fuel card, So in my Employees Tbl (TblTechs) i have a field saying FuelCardRequired, when you use a form to raise a new starter the FuelCardRequired being TRUE when submitted creates an email to order the card, now my issue is...