Search results

  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?
  16. C

    Update a Date/Time field automatically

    Most likely a newb question, but how can i just update the date/time field to the current date, as opposed to constantly entering in the current date? Thanks
  17. C

    Value of One field Changes ANother FIelds Value

    . Thanks Pat! I'll give it a search
  18. C

    Value of One field Changes ANother FIelds Value

    I am trying this new project out, and i have two fields set up, Both will be drop down boxes. One field is Airline, the next Aircraft Type If the user clicks on the British Airways dropdown link under the "Airline" field, i would the the Aircraft type field to automaticaly pull up only those...
Back
Top Bottom