Search results

To reset Autonumber, you need to delete the current records from the table, and then compact and repair the database.

Hey spike -- why don't you stop bullying people and talk to them like a human? What's the matter --- picked on too much as a kid so you bully people online? D**chbag.

Although I do admit that I'm the dummy for not thinking of the blank versus null thing. I do appologize for wasting anyone's time on such a stupid thing on my part.

Thank you Alansidman. I will head this in the future. And thank you for not assuming I'm an a$$hole, but rather just a newbie, who does have a lot of experience and can help others out with their problems, and be someone of value on here to others hopefully. There's a nice way....and a mean...

You must be in management. Are you trying to say that what I should've done is add to my post that "hey guys, I'm looking for a speedy response, so I did post this in several places, so if you don't have time to look at this right now, there are others who most likely will either here or...

You mean posting in more than one forum is disrespectful? I'm sorry, but I have a VP breating down my neck and I wanted to find help as soon as possible so I thought I'd widen my chances by posting to more than one forum. Didn't know that wasn't allowed. As for not stating that I found the...

Yes, another forum actaully suggested the same thing about 10 minutes ago and I found it......some users are entering blanks in fields instead of skipping them. Thanks!

Yes, exactly correct. The data types in the "doesn't work" tables versus the data types in the "it works" tables are the same. So there must be something in the values of the fields themselves. I was seeing if anyone else has ever had this happen, and if so, and they solved it, what the issue...

Thank you, but I am "worked up" to what I want. I designed this sql, and it works. In no less than 6 DBs, with 12 different tables (6 pairs). So the sql is fine. I'm trying to discover why all of a sudden it's not working with these two tables, when their design is the same as the others...

Can't figure this one out. I have a left table with field "Product". I have a right table also with field "Product", but also many other fields. If I left join on "Product", I want all products from left table to show. If no match in right table, I want nulls. Has worked a dozen times before...

I tried the jstreet and the macro to change links, and it does work, but you still have to navigate to EACH database where you want to re-link from. I'm looking for code that says "okay, in each link for each table in this database, replace the "\ \ A" portion of the link with " \ \ B". Is...

Thanks, I'll give it a shot. I have no choice but the current set up. We get one, and only one, database (Access) that is allowed to be "hooked up" to Business Objects software. We need many tables linked to Bus Obj, so we have no choice but to use one database with tons of tables linked in.

Access 2003, Windows XP Here's the problem: I have a ton of table (200) that are linked IN to database X. They are linked from: \\ a \ many different levels of folders here \ database.mdb As of today, they migrated my A drive to the B drive. So all the links are broken in database X. Is there...

Yes, I have it as a conditional macro. The form opens with the cursor in the date field. When the focus moves off that field, the macro runs and pops up a message. Now I'm trying to get it so that when they click OK on the message, it brings them back to the field they need to enter (i.e...

Thanks. No, that didn't seem to work. However, I came up with a macro - IsNull([Forms]![FormMaster]![RepMo]) that displays a message when that field is skipped.

There is none - it's blank

The field is a text box on a form though - no table (that I know of).

I don't see that property under the All tab.

Is Null allows me to tab off the field without entering anything. In addition, when I do enter something and tab off, I get the validation text. So it seems is not null works better - it does everything right, but will allow you to tab off if you don't enter somethign first.

Hello, I can't seem to find a solution to my problem. I have a text box on a form were the user inputs a date. If they skip this, then that's bad. So, in design view of the text box, I have set a validation rule of "Is Not Null", and validation text of "A date must be entered". It works...