Search results

Hi there Some expert advice is required here guys (please) becuase I need to decide whether MS Access can do the job or do I need to move to SQL Server/MySQL! My DB runs several action queries (delete/appends) on the client's main SQL DB and then there are about one hundred reports they can...

Hi All I really hope someone can help here. I have an access 2000 db as a backend for my asp.net application. There can be up to 10 concurrent users and each user deletes and appends his records in the tables based on his username. The tables are indexed using the username. My problem is that...

What way would you do it if you closed the first form and don't intend opening it again?

Hi there When using parameters from one form to the next I normally hide the form and then reference the parameter textboxes in the next form to the hidden form. Is there a better way of doing this as I saw threads here mentioning passing a parameter. How do I do this? Thanks! Dave

Thanks again Ted What I mean in Q2 is that when they enter all fields and are therefore entering a new record in the table, how can I pop a msgbox to get to confirm the new record entry or cancel to clear the record.

Got the database open since my last post, thanks. Just two more questions: 1) your example still lets you tab forward without making an entry, how can I code it to stay on that field until something is entered 2) If the user is entering a new field how can we maessage him/her to confirm the...

Yes please Ted!

What Access version is that DB as I'm having problems opening it?

Thanks, that is what's happening. how do I set a string variable equal to the text box?

Sorry Grnzbra, forget the original quote, my problem has changed here I'm trying to return a value in the text box which is <>"LOANS" and <>"RENTS". the query then uses this text box as a parameter but it must be treating it as one single text block because it returns no rows at all! I've...

Thanks If I return a value like <>value the query doesn't treat this as if you input <>value as a direct parameter in the query!

I hope this is a simple query becuase my brain has drawn a blank on it. I have a query with a parameter which a form textbox. If the text box has X value I want to use one list of parameters and if has Y I want to list all rows in the query. Any help appreciated! Dave

Thank you so much, that worked. I never would have figured out all the adverted commas in the criteria, will I come across that in other functions? Thanks again.

Hi there Can someone please help me with this, I'm using the following code to update a textbox on exiting a separate textbox. Aghhhh! Private Sub user_Exit(Cancel As Integer) Dim clt As Variant clt = DLookup("client", "users", "user_id = user") Me.client.ControlSource = "clt" End Sub

Hi TedMartin I've tried the following code similar to what you suggested but it's saying "object required" Private Sub name_Exit(Cancel As Integer) If Me!name = "" Or Me!name Is Null Then MsgBox "This is a required field. Please enter data.", vbOKOnly, "Field Needed" Me!name.SetFocus Else...

IS there an equivalent "onexit" property for the new record rather than the field? Ta.

Thanks a mill for that! What would the confirm code be if this was to add a record to the table and the cancel code to clear the entry made? Thanks again Dave

Hi there I'm new to all the VBA coding and wondered the simplest way to code for the following: 1) The user inputs data to a form based on a table. Where the field is set to required I need to show a message box that says this rather than the standard MS Access error message 2) Where the...

Sorry, I now changed the code. Could you tell how to declare password and pword where the questions marks are below. Password is from the password field in the form's query and pword is the textbox on the form where he types his password. Thanks. Private Sub Command8_Click() On Error GoTo...

I've tried the following code but brackets are causing an error! Private Sub Command8_Click() On Error GoTo Err_Command8_click iif([password]=[pword],DoCmd.RunMacro("Create Data",,),Msgbox("Login Failed",vbOKOnly,"Invalid Login",,)