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

It's still not working. I can't see why it's giving me the error message "You cannot import this file". (err 31519) It would seem a simple task to import a .txt file into a table (with the same number & type of fields) using TransferText. I can import the file into the table using the wizard...

Below is a sample file that I am trying to load. I have changed the extension to .txt. The values are parsed by "|". - Paul

I'm trying to load a table with this code DoCmd.TransferText acImportDelim, Nov3Import, "U:\Power Smart\ecoEnergy\Test\2706d00312.tsv", True where the Access table is Nov3Import and the .tsv file to be loaded is "U:\Power Smart\ecoEnergy\Test\2706d00312.tsv". When I run the code, it tells me...

Need to use VBA for this I need to do this in VBA so that I can loop through all of the tsv files. There is also some logic I need to apply for error handling. Therefore using a wizard will not help. (.tsv stands for tab seperated values, but in my file the delimiter is actually a "|"). - Paul

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

Load Access table with many .tsv files I have several hundred .tsv files that I need to load to a table in Access 2007. The best way would be to load it into an Excel file first. I want the column name to appear once in the Excel file, followed by rows of data. I have an Excel 2007 macro...

What's wrong with this insert line? These lines give me an error "Compile error: Expected: end of statement" and highlights "Customer1". I do have a table of that name and I've tried every combination of spaces & parentheses I can think of. -PS Insert Into Customer1(City,Postal Code) _...

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.

That's it! Record Source had a query and there was also a filter. I had to find the right "Properties" window. Thanks to PNGBill.

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

Yes, it is front end/back end. Is there seperate security on each? Paul

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

Here is the simplified SQL for the query. (I have removed some fields for clarity). SELECT POPData.[PSPO], POPData.[kW saved winter (Est)], POPData.[kWh Summer (Est)], POPData.[kWh Winter (Est)], POPIncentives.VerifiedkWWinter, POPIncentives.VerifiedkWhSummer FROM POPData LEFT JOIN...

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

That didn't work I tried Forms!CustomerRegular!Customer1SubForm.Visible = True When I click on the button, it says "Run-time error 2465: Microsoft Access can't find the field 'Customer1Subform' referred to in your expression." Do I have to declare the subform using a dim statement?

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