Search results

My database is showing plus signs on the left hand side of each row. How do I turn off this view?

I work for a bunch of idiots. The numbers will tell them what place an employee holds on a waiting list, and they don't want a report.

Where would you put this code for a regular form - not a subform?

This is a round about way, but I managed to do it. I created an append query which appends records to an empty database whose sort criteria is in the order I want the data and that has an autonumber field. This restarts the numbering at 1 each time I create the table. Your subform should be...

Create a field in a query that uses the Right function to exact all the data from the field except the characters on the left that you don't want. Base the report on this query and use this field for sorting.

I have two identical tables. Each table contains information about a different city. Each record in both tables has a date and a time field. By themselves the date and the time fields are not unique, but combined they should be. For example the data would look like this: 4/1/04 08:00AM...

The naming convention was fine. I finally got it to work, by changing my control source to the table, instead of opening and closing it. I still however would like to know if there is a way to modify a field by accessing a table this way instead of using a recordset.

I used the following command to open a table and go to a specific record: DoCmd.OpenTable "Donation Times" Docmd.GoToRecord acDataTable, "Donation Times", acGoTo, 10 This works fine, but now that I am at the correct record, I want to change one of the fields. I tried the following, but I get...

Thanks Thanks, that worked.

"test" is the password and is an optional string for the command.

I am using the following code to open a password protected database. I know the code is working, because if I misspell the database or form name I get an error that the database or form is missing or doesn't exist, but I can't see the access window or the form. Please help. Option Compare...

I wish to password protect a database so that it can't be imported into another database, but I want this to be transparent to the users who are accessing the application through it's forms. Is there a way to send the password automatically when opening up the start up form?

Thanks everyone. I got it working. It doesn't need the Microsoft DAO Library 3.5, but it won't work without the ActiveX Data Object 2.1 Library. I hope this helps someone else.

I've already tried that and I don't know which refernce is missing.

Whenever I try to use and ADO connection. For example if I say: Dim cnn as ADODB.Connection etc. etc. I receive the following message: User-defined type not defined. Am I missing a reference or something. We just upgraded to access 2002 from 97. :confused:

It is against our policy to allow people like myself to install SP-2 on 719 computers. I want to know how to do it using visual basic.

After upgrading to Access 2002, I noticed several of our databases show the database window minimized on the taskbar even though the Display Database Window is turned off in the Startup dialog box. I looked up the problem in the Microsoft knowledge Base Article - 313915 and found this was a bug...

This is a continuous form and I simply want to sequentially number the records.

I searched for the answer to this question, but couldn't find it. I know how to number each detail record in a report by setting the ControlSource property to =1 and setting the RunningSum property to Over All. Is there an easy way to do this on a form?

We will be converting from 97 to XP next month. We have several database which are split. Does anyone know if it matters if the front or backend database is converted first?