Search results for query: *

I have a database with multiple users. Someone has gone in and changed something that will now only allow one person at a time to be in the database. How can I get it back to multiple users using the database at the same time:

I have a cross tab query that I would export by code to a spreadsheet replacing the existing spreadsheet each time I use the command button. Then have the spreadsheet show on the screen.

I have a query that selects a date range from a form. The query itself runs fine, however when I attempt to use the query for the basis of a cross tab query it errors out and give me a message " The Microsoft Jet database engine does not recognize'[forms]![frmwork]![start_date] as a valid...

I have a query that selects a date range from a form. The query itself runs fine, however when I attempt to use the query for the basis of a cross tab query it errors out and give me a message " The Microsoft Jet database engine does not recognize'[forms]![frmwork]![start_date] as a valid...

I have an error message that has popped up which is not allowing me to get into my database at all. The error message says data.mdb isn't and index in this table. Look at the Indexes collection of the TableDef object to determinethe valid index names. I am not able to open the database to even...

I would like to format a group of cells that will shade the background of certain cells one color if the value is < 50 and another color if the value is > 50

Can the report snapshot viewer 9.0 be used with versions of Access older than 2000?

I have lost the ability to use the command button wizard. I have reloaded access with no success. when I click on the command button the wizard button grays out. Any Ideas

For some reason I have lost the command button wizard. I have reinstalled Access with all boxes checked but it is still not working. Can anyone help me get it back

I have recently converted over to Windows 2000. I a still running Access 97. I am having a problem converting any output to RTF. I get an error message saying &quot;ActiveX component can't create object&quot;. I have reloaded a total load of Access with all boxes...

I have recently converted over to Windows 2000. I a still running Access 97. I am having a problem converting any output to RTF. I get an error message saying &quot;ActiveX component can't create object&quot;. I have reloaded a total load of Access with all boxes checked. Any Ideas? It is...

I want to change the value of a field from say 0 to 1 in all records. What syntax can Use to make this universal change. This would be like doing a find and replace all in the table. I want to do this in a VBA setting. Can anyone help me? Thanks for your time.

I want to change the value of a field from say 0 to 1 in all records. What syntax can Use to make this universal change. This would be like doing a find and replace all in the table. I want to do this in a VBA setting. Can anyone help me? Thanks for your time.

How do I replace the contents of an entire field from 0 to 1 in the events procedures?

I have two tables in my database and I want to do the following in an event procedure Copy tableone where fieldone = x into tabletwo. I need some assistance in using the correct syntex making this happen. The table definitions of the two tables are the same.

I have a database that I would like to write one query that will give me a count of duplicated records and unduplicated records. IE 15 different names have appeared 22 times in my database one name may have appeared 3 times while others only once. This should be a pretty basic function but I...

I have a report that has a date that is taken from a form.&nbsp;&nbsp;When I first run the report the default date appears properly in a Long Date format. If Change the date the format on the report changes to a Short Date format. Any Ideas to help make the date stay in the Long Date Format?

I have three field in a database that need to be equal if there are no entries in them I can not get the following If statement to do what I want.&nbsp;&nbsp;It I use a simple let statement without the If statments the field will change once I leave the field.&nbsp;&nbsp;But I don't want them to...

I have a subform that is linked properly to a form.&nbsp;&nbsp;I had the focus set properly to the key fields in each form.&nbsp;&nbsp;I needed to change the order of display on the linked forms and changed the control source of the linked form to an SQL of the table allowing me to have the...

I have a subreport that I a drawing several fields from a query.&nbsp;&nbsp;I have ordered the subreport on a numerical field.&nbsp;&nbsp;When I look at the report by itself the order is exactly as I would have it.&nbsp;&nbsp;When I view the subreport in the context of the main report the order...