Search results

I want to attach labels to their respective controls (e.g., textboxes, comboboxes). Does anyone know how to attach the labels to the controls? It used to be that Access would produce a little error box that said they were unattached, but that is not coming up anymore. Tools>Options>Error...

Can't help without seeing the official database (not a picture of). You should make a copy of the database, fill it with non-sensitive data, and then upload it as a zip file.

WHERE TblO4.Empid = '" & CboxHbiid & ", you're missing your close single quote (before the comma) Should be: WHERE TblO4.Empid = '" & CboxHbiid & "',

Almost there, but you have to call the subroutine somehow. I suggest either making a button to call it, calling it after you update the birthday, or calling it when you click on the permissions combo box. I have it so that it is called after you update the birthday. Your form's code should...

Good to see my QueryExists() function getting some use =) Attach the database and I can help debug.

I have a problem understanding what you want because of the terminology you are using. 'Field' generally refers to a column (field) in a table, but I'm assuming you're using it to reference a textbox on a form. Public Sub Age() Dim strDate As String 'Initialize Variables...

Just a recap on what Ghudson was saying. Your menu bar should appear, however if you have a problem the next time you load the database follow these steps: 1) Use the unhide code above to temporarily get it back 2) Right click on the menubar, or open the Tools menu from the menubar, and select...

You could also do: dtmReportDate = Format(Now, "mm/" & "01" & "/yyyy") or dtmReportDate = Format$(Now, "mm/" & "01" & "/yyyy")

I just wanted to reiterate what pbaldy said earlier. You are using double the memory for the combo box by creating a new object. Insstead of declaring the "cbo" variable, just reference the combo box on the form. So, remove "Dim cbo As Object" and "cbo = Me.Controls("dbCompanyName")" And...

The built in security should be able to help, however you can also use: environ("workgroup") to get the workgroup the computer is on.

Where would the full employee name be stored? Username is the login name to access the computer, why would the computer be able to know what the employee's name is without inputing it somewhere?

You have two posts. I'm surprised anyone has replied with a title like "Please Respond To This Asap"

Private Sub Label1555_Click() On Error GoTo Err_cmdMailTicket_Click Dim stWhere As String '-- Criteria for DLookup Dim varTo As Variant '-- Address for SendObject Dim stWho As String '-- Reference to frm Vendor '-- Looks up email address from TblUsers stWhere = "[VendorEmail] = '" &...

Keith is saying, change this: varTo = DLookup("[VendorEmail]", "[Vendor]", stWho) To varTo = DLookup("[VendorEmail]", "[Vendor]", stWhere) Additionally, your stWhere is messed up, so change stWhere = "Vendor.VendorEmail = " & "'" & stWho & "'" To stWhere = "[VendorEmail] = '" & stWho & "'"

I know I could make a code to produce local front ends on each machine, but I would rather know if there is a registry setting, or a property of some sort to turn off the locking. Thanks, Modest

I am trying to make a simple chat interface for a database. There is a standard form I use as a template for chat between two people. When a member dbl clicks on the buddy list, I use DoCmd.CopyObject to copy the form for the two people. However, the CopyOjbect only works when only one person...

Use the query as a hidden textbox's control source. And use the textbox value in the IF statement, or... Dim rs as DAO.recordset Set rs = CurrentDb.OpenRecordset("Query Name",dbReadyOnly) If rs.fields(0) > 0 Then 'instead of 0 you can use rs.fields("field name") ... End If

what datatype is Material Name

You essentially have the answer already. Store the value of each query into a variable, use a SELECT..CASE to change the value of A, then do sum all the variables for D. What's the problem?

I don't get this thread. Why didn't you just state the reasons that Rick gave you so we could add to or deter you away from? The big thing is you have more security and encryption options (e.g. You can set a BE on an encrypted folder). However the other main reason is corruption and backup...