Search results for query: *

Enter this in the query criteria: Like "*" & [Type Last Name or Enter for all:] & "*

I have a command button in a pop-up form that brings a report up in the print preview view but the report goes behind the pop up form. Is there a way to bring focus to the report in front of the pop up form? I know I can minimize the form if I have to, but was hoping there was a way to bring...

Hi, I want to make a text box and a label on my report invisible if the value of the text box is 0. If the textbox is other than 0 I want it to be visible. I am not really a programmer so I don't know the syntax of code but I have tried to do it using the expression builder like this... IIF...

I don't want to sound like an idiot...but I can't get this to work. I want to insert a value into the the "Release#" field in the "Release_Equipment" table. My Parent form is based on a seperate Table ("Release_Define") that also has a "Release#" field. The subform's control source is the...

How do I use a bound checkbox to set the value in a control on a form when the checkbox and the control I want to change is in a subform and the value I want is in a bound textbox in the parent form? Also, if the box is unchecked, how do I change the value back to null?

I thought I had replied to this a long time ago but I just checked it again to see my message did not get posted. I just wanted to thank you for your help. IT WORKS PERFECTLY! Thanks, Bob.

The code looks great! But I don't have the DAO 3.6 Object Library in my references toolbar. I have the Microsoft Access 9.0 Object Library. Sorry to be a pain.

Thanks Aceman1....I will await your next post.

Multiple users are etremely rare but does happen. The database is NOT split. The database file is put on the network in the very rare occassions when two people are working on the same project. In this case, the database is not customized to have different default values for each user...

The database is menu driven with a main menu at the start. I can easily direct them to a "define default value" form that could be open without having anything else open. One possible problem with this is there are some equations where the database is on a network and two or three users could...

Sorry if my question was unclear. Here is my situation. I have built a database that my company uses for billings and quotes. Each person using it has an individual copy of the database on their laptops. Everybody uses different variables like labor rates, tax rates, ect. I wanted to add a...

I have a table that has several default values in it. I would like to be able to modify the default values in a user friendly form instead of having to go into the design view of the table. Is there code that I can use?

How do I use a control in a form to set/change the default value in a table?

Thank you

I am trying to establish a data link and I get the following error: Test Connection Failed because of an error in initializing provider. Login failed to user 'bob'. Reason: Not associated with a trusted SQL Server connection. What do I need to do?

I am new to SQL Server but have plenty of Access experience. I am trying to create a data link file but it asks for the name of the server. Since SQL server is on the same hard drive I have tried "(local}" or "local" and I get the following error message...