Search results

If I wanted to display the date when a button was last pressed on my form, how would one go about this.

I'm assuming you on a LAN?.... You can get the users NetWorkID of the person opening your db. I do this with my db and I compare the ID's with an employee table when the user attempts to preform certain things. Now, with that said, I use a non visible unbound textbox to do this. I believe...

Yeah, I looked at that one and this link: http://www.mvps.org/access/forms/frm0031.htm I'm just struggling with it. I copied and pasted every version from the examples and changed the form names to match mine and still no luck...

Having trouble hiding a subSubform and referencing the controls on the subSubform.... Red certainly isnt correct... If Form_frmOne.frmTwo.Form.NewRecord Then Forms!frmOne![frmTwo]![frmThree].Visible = False Forms!frmOne![frmTwo]![frmThree]![MyFormLabel].Visible = False Else...

1)Build a query on the data you want to display on the report. 2)Build a form(popup if you like) and use a cbo with the field name you need. 3)Do something like this for a search button on your form: Private Sub YourButtonName_Click() On Error GoTo Err_Report_YourButtonName Dim mySearch As...

Can you post a sample of the db?

Let me get this straight, You have fields that are numeric and you want to convert them (display as) a text description? And you want to do this with a query? Is this correct?

Yep.... Thats why I refered back to your post... I also provide away for the folks that really use my db to lookup the password, I just created a hidden label on my statup form that displays the password if you know where to click. But I just changed the startup to check my employee table...

I forgot you wanted to be able to cancel also... Put this on your cancel button.....of course your name "Command3_Click()" would be different... Private Sub Command3_Click() On Error GoTo Err_Command3_Click DoCmd.Close Exit_Command3_Click: Exit Sub Let me know if you ned further help...

I have this code on a small popup form.... Private Sub Command2_Click() Set con = Application.CurrentProject.Connection Set rs = CreateObject("ADODB.Recordset") stSql = "SELECT * FROM tblpassword " 'I have the password stored in this table! rs.Open stSql, con, 1 ' 1 =...

I use this in a subform to send out emails.... I dont get that message, I used too, but not with this code.... I had to include "On Error Resume Next" in case someone closed the email without sending due to an error Outlook would do.... I believe a simple If/Then statement on the change in...

A project can have many footingIDs FootingIDs can be in many GridIDs But only 1 FootingID in any given gridID I have my tables indexed not to allow duplicates

There are 2 projects in the db. There are entries made in the footing table(subform on left) for each of the projects. The subform on the right needs to populate the cbo in that table with only the FootingID(s) for the project viewed in the main form. Example: Project 1 has only one entry for a...

I'm trying to get the cbo in the right subform to be populated with the FootingID(s) related to the subform on the left of my main form. I cant get the sql correct...

Try setting this form to popup = yes on the "other" tab if both forms are to be openned at the same time....

Any chance you can post the db?

Once you have your db open got to the Tools menu at the top. From there select Startup.. You will see some boxes to fill out, one is for which form opens at run time...

Try this: Forms![main form name]![subformname].Requery

Are you sure you typed the form name correctly in the code?

This should get you going!