Search results

Reply Yes, users do have there own copy of the front-end from the split. I will check the tables to see if there is any bad records. But, I don't think that will be it, because every time the db gets corrupt, I just replace with a fresh copy. This is a new db, so there really is no records in...

Reply Are you referring to splitting the database, if so? I did that and still had the problem...any thoughts on the version differences? Thanks

Reply for setup The mdb file is on the server and it is shared out to the network users. It is just a shortcut pointing to the mdb file. thanks

Reply for single user The original setup was just one pc and I did not see any problems at all....

I am trying to trouble-shoot an issue with a Access 2002 database. Basically I have the database file shared out on a local network and there are 4 users accessing it. Well, there are using Access 2003 when opening the db file, but every time they exit the db, it is getting corrupted beyond...

I finally got it :) Thanks Pat and RGUY, this was the problem, my destination table, column PRO_NUMBER was not set to AUTONUMBER and my DUMMY SOURCE TABLE, the PRO_NUMBER was set to AUTONUMBER, so before I ran my append query I was not able to edit the PRO_NUMBER in the DUMMY table to the...

thanks for the advise :( Well, the first link is a little advanced for me, I am a bit new to access. The second link sounds more like what I did the first go round and it worked then, but can't seem to get it to work now. Basically what I did was: Enter a dummy record in my first table, it...

wondering if you were able to look at the db just wanted to follow-up

wondering if you were able to look at the db just wanted to follow-up

sorry, wrong url here is the correct one http://www.medicallasers.cc/test/transitsolutions.zip

No luck with the copy idea I tried to copy tables/forms and put them in a new db, but got all kinds of errors. What if you download the db from here: http://www.medicallasers.cc/golf/transitsolutions.zip If not, I can try to create a new db with some of the functions Let me know thanks ;)

Suggestion Any chance I can attach the access db? So you could have a look, it is only 2mb zipped up... thanks David

that seems to be a little much my process was working fine, but it has been a while since I messed with the database. So, I really don't want to re-envent wheel at this point....but I do appreciate the additional options. I think my original was just real simple, but I know I am just missing...

Well, maybe I missed something, that did not work This is what I have, I have a query called auto_number_append and it is suppose to append one record to a table called auto_number, but when I run it, it is not appending a record. The auto_number table is empty before I run the...

Thanks I will give it a try... thanks again

Hi, I have a form with some fields on it, there is one called Pro Number. what I would like to happen is when a new record is created, it starts at a certain number and continues to increment by one. In other words, the first record would be 5600 and the next new record would be 5601 etc. I did...

Success!!!!! Wayne, that did it, thanks a million.... David

No Good Thanks for the additional info, but it did not seem to work....I added the expression to the query in the top line, which is the field: "PROFIT:[RATE_QUOTE]-[TOTAL_CONTRACT_PRICE]-[BILL_FEE]" When I excuted the query, it did pull the data, but the field only showed the string as...

That did not seem to work :( Here is the original Control Source I am using on the Form for my Profit Field: =[RATE_QUOTE]-[TOTAL_CONTRACT_PRICE]-[BILL_FEE] Here is the Criteria I am using for my PROFIT field in the Query: "PROFIT:[RATE_QUOTE]-[TOTAL_CONTRACT_PRICE]-[BILL_FEE]" Hope this help...

Hi, I have a Form with three fields, the field called Profit is based on the other fields. Basically Field1 - Fields2 = Profit Field. That works great on the Form itself, but I built a new Query and when I tried to add the Profit Field, it returned now rows. My query is based on a start date -...