Search results
-
E
Button to open password protected website
Hello, Our company uses a access database (using forms) to store client details. One of the fields is web_id, We enter our clients web identification number into this field. I would like to place a button on my access form that does several things in a single click: 1. opens our web... -
E
Error VB/Form Object Required
EXCELLENT!! Now I have modified it.I have two fields, both fields should have a value for the Add_date button to be enabled! The code below works but I have 2 queries below. Private Sub Form_Open(Cancel As Integer) If IsNull(Date_Diarised) Or IsNull(User) Then Add_Date.Enabled = False Else... -
E
Error VB/Form Object Required
What us wrong with this please? I get error "Object Required" Private Sub Form_Open(Cancel As Integer) If Date_Diarised.Value Is Null Then Add_Date.Enabled = False Else Add_Date.Enabled = True End If End Sub Date_Diarised is field on my form and starts empty, Add_Date is a button that will... -
E
Lower Case Text Field
It does not work when placed in the After Update event.. I still see Capital Letters in some rows. -
E
Lower Case Text Field
Hello, I have made a form based on a query. The Field in question is called FTP_account. The form is tabular showing a list of all FTP accounts. I would like the data shown in the text box FTP_account to be shown in lower case only. At the moment it displays a mixture of lower or upper... -
E
Combo Box - Help!!
:confused: Hello, I have the following tables: Companies: ----------- Company_ID (PK) Company_name etc etc Product CD: ---------- Company_account (FK) Module A Module B Module C Product Web: ---------- Company_account (FK) Module A Module B Module C Product Book: -------------... -
E
obtain data from another table
Understood Can you explain this to me. So far I have opened the form in design view. Went to view > properties and in record source I see cancellations. Edit: I think I have this working, I made a query with all the fields i wanted, then dragged the fields from the query onto the form. Now when... -
E
obtain data from another table
Hello, Im not sure if this should go in forms or queries. but i guess its a bit of both. I have two tables: TABLE: COMPANIES ID Account_no Company 1Address Type 1Address1 1Address2 1Address3 1Town 1County 1Postcode Company_Notes TABLE: CANCELLATIONS Cancellation_ID DX_NO Company_Name... -
E
Forms and Validating Data
you are quite correct my friend, this is exactly what I have done (took me a while to figure out about the relationship view!) Have not looked into it further yet, but 1 thing i noticed its not very "user friendly" I would like a custom error message as soon as I exit the DX_NO text box field... -
E
Forms and Validating Data
Hello, I am just exploring the world of access (completely new never done it before EVER!), vb, forms and queries and i am totally in over my head. What i want to do is actually pretty simple in my head I just cant figure out how to do it in access, i hope some1 can help. I have two tables...