Search results

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

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...

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?

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...

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...

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...

Here is my code: Private Sub cmdPrint_Click() On Error GoTo Err_cmdPrint_Click Dim stDocName As String Dim MyForm As Form stDocName = Me.Name Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, stDocName, True DoCmd.PrintOut DoCmd.SelectObject acForm...

I have a table without a primary key. The fields are id, description and date. There can be more than one record with the same id. I need the code to do a test to the table and if it finds records with the same id, I want it to compare those records date field, and take the record with the...

Here is the situation. I used Access97 to create this but I have had to recreate it on Access2000, and can not get it to work. A user opens a ticket once a day and that date is captured in a date field and used as the primary key. They enter numbers in text boxes and that is all totaled up in a...

I have a very stupid question I am sure. I am used to using Access 97 but I tried to use a recordset in Access2000 yesterday and ran into a problem. I usually do this "Dim db as Database" but that doesn't accept that in Access2000. Can someone tell me how to declare a database in 2000.

I have 78 records that have a field that is null. I want to create an update query to replace these null values with the value "NULL1" for the first record, "NULL2" for the second record and so on. I know how to replace the null values with the word null, but how do I get this last number to...

I have a main form with a Revision History field. I created a button on the main form that when pressed opens a Revision Hisory Adding form for adding new details. There is three fields on my Revision History Adding form, name (which gets it's value from the main form), date (which defaults to...

I have a form with all the employees info and when you hit a button another form appears with that employees id and all the different contacts that employee has. Each form is stored in a different table. I created a query that brings back all the employees info and all his related contacts by...

I have a form set up so that when I hit a button all the fields are displayed in a report. The problem is that when I change a value in a textbox and then hit the button to go to the report, the report still shows the original value from that textbox. The only way that I can see the changes from...

I have two forms contected together by an id number from form A. I have generated a report showing all the info from form A. How can I also show the info from form B on the same report.

I run a query and use the avg to return a value of 18 and use StDev and get a value of 36. Does this mean that 36 is the maximum value of the standard deviation or am I suppose to divide that by two to get my range on either side of the 18? Does anyone know what that value is?

I have a text box on my form that is bound to a column in a table that is a number data type. How can I ensure that the user is only allowed to enter a numeric value on the form. Thanks for any advice!

How can I get one of the values in my combo box to appear on the form load

How can I get a text box on my form to automatically display "Enhancement" but I want to just store "E" in the table that the text boxes control source maps to. I do have a record desription table that has two columns, record type = E and record description = Enhancements, if that is any help.