Recent content by loki

Does anyone have sample code or a sample mdb that shows how to create an INI file and then also be able to import an INI file back in to a table in the mdb? Thanks

Thanks it worked great!

Here's my problem, I am using VBA code in Access2000. In my code it says to bring me back the first 10% of all the rows in a table. Which works good if I have a number like 500 rows which 10% is 50 and I get 50 rows returned. The problem is when I have 221 rows which 10% is 22.1 which is not a...

Do you have any suggestions or sample code?

I can use a calender control to select a date and put it's value in a text box but is there one that will allow you to pick time?

Hey Pat I created a query to delete all records from tblTableIndex and called it QdeltblTableIndexes and the code now works great. Thanks again for all your help, It gave me exactly what I was looking for.

Hey Pat I hit this line Set QD1 = ThisDB.QueryDefs!QdeltblTableIndexes and it gives me that the item is not found in the collection.

Pat you are a great man. I have not tried the code yet but it looks good. Thanks a lot

The problem is that when a compact and repair is run, and there are corrupted records it some how removes the primary keys from the tables. I need a quick and easy way to check all my tables to make sure the primary keys are still there.

OK here goes. I have an Access 2000 database that is hit by multiple users. I have many table that depend heavily on their primary keys. There are daily imports that run and if the tables are missing their primary keys they are populated with a lot of duplicates. A compact and repair is run...

The reason for the additional fields is from the ongoing request of the users. I didn't design the database I'm just trying to maintain it and provide the requested enhancements. Thanks you both for your replies.

Does any one have any ideas on how I might automate the process of getting a user to add a field to one of his tables. I have to aleast once every couple of weeks get users to add additional fields to a number of growing tables and it is like pulling teeth becaues we are not at the same...

it is user entered because it makes reference to a specific account number that is already established.

I have a table (tbl Main) in Access 2000 that has a primary key. This mdb is a backend on a network and is accessed by 20 users who each have a copy of the frontend on their local drive. The problem is that I have recently started losing the primary key in tbl Main. I am not allowed to change...

I have an Access 2000 database that is used by 80 users. I am having serious corruption issues on a daily basis. It usually always turns out being one particular table that contains a number of memo fields. I need to use memo fields because text fields are not big enough. There is a lot of mass...