Search results

Sorry, you won't be able to disable it. See microsoft's article related to it. AutoFill has saved me alot of time in some instances; but also slowed me down in others. I agree that there should be a way to turn it on and off.

I just realised it may not be what you are looking for. How is the table setup? Does each boxNumber only occur once in the table? If so, then yes, that thread could be used. (And I could help explain.) If not, then I'll need a little sample of the data. Sorry for confusing ya. :o

I'll bet that you'll have to use customize it in VBA. Check out this thread to see if it will help.

Oops. When I opened a reply this wasn't here yet.. but that looks like another way to go. :)

Howdy Flint! Sounds like you're looking for =DatePart("ww",Date()). The "ww" gives you an interger representing which week of the year it is. As for the Monday through Sunday part, I haven't figured that. By looks of DatePart via Access Help or msdn, you should be able to use a third variable...

Then I've only seen Javascript that had AutoKeys code. :(

Is your code too large to past it all? I'm not as experienced as others so it helps when I see larger chunks. My guess would be a "bad naming convention" with that space in the table name. Would renaming the table and it's instances in your code take too long? Is there a defined recordset? So...

Hm, not exactly sure the code behind it but you'll probably need a check to see if a field is NULL and if it is.... *ponders*... If this was me, I'd either try one large expression with a carriage return after each field that wasn't null or I'd use VBA to gather the data but probably do the...

If you disable certain special keys (ie F11) and make it so the database window does not show, half of the battle of protecting those objects is done. You probably will have to make it so forms only open in Form View as well as the equivilent to the reports. *ponders* That should do it. The...

Maybe it was locked (accidently or purposefully open)? Although just having a table open shouldn't stop an append query. I've had other instances where this has caused queries to halt but not with appends. Hmm. Glad to hear you got it to work. :)

You can get a name (and other attributes) of a column with a property of Fields. rst.Fields(x).Name rst.Fields(x).FieldSize rst.Fields(x).Size rst.Fields(x).Type x being any interger. 0 (zero) represents is the first field/column. Here is one link that may give you more detail.

Is it always tripled? Could you figure out a third of the value and pass that to to the Access report writer?

Yup! But with prices, do you really want to truncate? Your employer's profit is reduced by a teeny tiny amount if you cut off the thousandths and on decimal places. =Trunc([price],2)

If the text data is larger than memo's data type, I believe the only option is an OLE Object. (Up to 1 gig!)

Did that work for you EmmaJane?

Let's say we have these tables & fields: tblNadalia-01 txtOne txtTwo numThree tblNadalia-02 txtOne txtTwo numThree If you want to append tblNadalia-02 to tblNadalia-01.. 1) Query -> New -> Design view 2) add tblNadalia-02 to the query 3) change it to an append query 4) Specify you want to...

Yeah, you've stumbled across the biggest reason why I like C/C++ over VBA. You can easily include any previously devised code in .cpp file with one simple #include statement. Anyways, I'm not positive if this will work with the AutoKeys macro but you can give it a shot. 1) Open Access, 2)...

Even when the form is set with Data Entry = Yes? (It's not working for me.)

That's what I'd use: Append query. (Tables don't even have to be 100% alike when using the append query they just need to have matching fields.) Want to either attach the db and we can take a look? Or explain the design of the query?

So you want to grab the last record's value of the boxNumber field in the table? Then use that value+1 to auto-set a value on the form? Form is set Data Entry = Yes?