Recent content by GingerR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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