Search results

Make a copy of the database somewhere, rename it and then just delete what you don't need from it. It is going to be the quickest way. K

Okay stupid question time... How do you develop without seeing the data? Is it items that are considered private in nature like managment reviews? You are going to need some data to build forms, queries and reports. So why wouldn't you want to see the data? K

If you don't want to split the database. Just copy the db to a different folder or drive. Rename the thing and just delete what you don't need or want. Leave the tables you need and go from there. Far easier I think than what you have been trying to do. I would split the database if you are...

Not to mention you are creating a nightmare for record keeping. I am in the process of resigning our Associate db in my unit. We have time card numbers, teller numbers, numbers for this, numbers for that. You get my drift. I have the db assigning everyone a single number that does not change...

If you are college student, the college bookstore might have it at a discount. Might check with your Company they might have a deal with Microsoft where you can get a copy because your Company has a lisence. We were able to purchase a copy for $20 bucks from MS. K

Might also want to go in and see what you can clean up or make run better. I am currently going over all our inhouse databases and cleaning them up. Four people worked on them before they came to me, it is amazing how quickly thinks get mucked up. I am a stickler for naming convention and...

Delete the information and compact and repair the database. It should go back to 1 as the first record. K

If the reports are exactly the same meaning information is pulled from different tables and queries but will appear in the exact same report (ie they have have a field called name and address but come from say a supplier table, shipping table, customer table), yes. But I am still trying to work...

It works great if you are the only one in a database at the time you close it. We tried it with databases that usually have more than one databases and kept geting db(some number) because it could not replace it because it was open. So we only have some databases compact and repair on close and...

Do you have a sample you could maybe upload? You need to have something that ties it all together, like a date, that makes it easier. We use a report here that is made up of 4 subreports tied by name, date or user number depending on the subreport. Kim

Wayne, You are a god!!!! It worked perfectly. We have been fiddling with this for the past 3 days. The Evil Bankers

We are looking for a record with the current date, not just that a record exists. The table consists of a sequential number and a date field. Do you think DLookup would work better in this situation? Thank you The EvilBankers

Enabling and Disabling buttons on a Form based on criteria found in a Table We have a form that has two buttons one is a normal print button the other is a reprint button. Upon opening the database we would like it to check the date in a table called FSU to see if a record has been generated...