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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by GingerR

  1. GingerR

    Access table column indexing

    Hi--ok, this is screaming for me to ask: 36 tables? Can we see your table structure? Seems like it might not be normalized? Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  2. GingerR

    Output to HTML

    http://www.tek-tips.com/viewthread.cfm?qid=757240 Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  3. GingerR

    Random Message Button in Form

    Hi there--what have you tried so far? What is your table structure of "table1"? Thanks. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  4. GingerR

    Password Generator

    Add two lines to the button code: txtpword.SetFocus txtpword.Text = PasswordGenerator(8) txtpword.SelLength = Len(txtpword) DoCmd.RunCommand acCmdCopy Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  5. GingerR

    Password Generator

    Looks like all you need to do is change the 3 to a 4 in this line: iAsc = Int(3 * Rnd + 1) then add another Case statement for the 4. Then just use the same line of code as the others, but put in the lower and upper bounds of the character numbers you want from the character set. This is...
  6. GingerR

    IF

    I have a basic question, unless I am misunderstanding: are you copying a record from the original table to a second table that is for Submitted For Approval? If so, that is bad database design. What you will want to do instead is have a STATUS table, perhaps a record can have more than one...
  7. GingerR

    IF

    what do you mean by "corresponding line in the form"? An actual line? or do you mean a record? For your button code, what have you tried so far? Have you tried dlookup? Is what you mean is that you want to push a button on a form, and the form you are on has a recordsource and you want to see...
  8. GingerR

    Convert 2 blanks to 1

    An example would help. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  9. GingerR

    Record Set - Add a record does not always add to the end of the file

    if you compact a db and there are no records in the table, the id will begin again at 1. However, what Joe says is true....what does it matter? just don't export that field. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at...
  10. GingerR

    Record Set - Add a record does not always add to the end of the file

    I understand, what I mean this: You say you have a text file that you are importing. How about importing it into an existing empty table that has an autonumber field? then the records will be imported in their current order, and records added will be at "the end" in the order that they are...
  11. GingerR

    Record Set - Add a record does not always add to the end of the file

    how about when you import them, you put it into a table that has an ID (Autonumber) field? Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  12. GingerR

    Macro Creating Backups on Flash Drive

    in your error handler, trap error 76 Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  13. GingerR

    Showing only some iterations of a control/field name in a form

    Try setting your HIDE DUPLICATES property to Yes. I'll have to think about your other issue. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at http://r937.com/relational.html
  14. GingerR

    complicated data retrieval process

    Hi Tom--sorry for your loss. Take a break and get back to it when you can. If you can post the db some place, or compact it and send it to me some time, let me know. datachick10 at hotmail. g Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244...
  15. GingerR

    Query Time Duration when endtime is midnight

    Hi--what is the FORMAT of your time data? I made a little table and made the StartTime and EndTime be "Medium Time" format, and your formula worked fine. StartTime EndTime Duration 12:00 AM 7:00 AM 7 1:00 AM 6:00 AM 5 12:00 PM 7:00 PM 7 Want to get great answers to your Tek-Tips questions...
See more

Part and Inventory Search

Back
Top