Search results

Excellent! Exactly what I needed. thank you much Dave

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

no luck I tried Application.quit and double checked the references, still no luck. Also, now it seems that one of the 2k boxes are intermitently not stopping the process. Anyone have any other ideas? thanx Dave

Thanks for the replys. I'll try Application.quit tomorrow when I go in. I dont have a 98 machine here at home. And I'll double-check the references. thanx Dave

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

working link Ok, If you would like to take a look, you can download it from here. thx and sry for the confusion Dave

strange Hmmm It worked when I posted it, but not any more. Thats what I get for using yahoo briefcase, turns out cant give public access with the free service. I'll try to find my login for my website ftp, and put it there. I'll post a new link then. sry Dave

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

Exactly what I needed.:D Thank you very much. Dave

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

I didn't mean to make duplicate threads. Here I was just looking for some little piece of code that I couldn't find. The other thread helped me fix the problem last night. sry for any inconvenience dat_guy

ok here is the file

:D :D :D It works! :D :D :D Hey reading it now, I dont even fully understand my first post. I leanred more going the long way anyway. This is exactly what I needed. This is great. The DoCmd.CancelEvent was the missing key. I tried cancel = true and all kinds of other code that got me...

Thanks for the reply, Ill look into that. dat_guy

Thank you for your help so far. I have certainly gained some valuable knowledge. But, my original symptom still perisists. If a user picks a GroupID, and then decides not to complete that record, but instead pick an existing record to edit, when they attempt to pull up an existing record...

Thanx for the response. This form is used to input data to a child table. I have a cmbBox that is used to pull a GroupID from a query and place that value into a txtBox for adding records to this child table. This GroupID is the foriegn key for the one-to-many relationship, and part of the...

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

First, thank you for your reply, it is very much appreciated. On your points, 1) I removed all MouseWheel code 2) I dont know how to get this to act the way I need it to. Each record in tblBanquet MUST match with a record in tblGroup. How do I ensure that GroupID in tblBanquet matches the...

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