Recent content by AmritPaulSingh

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...