Recent content by Zako

I need to make a custom message in my access database when someone tries to make a duplicate record. My table detects duplicates based on a phone number field called "fldPrimPhone" I would like to have a message other than the long winded default MS Access one appear when someone tries to enter...

Hey all, I have a customer with a database that will not open no matter what we do. It gives us an error that I cannot find a solution to. "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time " It is an...

the main form is bound to the table. I currently have no child/master relationship setup but originally I had it setup by the ID field (the primary key for the table) which is in the Table and the Query. It didnt work eithe way.

Ok, I have a strange problem with subforms... Table = tblWork Main Form = frmNewSearch Subform = sbfrmNewSearch Subform Object in Main Form = sbfrmNewSearch In frmNewSearch I have 3 text boxes and a command button. The command button has some VB code attached to it that creates a query called...

I sent you and email just now using the forum 'send email' feature, hopefully you got it. :)

Checked that, and I had it correct. I cannot figure out what is wrong with this thing. For some odd reason, when I open the actual "result form" it works fine but when it is opened as a subform of the "query form" it does not get the data. Its almost like the command i listed below is not...

Ok, Disregard... I ended up hacking into it finally

Hi all, I have brought some work home with me and ran into a problem... My database is secured so it asks for username/password upon entry. It uses a Secured.mdw that was created when I secured the database. I brought the MDB and the MDW home with me, and made the new shortcut: "C:\Program...

The query does exist... "Dynamic_Query" so that is ok.. If I open the form (sbfrmNewSearch) based on that query I do get it populated with the last query results. If I open the query form that has a subform of (sbfrmNewSearch) the data does not populate. I have been having some trouble making...

Hmm, when I do that, I see the status say "calculating" briefly but no records appear in the subform. I know the criteria I am searching for is good, since if I leave the original code in to open the query I get about 12 records

Ok, I did as you suggested and went back to the other one... I have so far made 3 fields searchable. With this new way of doing it, will it be possilble to make the cmdButton requery the Subform instead of opening a new query window?

Ok.. I am narrowing this down finally... but still I have some problems. In the Query it is doing something strange... I put the following in "Criteria" for the field called "OrderNumber" Like Forms![frmSearch]![OrderNumber] & "*" Or Forms![frmSearch]![OrderNumber] Is Null (its all one line...

Ok Jack, I decided to use the method found in: http://support.microsoft.com/default.aspx?scid=kb;EN-US;209645 Instead of the other one because it is simpler. I have created the Query with the correct search criteria, I have created the form to enter search criteria for the fields I want to be...

I made that MS code work in the Northwind database... What I would like to know is.. Can that query be assigned to lets say... a subform.. and when the query runs it just populates the form the subform is attached to. I really dont want to have new windows opening up in my users database if at...

Hi all, I've been looking through the forums and cant seem to find what I want. I have a database that includes fields such as Firstname, Lastname, Phonenumber, Ordernumber, Serialnumber and Casenumber. I have forms that allow data entry and data edit. I need a form that allows the users to...