Recent content by sf129

I have a front end which is local on about 20 users machines. the backend resides on a shared drive. sometimes during the day i need to makes edits to the tables on the backend. i cant edit them if one or more users is in the db. how can i boot that user out of the db?

I created a form on my machine that implements the Snapshot Viewer Control. When I run the form on my machine everything runs fine. Then I tried to open it up on another machine and it didn't work. I registered the ocx. and still got the error "no object in the control". Can anyone tell me...

I have a form in access 2000 and I want to put in a subform that displays a report. How can I do this?

This is the exact value I have in a field in an access table. How do I get it all on 1 line instead of 6? Import nine Tables all Received data including their demo info demo info (name type = example) cal history

Does anyone what the program is that is the same as Access for a Mac? What does someone who has a Mac use as for creating a database?

I made a form and I need to know who is using it. How do I capture their Windows LogIn Id or computer name?

That would work if it was a form created in access, my form is created in visual basic, the form will run as a stand alone application.

I have a query in Access 2000 that needs to use the data from a text box as criteria. So the text box calls for a date and the query in Access uses that date as the criteria date. How is this done?

I do have hundreds of records. That is just a sampling from a large table.

These are 6 different rows on a table. I need to combine dates that are consecutive. start end 06/02/1999 06/03/1999 06/09/1999 06/29/1999 06/09/2000 06/30/2000 07/01/2000 07/06/2000 08/21/2000 08/31/2000 09/01/2000 09/12/2000 I would like to 4 rows instead of 6 reading like this...

These are 6 different rows on a table. I need to combine dates that are consecutive. start end 06/02/1999 06/03/1999 06/09/1999 06/29/1999 06/09/2000 06/30/2000 07/01/2000 07/06/2000 08/21/2000 08/31/2000 09/01/2000 09/12/2000 I would like to 4 rows instead of 6 reading like this...