Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Autoeng
  • Order by date
  1. Autoeng

    Force user to set password

    Similar to this posting thread705-441707 you haven't assigned a password for a user when you set them up how do you force them to go to the change password form and enter one the first time they enter the db? You would need to access the data contained within the mdw file which is where the code...
  2. Autoeng

    We have a new server that we want t

    The shortcut that is used to access the db determines what workgroup will be used. Therefore, you can locate all of the db's on the same server. I would also place the workgroups on the server as well and reset the shortcut properties to that location. Autoeng
  3. Autoeng

    Call VBA procedure with VB Script

    I am using Data Access Pages to interface with an Access backend. The need is to initiate a download of data created by a query. Autoeng
  4. Autoeng

    Call VBA procedure with VB Script

    Is it possible to execute a VBA procedure from VB Script? Autoeng
  5. Autoeng

    Use right mouse button to change from form to datasheet view

    But using the code I had previously posted the right click is disabled. That is what I was trying to get around. How to have no menu bar but the right click still works. Autoeng
  6. Autoeng

    Use right mouse button to change from form to datasheet view

    I don't want any menu bars as that would require that I relayout my form to accomodate the area that the menu bar uses. I have found a way around it but it quite lengthly. If anyone has the need for it let me know and I will post it. Autoeng
  7. Autoeng

    Use right mouse button to change from form to datasheet view

    I have a form with several "columns" that resembles an Excel spreadsheet. Because it is a form when you paste information into it you can only do one field (cell) at a time. However if I right click on the form and select (Change to datasheet view) I can paste entire rows. Now for the...
  8. Autoeng

    Microsoft Access 2002 Default Workgroup

    What do you mean by the original db? If you have security on the db it is not only in the workgroup but also on all of the items in the db as well and it won't let in a user who is not accessing the db without joining the correct workgroup. Unless you didn't delete the rights under...
  9. Autoeng

    Use multi-Select list boxes as query parameters

    I am trying to integrate this (http://www.mvps.org/access/forms/frm0007.htm) into my db but am not sure as to what event to assign the code to. I created my multiselect list box pulling values from my query. Created a hidden test box to store the WHERE clause. Created a command button to run the...
  10. Autoeng

    Same query but different relationships

    After making some changes to my db last week when I select to print a report it comes out blank. All of the report fields are there but there is no data shown in the corresponding text boxes. Control sources are correct. The report is created by pressing a command button from the only form in...
  11. Autoeng

    URGENT! Cannot find project or library

    I was just getting ready to post when I received yours. I was able to solve the problem when I dicovered that Microsoft had reported a bug in Access that it would sometimes lose it's references even though they showed as selected and the path was correct. By unselecting the references, exiting...
  12. Autoeng

    URGENT! Cannot find project or library

    Just updated my db, which was working fine, with some new features. Now some of my users are not able to get into it because it "Cannot find project or library" for the below module. This module checks the currentuser to see if they are a member of a certain security group so that...
  13. Autoeng

    Question about Access2000...

    Access can handle up to 255 users at the same time all working on the same table if everything is set up correctly. Autoeng
  14. Autoeng

    STARTUP -SWITCHBOARD - RETURN TO DESIGN MODE

    Hold down the shift key while entering the database. Autoeng
  15. Autoeng

    Add holidays to DateDiff query

    Michael: I had printed out your Faq prior to posting but I am a novice at queries and don't have a clue as to where to start to combine this into my existing query or to how to make use of the return that it would generate to use in my query. If you could be so kind as to give me a starting...
  16. Autoeng

    Add holidays to DateDiff query

    ...Date],[ECNDetailtbl].[Actual Implementation Date],2) AS DaysDiff, Int([daysdiff]/7) AS Weeks, [daysdiff]-[weeks]*3+IIf(Weekday([ECNDetailtbl].[Actual Implementation Date],2)>5,5-Weekday([ECNDetailtbl].[Actual Implementation Date],2),0)+IIf(Weekday([ECNBCNVIPtbl].[Release Date],2)=6,1,0)+1 AS...
  17. Autoeng

    lost my mdw file

    That short cut that you have that gets you in is what Jeremy is referring to. Access creates it when you run the security wizard and is now the only way to open your db. You have to distribute the shortcut to every user that will be using the db. You need to read up on security more. Go to the...
  18. Autoeng

    Distribute the FE by comparing versions

    I use a batch file as well to distribute my FE each time the user starts the db and have never had a problem. I don't even wory about version comparison, I just do it every time. Works very well with about 6 users full time and 30 users on occasion. Autoeng
  19. Autoeng

    Form Size

    One thing that I have found is that when you are working on your form design that if you have a subform the resizer will mess with your layout on form save. Disable the resizer by placing a 'before the code lines that reference it, make your form changes, save the form and then remove the '...
  20. Autoeng

    Distribute the FE by comparing versions

    I usually distribute the FE of my database via a batch file that when fired copies the FE to the users machine and then starts the database with the appropriate security workgroup. I would like to move away from the copy everytime batch file and use code to compare version of local FE to version...

Part and Inventory Search

Back
Top