Search results for query: *

Sorry about that missinglinq. I'd like the line actually appear on the form and not a textbox or anything. Thanks

Whats the command/suntax to print a line on the form? Thanks

I have a command button that does many tasks on its on clink event. Apart from other tasks, it prints out 2 reports. The first report that it is printed comes to the defualt printer, but the second report prints to another printer and not to the default printer. Is there a report property or any...

I have a multiple selection list box. How do I get the value of the selection of the list box in a text box? My lst box (lstPP) contains the following values: 1 2 3 4 5 If I select 1, the text box should get the value 1 If I select 1 and 3, the textbox should get the value 1,3 Help...

sorry. What i meant was that in the properties windows of the combo box, there isa field for default value....you can enter whatever default value you want in this field. hope thats clearer enough

In the properties windows of the combo box, enter ="Y"

got it. thanks nicsin

Thanks dyarwood.

If the VBA code has a very long line, how do i break it in 2 or more lines. I know there is something to do with & _ but am not able to use it. Thanks

if the function completes successfully, make it return true else false then call the function in an if statement. ex: if function() = true (continue) else exit sub end if

It would depend on what your drop downs have to do. According to your state/county example, you can do the following: Create a table with states and counties. First drop down can list all the states: "Select distinct States from tblStates" Then on the "OnChange" event of...

Import all the tables to the backend and the forms, queries and reports to the front end. Then link all the new tables in the front end to the backend. Hope that helps.

I took a look at the article but really couldn't get much out of it. Thanks for trying though

Thanks for your response Philly. I had one front end initially, but created mulitple copies thinking that that might be the reason for the error.

I have an access database that is used by mulitple users at different locations. The users use the database through citrix and they quite often get a "Disk or Network Error". There was a backend end and one front end to the database. I made multiple copies of the front end, one...

I have an access database with the backend at one location and mulitple copies for the front end for all users at different locations. The users use the database through citrix. They at times get a "Disk or Network Error". Earlier I had the forms bounded to the tables and so though...

The syntax for a delete sql statement is Delete from table_name where delete_crtieria If there are no child records for the record youi are trying to delete, you do not need to enter the child table in the sql. It will work fine just like that. Let me know if it doesn't work. Amrit

Use vbCr for a new line and vbTab for a tab. Hope this is what you were looking for.

Like redwoodly said, forms and reports are 2 diff. scenario and that snapshot viewer is best fo viewing access reports. You can download snapshot for free at the following link: http://support.microsoft.com/support/kb/articles/q175/2/74.asp

If you have a sql as the record source for the combo, then just add &quot;Order By <field>;&quot; at the end of the sql where field is the name of the field that you want the combo to be sorted by.