Search results

I have a database I inherited that is heavily made with VBA. It uses an ADO connection to bind data to forms from Oracle. One issue I am running into is when users use the Zoom Shift+F2 feature, occassionally the form behind the zoom will freeze. The only way to stop it is to do a hard shut down...

I have three tables. One called tblRound, one called tblLanes and one called tblCars. I would like to use VBA to create from those three tables a set of tables. tblRound would determin how many tables get created. tblLanes would determin the columns for each table and tblCars would determin the...

This is probably very simple but I am no expert in writing VBA by any means, just good at finding code and making it work. I am having trouble though learning how to update results from an ADO recordset. Can someone point me to a place that can help me learn to update the ado recordset. Here's...

I have a query that I need to rank the users according to the results within the query. The complexity of this query is that multiple users could have the same rank, in other words their scores could be tied and they would be ranked the same. Does anyone know a way I can get Access to rank users...

I am having an issue with a database. Currently, I programatically delete all relationships in Access 2003 but our company upgraded to Office 2010 and it appears there are system tables hidden that have relationships. I can no longer delete all relationships (Error 3033: MSysNavPaneGroups). I...

I am having an issue with a particular database. I try to link to it in several different ways but it causes whatever app I am in to lock during the linking phase. Example: I tried importing tables from this database into SQL Server. During the import when SQL Server brings the list up of...

I found this code for Access 2007 and I cannot see any reason why it would not work in 2003, but of course, something is not right and I am sure it is my fault since I am not much of a programmer and have little knowledge about VBA. I want to create a column in a query that takes a start date...

I have some simple security set up in one of my databases so that the database knows which screen to open for which user. My fear is that someone who has a little Access knowledge could get in to the database window by simply holding down the Shift key when they open the db. My thought is to...

I need a way to take multiple records from one field in a query I have. Example: Group Number 123456 233456 745699 I want to take these three records (records change from day to day, may be three records may be dozens of records) and concatenate them to look like this into one record...

I don't know if this is possible and I have spent a week searching for an answer. I have a form related to a query that is looking at a massive amount of data. I want the form to be very user friendly so I have designed it so that the user can search for several numbers in a query at once. I...

I have a form that I need to have a field where the user can type text. I want to link that field to the "Criteria" field on a query that will then search for the text. I know how to do this by building an event in the query linking that field on the form to the criteria field on the query. The...