I need to copy all of my data fields from one table to another, possibly two. Anyone know what the code would look like to do this? Your assistance is...

I have a command button on a form that opens a text field in a zoom box (DoCmd.Runcommand acCmdZoomBox). Is there any way to change the properties of the zoom...

I am trying filter records when the form is open. When I read the heip files I am still confused. I have tried the following: Private Sub Form_Open(Cancel As...

I have a brain cramp. Very simple calculation in a form. Simple table and form. 3 fields. Field1, Field2 and Total. In my form in the Control Source of...

Could anyone please help me. I have this subform use for entering materical code, uom, price, etc. In the 'Before Update' event of the subform it checks if...

Struggling with this (still!) - we have a db with several forms. Lets call them frm_A, frm_B and frm_C. The front screen (main form) of the db will prompt for...

I created a Switchboard that leads to a data entry form and would like to prevent my coworkers (who will be doing the data entry) from making any modifications...

I have a subform that displays data in datasheet view. Does anyone know what line of code I should enter into e.g. AfterUpdate event to sort/re-sort once new...

thanks for the reply Larry, No the access file has been converted to 2002/2003 format. I have in fact sorted it, when compiling I need to close all forms and...

I have a pie chart with data labels showing label and percent based on data in a table. The labels say Sum of followed by the label name. I want to get rid...

I used the following code to open an Access application from another Access appliaction. The first form to open is configured to "AutoCenter" and "AutoResize"...

Ok, say I have two tables Problem Priority Problem_class -- Priority_class Problem_Data_1 etc Priority_desc I'm using...

I have a cbox that performs a calculation. It's set to 4 decimal places. However, it goes well over that. The cbox saves the calculation in a query. How can 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...

i want to change the properties of a specific field in a form (based on a query combining data from multiple tables) in order to achieve the following: data...

Hi, I have a form which stores today and yesterday records. I would like the day textbox will change to RED collor when ever I move to yesterday records by...

I have a form that opens up a record and views all the fields, selected via drop menus, from another form. To save space, I don't store the actual responses,...

hi, I am wondering if any one can help me. I want to make my access form open in the filterbyform mode. is it possible to create the form so when ever...

Hi all, I have a table with 300 fields. I can not create the input form on one page form, because there are more than 750 controls for 300 fields. Thus, I...

I have a subform linked to a master form. The subform is set not to allow additions. When the master changes and there are no records in the subform, the...