Search results for query: *

hi very frustrated, i have clicked on the detail section, in the properties box for back colour is #FFFFFF and on alternate back colour is #FFF200 not working. back colour on fields is transparent??? help please... Energy & persistance conquer all things!

hi the built in property thats in 2007. Energy & persistance conquer all things!

hi i have just noticed that the 2007 alternate back colour is not working. it just highlights all the details section?? i have gone into the properties and selected alternate back colour and chosen the colour. i want it to highlight every second row to provide easy reading. can anyone...

hi i got it from the internet. i can not find it in the file above via search???am i looking in the wrong space? Energy & persistance conquer all things!

hi i am trying unsuccessfully to export a query automatically via a button to excel using the below code but i keep getting errors. can anyone see where i am going wrong? very frustrated. thanks query is called exportexcel spreadsheet is SendCarRequestExcel and the sheet name is also...

hi everyone solved the problem. on the form open button i did a lookup of the user number and if it is null i prompted them to add. thanks for all your imput. Energy & persistance conquer all things!

Hi i would like to put on a button an automation for exporting a queries data into a specific excel spreadsheet. i only know the code for importing below DoCmd.TransferDatabase acImport, "Microsoft Access", _ "h:\pcs.mdb", acTable, "Table1", "test", False many thanks Energy &...

hi aceman i had a feeling it was not going to be simple. i am stumped on this one. is there a way then that i can put a code on the button that opens the form in question and if it looks up in the user table and finds the user trying to access the form is not in there then make them go to a...

OH MY GOD what did i do, sorry to cause so much controversy! i must thank you for your input though it has been very helpful. Energy & persistance conquer all things!

Hi i have programed in that whoever the user is for the machine is tracked in a field on the form. so if joe smith is logged on a field says joe smith. should someone log into the form that is not within the registered user table of course it appears as #error. what i need to do is put an on...

hi is it possible to take a name like jim smith and break it into 2 field first name and last name? Energy & persistance conquer all things!

hi yes as this is just starting to get in order there are duplicates in the card no field, i am trying to eliminate this. i will then make it a primary key. is this why? Energy & persistance conquer all things!

hi this is the query SQL SELECT CarParkingList.Building, CarParkingList.BuildingText, CarParkingList.CardNo, CarParkingList.Occupant, DataComparisonTble.BuildingText AS lastMthBuildingText, CarParkingList.Building AS lastMthBuilding, CarParkingList.Occupant AS lastMthOccupant...

Hi i am having a problem running a query that compares last months data to this months data. the tables are the same i just want to see if changes have been applied in the new months data. i am running a query extracting the information using a cardno field that is in both of the tables, but...

thank you worked! Energy & persistance conquer all things!

Hi i have to refer to a client name from another form and the problem i am having is the name on the refered form is John Smith, however the information for the next form i want to bring up has 2 john smiths but one has a middle initial in it, so only one record is being brought up not the two...

thank you so much for your help! Energy & persistance conquer all things!

hi thank you that worked. however it does not group the items. eg smith may appear 3 times as there are 3 smiths in the list. is there a way i can group so only 1 appears? many thanks Energy & persistance conquer all things!

i am trying to create a multi select list box using the below code. i am storing the occupant into a table for use later in reporting, however i keep getting the following error message "Error No 3075 description syntax error (missing operator) in query expression 'occupant = 1 car bay' can...

thank you very much the quick method worked great Energy & persistance conquer all things!