I'm using an order/entry type of form/subform, and I'm having a problem designing a 'Next Entry" button. I'd want to clear all data fields from the...

How can I zero or set to blank a Text Box on form. On the first record it is ok, but when I bring up another record it retains the value from the...

I have a form with 4 fields InitialQty, RemovedQty, RemainingQty & ID .It is a basic inventory form. For every item I am trying to track IntialQty, RemovedQty,...

I have a form containing personal details. Included in this form are fields First Name, Initial & Surname. Is there anyway that Once I have entered a first...

What function will you use if you want informations to be retrieved from an ini file? -- Message posted via http://www.accessmonster.com

How do I set the system such that tables, macrod code, etc. won't be acccess by users ? All they should be able to do is use the form/screen. Thanks in...

I have a form with about 7 tick box controls. What can I do so that once one box is ticked the others become inactive and a message pops up that says "You can...

Hi All How do I Inhibit the MakeTable prompt in AXP when I open a form? In Tools=Options=Edit/Find I've switched off all the confirm options but it...

The two text boxes are on the same form (subform3). I want to inhibit the Quantity filed from being edited if the Status field contains "Ship Requested". The...

I am working on editing a database that uses several pivot tables. I have had to change the queries that build the tables that the pivot tables draw data...

Hi, I have a page to let user type in a"key" and search my database. Then another page is opened to display the result. My code is as follow: Private Sub...

I am new to Access programming. I am trying to get the table and column attributes from an Access 97 DB using Jet (via C#). Is there a way to get this...

In my form I have a query (qryCashRcpt) which is the combination of two tables (tblEmployees and tblCashRcpt) In tblCashRcpt, there are two fields ColCode...

I have a main from that pulls infor from an emp database. I also have a subform where users add information. Problem, when I look at the table where the...

Help, all of the information I type into a form shows on the table such as the client, address, phone, etc. However, none of the information that...

Ok, I am not sure why this is not soaking in, but here's the deal I have two tables, the first is job_list and has the following fields: job number, job...

I am not sure if this is the correct place to put this question. I am creating a library application. When someone checks out a book, I want to check the...

Hi, I have some fields in my form were may not leave blank ( Required properties is set to yes ). I want when a user leave the field in blank condition and try...

How do I get my information boxes to re-appear????????

I am new to Access and would have set up a database of employee id and their names. I want to create a form that allows me to put the employee id in and the...