Search results

:banghead:My database went from 97-2000-2003-2007 in the hope that the References would work once it got to 2007. Alas, that's not working at all. I checked the 2007 References and they match with the original 97 db but I'm still getting an error. When I try to open a form it's giving me...

Good Afternoon, we're running 2007 and the smallest thing has me stumped! Our table field ([Assembly Name]) has some that end in "-RF". But the dash that is pulled from the table in my_RF=Right ([Assenbly Name],3) is different than if I do chk_RF="-RF"! They never match. The table extraction...

:confused:I have a main form which has about 12 pages to it. All the pages have various subforms and fields. Some are input, some are strictly information for the user. I just added a new subform to a page and now suddenly it's showing up on ALL the pages! If I delete it from one of the other...

Hi, I really hope someone can tell us what's wrong here. We are using A97, and it still works too! Well, almost. We create an mde and push it through exe commands that copy it from our server and place it on the users PC when I update the database. We call it Live Update. I have over 100...

I took over someones group of queries in a small personal database and simply brought them over into Access97 database that has lots of tables, reports etc. He had his Date/Time converted to CVDate(format([Date Received],"Short Date")) which when brought into my db gives "Function isn't...

I have really searched the forum yet haven't found a total answer to my problem. I am updating a SQL table and the information is coming from another SQL table. The data being updated with could be null or might have an apostrophe or it might not. I've literally read a mutlitude of posts yet...

Hi, I have searched the forum and the web but either I'm not asking the question correctly or this is the first time anyone anywhere has had this problem! Yeah, right! :) I have a txtbox (unbound) on a form, where I want the user to be able to put in a wildcard selection (12000*). Then click a...

I have a macro that runs several queries, an append query, then two update queries to a table. It then sends that table in Excel format and let's the user specify where they want to save it. The trouble is after it all runs just hunky dorey the screen blanks out and the whole db seizes up! I...

Hi, kinda new to Access and I've hit a wall I'm hoping someone can help me with. Two tables: DOM Repairs and FA_DOM_Repairs. I want FA_DOM_Repairs to update it's fields with only those from DOM Repairs which aren't new, ID is primary in both. I first have created a query for LastOfID from...