Search results

Hey all.. Been out of the Access loop for quite some time now.. Last project I did was in Acc97, about 5 years ago! Been working on SQL Server and web programming lately... Anyway, I have a project that needs to be done in Access XP. It is a basic resource allocation DB. Listing of...

I have a basic summary report that pulls in data from a lot of tables. In order to populate this report, I am using the DLookup and DSum functions. Needless to say, this takes quite a bit of time for the report to open up, and I'm sure just hogs up system resources. Is there any alternatives...

In my Access 97 database, I have the db compact using sendkeys after a function is run. My problem is if there is another user in the database, I get an error message about how someone else is in the db. Is there a way to trap this error message? I would like to compact if you can, if not...

Does anyone know of a way to copy a database file that is currently open? The Filecopy command from VB returns an error when you use it on an open file.. but if you copy a file manually through windows if it's currently open, it will work. Any suggestions would be greatly appreciated...

I'm sure there's some way to do this through the system, but does anyone know how to check if a table exists in a database. I want to run a make table query if the table doesn't exist, and an append query if it does... What's the easiest way to go about checking the existence of the table?

For some reason, I can't get this working for me... Seems very simple, but yet I'm blank.. How can I call one forms subroutine from another form? Basically, I have a form open, then I open up another form and call a subroutine off of it, and then close the second form down.. I don't seem to...

I have a VBA program I wrote in Access that uses an API call to find a persons Desktop directory. After that, it copies a shortcut off of the network drive and places it on the users desktop using the filecopy command. These seems to work fine on everyones computer except for two users...

Here is my situation. I have a form with two subforms on it. What I need to do is run a VBA module that is on one of the subforms from the main, parent, form. I am having problems finding the code that would reference the module on the subform to run it. Any help would be greatly...

Okay, here is what I currently have and what I need. I have a database that tracks all transfers processed by my company. Daily, macros run that update all the transfers. After these are updated, I need them to be put into a Lotus Notes Database, so they could be viewed on the web. It's a...

I was wondering if there is any way to disable the right-click on the mouse? I want to make a relatively secure database. I already hid the toolbars, but someone can still right click on a form or report to go into design mode. I'd rather not create an .mde file to prevent this, if right...

Okay, I have a form that reads off of a query. My database is shared and on a network drive. Everytime more than one person is in the database, you can't save a record you just inputted into the form. I get the 3260 Error, the Locked by another user error. Even if both people are not in...

I have a login form at the startup. From that Login ID, a user's name is given. There is a table that has a list of transactions in it, Adjustment Table. I want to create a table with only records that are for that person, there is a name field in Adjustment Table. How would I go about...

If I was using a While...Wend loop, How would I refer to the End-of-File??? Basically, I want to start at the top of the table, and keep .MoveNext 'ing down until the end, then break out of the loop. Here's what I have so far.. MyDB = CurrentDB() MyTable = MyDB.OpenRecordset("TestTable")...

Here is what I have... I have a table,(Adjustment Correction Table) as a source for the query(Calculation 2). I have that query as a source for a form(NewFormType). I want to uniquely number my records, but I don't want to use Autonumber, since it doesn't renumber when you delete a record...

Ok, I received a response for my last question, but I don't think that I was explicit enough, so let me try again. I have a form that submits information to an E-Mail. The control source of my form is a select query(Calculation2), which populates a table(Adjustment Correction Form). What I...

Ok, I have a big form where data is inputted. I have two basic questions here. First is, I have an E-mail function attached to a submit button, that whenever you hit the button, it sends an E-Mail to a certain person. I have a field on the source table that has record #, and it is...