Recent content by kkarren

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.

Thanks Dan that worked. You are awesome.

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

Thanks Skip that is exactly what I needed to know.

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

When I press the command control button the wand button grays out.

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.