Search results

Not sure i understand but maybe create a table called sample with all the sample records that will never change and have a query that appends or updates to your main table????

How are you telling it what to update are you using a parameter update query:confused:

This may or may not be the best way to do it but it works this uses an after update and a form current with the same code good luck Private Sub date1_AfterUpdate() Select Case Me.date1 Case Date Me.date1.BackColor = RGB(255, 0, 0) Case Date - 1 Me.date1.BackColor = RGB(0, 255, 0) Case Date -...

Sorry im confused you want one parameter query you would like to have open two forms build on the same query?

Sounds like something in the code requires the drop down to be selected Check your code or paste it here so we can get a better understanding of the situation.

Say you had a report (build it from your table) or a form(recommend continous form) add a text box to the bottom(form footer if not there right click in detail section select form header footer but should be there already) or where ever you want and put the expression in the control source(of...

How do you plan to have the user login once you figure this out you could use a select case This will not work for your situation until you find a way to tell the system who and what level its looking at however once it knows what level the user has this is an idea not a solution. Private Sub...

Try an on load event the following one will open the other form if one field is null Private Sub Form_Load() If IsNull(Me.field1) Then DoCmd.Close DoCmd.OpenForm "your other form" End If End Sub or for all three Private Sub Form_Load() If IsNull(Me.field1) Then If IsNull(Me.field2) Then If...

Use this in each control source you want the count to show up in =Sum(IIf([field1]="often",1,0)) change the "often" in each to "rarely" "never" basically this will count only whats in the " " for the field specified let me know if this helps:cool:

Got it to work thank you for your help this is the final code Public Function UpdateProgrammer() Dim db As Database Dim Numbrec As Recordset 'table 1' Dim Lenrec As Recordset 'table 2' Dim Programer As Recordset 'new table' Set db = CurrentDb Set Programer =...

Ok that works now but some thing is wrong with this With statement because now it says Update or Cancel Update without Addnew or edit but i have the .AddNew is it in the wrong place or missing something Public Function UpdateProgrammer() Dim db As Database Dim Numbrec As DAO.Recordset 'table...

Do you mean it needs to go Public Function UpdateProgrammer() Dim db As Database Dim Numbrec As DAO.Recordset 'table 1' Dim Lenrec As DAO.Recordset 'table 2' Dim Programer As Recordset 'new table' 'HERE' Set db = CurrentDb Set Programer = db.OpenRecordset("tblNumber_LenMulti") Set db...

I have two linked (text) tables in which i pull records into two other tables only to delete the spaces now i want to combine these two tables with a query the problem is they do not have anything in common ive tried to use an autonumber but these tables never have the same number of records...

Ha sorry sometimes the simple answer evades me. Glad you figured it out

Im assuming that your 3 forms are built off the same table Access 2007 view design tools add existing fields select Form field or what ever you named it (if you haven't already done this) do this for each form then on the button you want to preform this action add the code 1 for form 1, 2 for...

Use the same field for each form and change the code on the button to store a 1,2,or 3 different for each form.

Go to the fields proprieties-format tab-visible select no

Never mind found an easier way to do this:)

maybe create a field in your table named FormNumb then for each form button assign this field a value like: private sub yourbutton_click() me.FormNumb = 1 'rest of code here' end sub

Sorry "LWD" forgot the quotation marks