Search results for query: *

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.

Is it possible to disable the "Database Window" for read-only users? The database is set up where when you login the first thing you see is a form and you navigate through the database through a series of forms, not with the "Database Window." There is a table that I don't want read-only users...

I have a form and if a certain selection is picked it opens another subform. The both the form and the subform have a "document number" text box how do i automatically take the number that is on the form and put it on the subform?

I have a group of users who are read-only and when they try to do certain things on the database, that because of security reason they aren't allowed, they get a "Run-time error." Is there a way to get rid of the error and instead have my own pop-up message that say something like "you do not...

Is it possible to give permission based on an individual record. Eample: I have two users userA and userB and i only want userA to be able to edit userA records and userB to only be able to edit userB records all in the same table. Or even better can i disable certain box's of a form...

I'm trying to send a power point in an email and I want the powerpoint presentation to open automatically in slide show view when the attachment is opened. How would I do this thank you