Search results

Hello I have an app with about 30 users that works fine for most of them (including me), but not for others. The app's security is based on the users having view or read/write permission to the subdirectory where the app resides; it is not password-protected. We all have Access 2007. Any ideas...

I have about 75 .tsv files that I want to load into an Access table using VBA. Each .tsv file contains about 25 fields and one .tsv file corresponds to one record in the table. I don't know how to parse the fields or design a loop that will continue until "end of file" (i.e. until all .tsv...

What is the best way to load an Access table from a .tsv file? ("tsv" officially stands for "tab seperated values", but in my file the seperator/delimiter is a vertical bar ("|"). ) The .tsv file has over 200 fields but the table only has about 25. - P.S.

Hello Everyone. In my Access 2003 application, there is a form that users enter data into. We also have an automated process that loads data into the database. All of this loaded data is visible in the table view, but not all records are visible in the form. Why? Any leads are appreciated...

Hi everyone, I have an Access 2003 database that used to work just fine. Then suddenly users were telling me they could not enter data as they did before. It turns out the same was true for me - combo boxes not accepting values, date fields not accepting numbers, etc. That was last week. I...

Hello/Hola/Bonjour ! I have a query based on two tables, joined by the primary key of the left table (right table has a different primary key). There is a one-to-many relationship between the left table and the right. (e.g. 1 to 4) What I want to show is all of the data in the four (right...

Hi everyone! I have a combo box with a Row Source Type of Table/Query. The Row Source is the following query: SELECT [Mer Status].STATUSES_FOR_MERS FROM [Mer Status] ; Where STATUSES_FOR_MERS is an alphabetic field in table Mer Status Visible is set to "Yes", and Display When is set to...

I want to make a form visible when a button is clicked. The following gives "Run-time error 424 object required". Customer1SubForm.Visible = True What do I need to change?

Form 1 has a command button that opens a second form. Both forms show data from the same table. How can I get Form 2 to open on the same record as Form 1? (i.e. navigate to record 5 on Form 1, then click the command button. Want record 5 data to appear on Form 2.)

I have created a form using the wizard. The form is based on an existing table, and the Control Source for each field is correct. The problem is this form displays no data from the table. I know the table is populated, and the "Visible" property is set to "Yes". Any ideas? - Paul