Recent content by StryderLlama

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

It was actually due to a corrupt query. This query was not being used so I deleted it. Once I did that I was able to start linking to it again. I tried creating a copy of the database and then I started deleting one table at a time. I found deleting onc specific table allowed me to link to the...

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

Thanks for the reply, I actually tried that yesterday morning and it fixed the problem. I was having trouble, until now, getting into the Forum. I am glad I figured it out and then come here and see that you had the same solution. I really am dense with VBA and modules. I didn't realize that...

I get a Compile Error Expected variable or procedure, not module

Yes, it is a module Option Compare Database Option Explicit

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

Solved Oops, I just found a post dealing with this. I looked earlier but found nothing, just didn't dig deep enough, my apologies.

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 actually figured a way out. I should have tried a few more things before jumping into the forum, sorry for the waste of time.:(

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