Recent content by ndltx5

N/M I fixed it by changing 'check the database components and select matching data StrSQL = "SELECT Table1.['CompareField1'], Table2. ['CompareField2'] FROM Table1 LEFT JOIN Table2 ON ('*'+TABLE1.['CompareField1']+'*') Like ('*'+Table2.['CompareField2']+'*') WHERE...

I'm trying to create an interface to import two Excel files and compare them for common entries. I've got the import part figured out i'm just having some trouble with the compare part. Here's what I got so far for the compare: ' set the variable for the first field to compare data with...

I have a form with a beginning and end date range search that filters a query what code to I put in the beginning box so that it always defaults to the first day of the current month?

Whats the easiest way, when inputting data in a form, to not allow the user to continue until they've filled out all required boxed? Thanks

Ya I just figured it out. Thanks

I'm trying to build an event procedure so that on click it opens say msn.com, whats the code to do this. Thank you

I have two forms, the first has a listbox that pulls data from a query, the second you enter data to send to a table. I want to be able to choose a record from the listbox and view it in the second form, so that the form is populated with the data form the record you selected. I have it...

In properties I go to the "Event" tab and then on the "On click" I put [Event Procedure], then in visual basic I put: Private Sub ResetSearch_Click() 'Replace any data in fields with a * Me!Text7 = "*" Me!Amount_Start = "*" Me!Amount_End = "*" Me!INIT_START = DateAdd("m"...

I have a command button on a form that has the Event Procedure of when clicked it sets the value of a text box to say "3". But when I set up the Event Procedure and then click the button I get the following error: "The expression On Click you entered as the event property setting produced the...

I'm using 2003, not sure about the others.

Sorry to be a pain, but where do i do that at? Thanks for you help

I'm not sure what you mean. I enter the database through the shortcut go to tools->database utilities->backup database and save it as a mdb. Then when i try to enter the new mdb file I get the no permission message. What do i need to do to use the same MDW?

How do you create a backup database for Security Enabled database? I can create one from "Database Utilities," but when I open it and try to login it says I don't have permission to use it.

Nevermind i figured out an alternate solution. Thank you

It is already unchecked, but that doesn't prevent them from opening the "database window" from the tool bar.