Search results

I know I probably have my syntax messed up here so I figured I'd post it. I have a "Reports" form with a tab control. I have a "Main" form with various command buttons. Based on the command button used, I'm trying to open the reports form to a specific tab page in this manner: stDocName =...

I could, yes. And have. Just doing something different this time.:D

Absolutely. That would be my preference. But I have an ulterior motive for doing it this way. I am unlocking the record for editing in the double-click event. That way admins can edit incorrect fields. Thanks again Paul. Craig

Ahh yes.... I should have caught that. DOH!! :o Thank you.

Hi everyone, I was wondering if I can solicit some ideas because I am sure I am going about this incorrectly. I have a subform in a form. The subform is in datasheet view. In the "Form_Current" routine, I am trying to lock the controls if a record exists, but unlock the controls if it is a...

I thought it might ignore it. Just haven't had time to try. :D Thanks

I haven't tried it, but what happens when the "AutoNumberFieldName" exceeds 9999? You're allowing 4 characters, so what happens on record 10,000? Just curious.

I may have misunderstood, but it sounds like you are trying to join the auto number fields (RecordID) in each table. I don't think that's possible (one-to-many). If I am reading correctly, you'll need a foreign key in the sub tables to accomplish this. Something like: [Main Table] RecordID...

Does the attachment I put in work for you guys? It works here. Something has to be different. If you want attach yours and I'll look

You're welcome. I assume the Log in worked ok for you?

I use RecordID as Long Integer (Auto Number). Is yours the same? Do you have a RecordID on your form? Do you have the "Microsoft DAO 3.6 Object Library" Reference enabled? Here is a copy of mine. Take a look and see what's different.

Did you rename your button? Logical to check the on click event of the button to see what's up. Attach it so we can take a look

Try this.

If you've created a new workgroup file (mdw) you probably forgot to rejoin your original system.mdw. Use the new file for that 1 database only.

Make the "Customer Name" in your customer table Indexed with no duplicates (or make it a primary key) Link "Customer Name" in the customer table to the customer name in the other tables, (One to many, enforce referential integrity, and cascade update). That should do it.

Yep it's definitely weird. I have found a few threads on it, but no real solution.

Here's something I've never run into before. When I came to my present job, I had to take some steps backwards to Office 2000 from XP and 2003. Here's an issue: I'm in the middle of creating a database which is on the network. For troubleshooting purposes, I have the db open to enter data (not...

I believe I found this link in this forum somewhere. http://www.geocities.com/jacksonmacd/ The "Security Paper" gives quite a good overview.

You can use the DatePart function to extract the m, d, and yyyy. Then you can put them together in any arrangement you want to. I think it will extract correctly regardless of the user's settings. Not the best solution, but you can have the users have 3 different inputs. A separate drop down...

I'm not sure how Access 07 is but I know in previous versions that even if the "compact on close" is checked, it won't actually compact unless you are the only person using the database at the time. If the database is split, does the "compact on close" actually compact when multiple users are...