Recent content by Connor

  1. C

    Queries within a switchboard and form

    Thanks i'll give her a whirl!
  2. C

    Queries within a switchboard and form

    . are there any tutorials on this site, or online regarding the "OpenForm Method/Action" , as i am a newb with these type of commands?
  3. C

    Error, invalid use of null

    i have a few text boxes. First is ATA which is actual time of arrival (for airplanes), second is inboundFirst (for baggage) and inboundLast. What happens is that if the user enters a time of 13:00, which is then converted to short time, into ATA, and lets say 13:30 into inboundFirst, VB...
  4. C

    Queries within a switchboard and form

    If its possible, can i have a querie that lets the user find a specific record, say based on flight number or flight date (for an airport) right from the switchboard?, I can do this within the main form, but ir returns the table view of the record, which i dont want, i would like the form view...
  5. C

    switchboard

    I have a main switchboard, with a few Open Form command buttons on it, but what i would like to have is another button to bring the user to another switchboard screen giving the option to open a few Reports (obviosly the button on teh main switch board would read "Report Section), can this done...
  6. C

    Finding Current_Date?

    Pat, thanks for your help, i really appreciate it. Do u think if you have some time, and if i post or email you my database, you could take a moment or two and point me in the right direction as to normalization, if i need more tables and so on? Im starting to think that i need an extra table...
  7. C

    Help with possible IF....Else statements

    Well, i am basisng this database off a spreadhseet, and what i have right now in my database works fine i guess, 1 table, 2forms (one of them just repeats itself, but in a different look and style for payroll purposes, and this IS just a sample database, to show my employer advantages over using...
  8. C

    Finding Current_Date?

    can u give some insight on how to do this?
  9. C

    Help with possible IF....Else statements

    i have a database setup already I forgot to mention that the airline is setup within a combo box. SO when teh user clicks on the combo box and chooses british Airways, or Thomas cook, those corresponding baggage times would be lodaded.
  10. C

    Help with possible IF....Else statements

    I have fooling around with an aircraft database i have created. i have 4 fields First Bag Away - first bag time off aircraft and sent to arrivals for pick passenger pick up Last Bag Away - last bag time sent to arrivals Inbound First Bag - first bag time that arrivals receives the bags off the...
  11. C

    Finding Current_Date?

    thanks is there any way to question the user on what date she would like to input? and i take it we cannot add a query into a switchboard can we? anyway of doing it?
  12. C

    Finding Current_Date?

    I have a table, with 4 records in it. 2 records have the "date" field for 01/11/2005, and 2 dates are for 02/11/2005. Is there a way to just query the "current" date? Weather it be in a pop-up box once the query is selected, asking for the date? or is there a restricted word within access2003...
  13. C

    Programming a command button to export data

    Thanks Thank you So much, works wonderfully!! One thing, once exported to excel, the sizes of each row are huge, about 2 inches tall. just a minor thing, nothing to stress about (for me at least, another thing for my employer, haha) is there a way to adjust settings while exporting,? maybe...
  14. C

    Programming a command button to export data

    I know this topic has been discussed, but i could not find one thread on the general purpose of exporting an excel table/form to excel. I would like to place a command button on my FORM, and let the user click this button and export the data into excel. I tried using the transferspreadsheet...
  15. C

    exporting access table to excel problem

    do u think perhaps you could help out with the program functionality of it?
Back
Top Bottom