Recent content by pstraszynski

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