Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GirlBlonde

    Alternate Line row shading

    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!
  2. GirlBlonde

    Alternate Line row shading

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

    Alternate Line row shading

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

    Export to Excel Code problem

    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!
  5. GirlBlonde

    Export to Excel Code problem

    ...query is called exportexcel spreadsheet is SendCarRequestExcel and the sheet name is also SendCarRequestExcel DoCmd.TransferSpreadsheet acExport, "MicrosoftExcel(*.xlsx)", "[[Exportexcel]]", "[[SendCarRequestExcel]]", False, "[[SendCarRequestExcel]]" Energy & persistance conquer all things!
  6. GirlBlonde

    refer to a field coming up #error

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

    export automatically to excel

    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 &...
  8. GirlBlonde

    refer to a field coming up #error

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

    splitting fullnames into first and last name

    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!
  10. GirlBlonde

    refer to a field coming up #error

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

    splitting fullnames into first and last name

    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!
  12. GirlBlonde

    data Match Query

    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!
  13. GirlBlonde

    data Match Query

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

    data Match Query

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

    Reference to surname only

    thank you worked! Energy & persistance conquer all things!
  16. GirlBlonde

    Reference to surname only

    ...smiths but one has a middle initial in it, so only one record is being brought up not the two relating records. how can i bring up both records in this instance. i can not seem to do a like *forms![form]![field] in the query. greatly appreciate any help. Energy & persistance conquer all...
  17. GirlBlonde

    multi select list box access 2007

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

    multi select list box access 2007

    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!
  19. GirlBlonde

    multi select list box access 2007

    ...As Variant Dim lngID As String Set lst = Me![ListOccupant] 'Clear old temp table DoCmd.SetWarnings False strSQL = "DELETE * from cboSelectOccupant" DoCmd.RunSQL strSQL 'Check that at least one contact has been selected If lst.ItemsSelected.Count = 0...
  20. GirlBlonde

    Alternate Line row shading

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

Part and Inventory Search

Back
Top