Search results

Hi All - Until recently, I was using Access 2010 but was downgraded to 2007 because of compatibility issues between the 2 versions. I now have a 2010 database that cannot be opened in my current version (2007), and it looks like I will have to recreate a ton of custom code if I can't recover...

Hi all - My db contains an unlinked form that is used to append records to 1-3 separate tables (tests to see if master records exists, appends if needed, moves on to child records). One of the fields is a text field meant for notes. The VBA errors out whenever this text contains apostrophes or...

In Access 2010, I can't get a form to show up in Pop Up mode without it disappearing. Tried several solutions (most from this message board) with no luck, including: Set Modal = no Set Auto Resize = no Set Auto Center = no Set Border Style = dialog More info: There isn't any VBA set to run...

I'm having trouble getting a loop involving the Dir(filepath, vbDirectory) to work cleanly. Problem is the "." and ".." results for the old DOS shortcut to current and parent directory. I can ignore those results just fine, but either I get caught in an infinite loop or get kicked out of the...

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

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

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

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

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

I'm making a simple code to open a detail report using a clicked text box as a filter. First part works fine, activated on click from the [Fee Description] text box in the header: Private Sub Description_Click() Dim Filter As String Filter = Me.[Fee Description] DoCmd.OpenReport "Tap and...

I already posted on a couple of question forums (probably a board faux pas, sorry), but I figure you guys should see my intro first. My name is Tyler, and I'm the Wastewater Utilities Coordinator for a city in the Dallas area. Not sure where the name came from, but I basically do the database...

I've been searching for a solution to this, but I can't find anyone discussing the same issue as I have. I'm working in Access 2010 and need to link to a set of .dbf files from our GIS database. Access db will be used for quality control against GIS data, the DBFs are map layers that we export...

Hey guys - I've been getting a lot of help from searching your forums, but I have a problem I haven't been able to solve yet. I'm setting up a db that will house data imported from small sets. One key component is the location the data came from (it's reading water pressure at different points...