Search results

  1. W

    (2007) easiest way to include query criteria in a query form

    build your query and build the form /report the query info dumps into add one unbound fields for a single criteria or two unbound field for a range like a date range to the form or report, name the fields (ex: date1 and date2) change the tab order to start with the unbound field,for a range put...
  2. W

    need help making a query(s) to categorize time between ship date and repair date

    I have a repairs db that records [serial number] and [date in for repair], and other info. I've been asked to make a report to summarize the number of units [serial number] that come back for repair by time interval between [ship date] and the first [date in for repair]. the [serial number]...
  3. W

    selecting contents of field so contents are replaced upon keystrokes

    found it! simple clear all events for the field and set the on lost focus event to requery macro. this makes any form where you want the query select field to be on the form produced by the query super easy. put an undefined field on the form. set the initial select query for the form to look...
  4. W

    selecting contents of field so contents are replaced upon keystrokes

    Hi, I have a form and sub forms with a Serial Number field (unbound field, 1st tab order position) that is used as the look up for a query that fills in the form the Serial Number field in "after update" event is set to do a requery macro This is easy and works and fills in the rest of the form...
  5. W

    Retrieving Textbox Data Into A Table

    I'd like to do something similar with 2 date textboxes I want the dates to apear on a summery form that is generated from a query. I know most advanced users poo-poo the use of textboxes but they are simple and useful for non coders and users.
  6. W

    Print one form per page when printing series (not wrapping)

    found it right click on the form in Design view go to properties, this opens the section detail window set "Keep Together" as yes
  7. W

    Print one form per page when printing series (not wrapping)

    There has to be a simple way to do this, but I'm not finding it. I've set up a query to print test result sheets in a serial # range. the results are dumped in a form for each serial # when I try and print the range of tests, the forms are wrapped from one print page to the next. I've tried to...
  8. W

    excel Between[]and[] query only works if not saved??

    GOT IT!!!!!!!! I scanned the entier excel column for the Third time a 0 was entered o 2 years ago so any letter in a number column will only keep the code from working once it is saved, not before. I assumed that since the code worked before saving it could not be a leter in a number column issue.
  9. W

    excel Between[]and[] query only works if not saved??

    the error is "Numeric Field Overflow" the table field is a numeric serial#, excel column cell format is number, no decimel again this error occurs only after the query is saved, it works unsaved
  10. W

    excel Between[]and[] query only works if not saved??

    so the query works fine on another sheet in the same excel file. WTF!?!?!?! went through and deleted all the conditional formating in the excel sheet, that didn't change the query behavior.
  11. W

    Counting Categories in Columns

    sure, read the above again cause I edited it a bit to make sure you get it the first time:)
  12. W

    Counting Categories in Columns

    I just did something similar you want to do an if then statement to change the information to numbers then sum the results first bring the information into an access table then you make a query on the table use the "create a query in design view" in the "Field" line of each column you write a...
  13. W

    excel Between[]and[] query only works if not saved??

    rebooted, deleted the query deleted the excel link, looked over the excel file, re-linked to access 2002-2003, re-wrote the query still no workie after I save, just before I save
  14. W

    excel Between[]and[] query only works if not saved??

    I'm gunna shut down and reboot, maybe I've been screwing around in the db too much this morning
  15. W

    excel Between[]and[] query only works if not saved??

    no text, cell format set to number in excel, I have empty cells in the column,,,,,,,,is this the cause? again, the query works until I save it, only after I save it does it give the numeric overflow error. if it was something with the excel firle why woould the query be able to work at all?
  16. W

    excel Between[]and[] query only works if not saved??

    I do not get the numeric overflow error if I import the excel table instead of linking to it.
  17. W

    excel Between[]and[] query only works if not saved??

    the issue is has not changed
  18. W

    excel Between[]and[] query only works if not saved??

    SELECT [XRS-3 new unit Test Log].[serial#], [XRS-3 new unit Test Log].B, [XRS-3 new unit Test Log].C, [XRS-3 new unit Test Log].[D ], [XRS-3 new unit Test Log].E, [XRS-3 new unit Test Log].F, [XRS-3 new unit Test Log].Date, [XRS-3 new unit Test Log].[tested by] FROM [XRS-3 new unit Test Log]...
  19. W

    excel Between[]and[] query only works if not saved??

    what's a SQL? sorry I'm ignorant about access still. I just converted from 2000 format to 2003. I'll see if that takes car of the numeric overflow problem.
  20. W

    excel Between[]and[] query only works if not saved??

    I'm running office 2003
Back
Top Bottom