Search results

Greetings all, My problem is simple, and self-inflicted. First I will explain my setup in a general sense. File.mdb contains forms, queries etc... File_BE.mdb contains tables for current records, and File_BE_Archive contiains identical tables with old records. I move records between tables...

Hi everyone, I posted a similar thread a short while back, but this is specific to win98. The MSACCESS.EXE process was not stopping on program exit. Using docmd.quit to close was the advice I was given, and works wonderfully on Win2k. But now I have a machine running win98 that also...

Hello all, I have just finished my very first DB app. I did it with lots of help from this very forum. Thanks to all. I was hoping I could get some feedback/criticism by some ppl who are much more experienced than I. The smallest I could get it was a little under 400k zipped. You can...

Hello, I think this is an easy one, I just haven't found it elsewhere yet. I have a union query based on two tables. I would like to be able to filter the results by a date range. I found this bit and it works well for single-table queries: Between Date() And DateAdd("d",6,Date())...

Hello, I'm running Access Xp on a Win2k box. Whenever I close the program, the MSACCESS process will continue running. This wouldn't be a huge problem except for the fact that when I attempt to reopen the app, I must first open taskmgr and end the process. Anyone else have trouble with...

Hello, Mine might be a simple question, but I am pretty new and have yet to find the answer elsewhere. I'm trying to find some code to do the following: If (primary key requirments NOT met ) Then Me.Undo End If or something that will give the same result. I have just not been able to...

Greetings forum, I'm pretty new to access and VB and am having some trouble figuring out how to fix a coding problem. I have 2 tables, tblGroup and tblBanquet. Additionally I have 2 forms, frmGroup and frmBanquet, both based on queries of the corresponding tables. One-to-Many...

Hi all, My problem might be simple but i dont know what to look for. I made a simple form based on a query for the purpose of changing/adding/deleting records from my main table. I have a cmb that populates the form with data for the record selected. That works fine. I made a new...