Search results

  1. C

    Dont Understand Why this is happenning.

    Thank you It was the Tab order, Thanks so much, I was about to create a whole new form.
  2. C

    Dont Understand Why this is happenning.

    I will check both, Thank you very much. I am actually surprised that you could understand the e-mail.
  3. C

    Dont Understand Why this is happenning.

    I have a form that the users enters in case information including the case nuber which is the primary key. When the user enters in the case number and then tabs to the next field, It automatically saves the record. Meaning it tabs to the next field and then clears out the Id Field. Saving the...
  4. C

    Delete Duplicates Query

    What is the best SQL statement to Delete duplicates in a table?
  5. C

    Kicking users out of Database

    Thank you very much, I will check it out and let you know how it goes.
  6. C

    Kicking users out of Database

    What is the easiest way to kick users out of your database? Some of my users just leave the database open on there desktop when they go to lunch or go do anything other than work, and I would like to be able to kick them out when I need to make changes. Any help would be appreciated.
  7. C

    What is the best way to print a Recordset?

    no I have not done that, How would I go about doing that since the user enters the query and the fields change every time a user enters a new query.
  8. C

    What is the best way to print a Recordset?

    I use the sql statement as the recordsource for the report but the report does not show any data. This is the code that I have producing the report. DoCmd.Echo False DoCmd.OpenReport "QryResults", acViewDesign With Reports("QryResults") .Visible = False .RecordSource...
  9. C

    What is the best way to print a Recordset?

    It is based of off a SQL statement.
  10. C

    What is the best way to print a Recordset?

    Any examples on the code for that. I struggled through creating the recordset and I could use some good examples of code for printing a recordset to a report. I tried a OutPutTo command but that didnt seem to work. Any help would be greatly appreciated.
  11. C

    What is the best way to print a Recordset?

    I have a recordset that displays in a list box and I need that recordset to be printed. What is the best way to go about this?
  12. C

    Printing jus the list box

    I have a list box that displays the results of a SQL query that a user enters into a text box. I would like to print this list box but I cant figure out how to get it to print only the list box and not the whole form. Is there a way to just print the list box values and not the whole form? The...
  13. C

    Any Suggetsions? First Time doing this

    Thanks Thanks, I am an idiot, I dont know how I missed that on the wizard.
  14. C

    Any Suggetsions? First Time doing this

    I have a form which has a combo box on it, the user uses this box to pick a case and then the user can modify the corresponding case information. I would like to know the best way to go about doing this. What is the best way to link the combo box to the rest of the fields on the form, so that...
  15. C

    I cant get the Global Variable to go into my Query

    Thanks Thank you very much for the help, It worked great.
  16. C

    I cant get the Global Variable to go into my Query

    I have a query that needs to get the value of a GLobal variable. Here is the Query: SELECT [CASEFILE].[CCN], [CASEFILE].[PERUNIT], [CASEFILE].[LOCATE], [CASEFILE].[CRIME], [CASEFILE].[APPROVE], [CASEFILE].[AUTH], [CASEFILE].[EXPDATE], [CASEFILE].[EQUIP1], [CASEFILE].[EQUIP2]...
  17. C

    Invoking wizards from code

    Thanks so mush that worked great.
  18. C

    Invoking wizards from code

    I read on another webpage that you can start wizards from code. Does anyone know the code to do this? I looked on the other webpage an it was very confusing and the example I got from them did not work. I am trying to start the Query Wizard from code. Thanks
  19. C

    Is this possible?

    I have an access database that i have created security on and I would like to take away the permission of deleting a object. I have saved the file as a .mde file so you cant delete forms, reports, or modules but I also do not want my users being able to delete my tables or queries. I normally...
  20. C

    Whats wrong with this Query

    I figured it out I am an Idoit!!!. There was a null value in my table. That was causing the problem. Thanks for the help.
Back
Top Bottom