Search results

Thanks for the tips. I compiled the code, no change. Also tried commenting out different parts of the code, and the only thing that gave me a different error was commenting out the "Private Sub" line. I even commented out everything within the Sub, and I still get the same error. The error...

My code was working fine earlier today, however I've started receiving an error: "The expression On Enter you entered as the event property setting produced the following error: a problem occurred while Microsoft Office Access was communicating with the ole server or ActiveX control." I closed...

Vendor frontend, can't set default values. Good idea, though.

I think I need to use a VBA loop for a query, but not sure if this is the best approach. My VBA experience is more directed toward forms, so I'll need a little help if I'm going to work VBA into my queries. Context - We have a database that stores detail on individual workorders, including...

Quick follow up, the rename worked. Inserted the following before the TransferText command to rename the file before import, and set the archive process to change the name back to the original when it goes into the backup folder: TempName = Left(Replace(strFile, ".", "-"), Len(strFile) -...

Bob - Good idea on the rename. I can just use some sort of Replace function to sub hyphens for periods. This just seems to be an odd bug, considering the error message says "can't find [exact file name]." I would understand it better if it couldn't identify the file. Too bad it's a Microsoft...

I have a database that imports data weekly from CSV files saved by field staff to a particular folder (they pull data stored in remote sensors). Import works great *unless* they put a period anywhere in the file name. For example, "example 10-29-2012.csv" works fine, but "example 10.29.2012"...

Could you set up the source of the list box as a query with the personnel count included? Should be able to inner join PersonnelTransfers with Stations, group on StationID and/or StationName, then count PersonnelID.

That's what I was afraid. Maybe we'll just have to set up web hosting for this database, or use VPN. Thanks for the direction!

Paul - no, our network is only accessible to computers plugged in to the LAN.

Depending on how your users are set up, you could also link your data source to an Excel spreadsheet. You can go to the Data tab in Excel, and the first button on the menu is to get external data "From Access." You should be able to select queries as data sources, and the query results will...

My department has a database that has been developed for in-office data entry from paper inspection forms. We haven't had many ongoing inspections going on, so the paper form is still used in the field, and the data goes into the db from the office at a later time. We're about to have some...

Problem solved. Located Snapview.ocx and reset the vba reference to it. Apparently something within the functions relied on this file, not just on the access objects reference.

I'm trying to audit a database that's stored in Access 2000. First problem is that I have to review it as is. Second problem is that the database throws up error after error, but only on my machine. A coworker opens it without any issues. From what I'm seeing, it appears to be some sort of...

Canteka - It sounds like your form is working correctly for normalized data. If you take the stored number and compare it to the table with the additional data does it match up correctly? If so, you're good to go on the form. Your form is linking the Primary Key to your main table as a...

Gizzy - I see this when I have several controls calculated within the report, or sometimes with complex background queries. Mine usually loads when I scroll down, but the initial controls apparently have to repopulate when I scroll back up. I'm assuming this is because it doesn't load all...

vman - Thanks for the clarification. I assume nobody else is editing the same tables and forms you're working with while you're in there? Assuming that's not the issue, you might try putting a Close command into your macro right before OpenForm to ensure it gets closed completely. Also, I...

It sounds like you have questions listed in 1 table and answers in another? You should be able to set the answers as their own subform within the main form, and you can format the subform however you like. Tabular layoutwill spread out the data horizontally, so that's probably what you want...

vman - I just put together something like this. My method was to set an "on click" event for the record you want to search (in you case, employee name or ID number) to open your form filtered by the employee name or ID number. To accomplish this, select whichever field you want to be...

Isskint - Thanks for the quick reply. No, it appears to read the OpenReport command just fine. I subbed in a hard-coded string in the filter criteria (also deleted out Filter1 = Me.[Fee Description] for this) and had no problems. Stepping through the command, it's definitely not making it...