Hi all, I have Subform "SubA" on another Subform "SubB". And "SubB" is on Form called "Main". On "SubB" I have button called "Add New Record" and I got macro...

hi I'm trying to make a db interface as 'prat proof' as possible. some people will want to find and edit their records from the datasheet view, and some from...

I understood. Thank you!!! I think I didn't read with enough attention at first.Sory! "SA" wrote in...

I am just starting Access. Can one enter data in a form and create tables from the data entered? Also I have created an invoice in Design View. Three of the...

Hi. I'm hoping someone can help me with this search question... MT_Position / PK = PositionID MT_Candidate / PK = CandidateID MT_Interview / PK = FirstName,...

I'm stuck, trying to base the contents of a listbox upon a query with a variable parameter. The trouble lies in the fact that if I set the listbox control to...

Hello all- I have two identical forms. They only differ by the select statement in their queries. I would like eliminate one of the forms and use a radio...

I have a table with several fields who's display control is combo-box, source is value list, and multiple values are allowed. In one of the fields, when I add...

The form I use to enter purchasing data calculates a total cost per order, but it doesn't put this info into the data table. How do I get it to do this? ...

Hi, When I open a form I would like the record to be locked, so users cannot accidentally amend any fields of the record. I would like to add a button called...

Can someone please explain in layman terms, the purpose of BoundColumn in ComboBox in terms of viewing two columns when dropped down and storing one value in...

Hi Hope someone can help me. I'm trying to set up an order from in Access 2003 and being very rusty have been using a Microsoft template. I am setting up an...

Hello all, I am having difficulty with the following issue (Access 2007) primary form (frmMain) contains user information with various fields. Key field is...

I am having a problem with my forms. I have a database with familyID as the sort order. If I change the familyID, the data is not re-sorted until I exit the...

I have a form whose first box is a combo. I enter in a PO and that numbe appears. I need to have that number automatically go to the next box so it will...

I want to prompt the user for a value to use to filter a form. Here is my command with the WhereCondition: docmd.OpenForm "test", acNormal, , "LastName=" I...

I posted this in the Query forum but haven't had a response,hopefully someone here can assist me: There's some data that occassionaly needs to be copied from...

what i have is an employee database and i want to apply the following rules : Employee Name Total Package Total Per Day Additional days Total Working...

I have several databses that have split front and back ends but my problem is that some users are not copying the front end to their desktop and running them...

Whats wrong with this expression in text box on main form reading value of field in subform named 'qry_Emp_TotalHrsWorked subform' - it is getting #name?...