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 derfloh 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: *

  1. AccessGuru

    Can Access 2002 (XP) read Access 2003?

    I need to make a decision to deploy a database in Office 2003, using the Access 2003 Developer Edition. Can Access XP read Access 2003? All the people on the network are on Office XP Pro. Microsoft says Access 2002 Developer edition is discontinued, but i am trying to get a copy. Otherwise I...
  2. AccessGuru

    How can I automate future code updates?

    I have used this for many years and it works so far: I write a DOS batch file to copy the file from the server to the local pc (the application mdb is copoied, not containing the data). Before the copy, a code checks the version on the server compared to the local one. If it is older it copies...
  3. AccessGuru

    Access 2000 date query problems

    Try putting the format([your date],"mm/dd/yyyy") around all your dates cos it must be be converted to US format to query correctly. U can also use the CVDate command for string to date conversion.
  4. AccessGuru

    AutoNumbers

    One way is to send the field1 into a table at field 1 where fielod 2 in that table is an autonumber. Low overhead for large records cos autonumber is fast but u need space on disk to create a table.
  5. AccessGuru

    Prevent TAB from navagating to next record

    Arrow keys or TABs may move to the next record. For arrow keys, do one of the following: To lock the cursor within the current record, select the Cursor stops at first/last field check box. This prevents the insertion point from moving from the first or last field to the previous or next...
  6. AccessGuru

    Runtime errors with my Access XP Program Expert Needed

    MS has a way of making the runtime package difficult to install smoothly, cos of the VB code. You may want to go to the VB editor, Tools, References, and add the MS Access Object 2.5/3.51 object compatibility library and re-create the runtime! I would strongly suggest getting a third party...
  7. AccessGuru

    Populating the sub with all products.

    I would use these commands where i control the LinkChildField and LinkMasterField property programmatically to make the filter work for you. Ie, an unbound control on the main form is linked to the field to search for on the sub form. Before the user selects the combo box option on the main...
  8. AccessGuru

    Multiple Users of Access DB At Same Time

    Access 2000 should not have this problem, but I recommend using a professional concurrent-user programming tool such a MS SourceSafe, where version control is available and object check-in and check-out is done to prevent 2 users editing the same code...
  9. AccessGuru

    Move FILE programicaly from ACCESS

    ...End If DOS batch file referred to as Perform Upgrade icon above: '-------------------------------------------------------- echo off cls echo *** Upgrading Version... *** echo. echo 2 files to copy. echo. echo Copying file 1... del c:\Progra~1\FasTra~1\FTApplNT.* 'del source files copy...
  10. AccessGuru

    Security Permissions for New User

    ...= 1100 ' Type returned by VER.DLL GetFileVersionInfo Type VS_FIXEDFILEINFO wTolLen As Integer wValLen As Integer szSig As String * 16 dwSignature As Long '/* e.g. 0xfeef04bd */ dwStrucVersion As Long '/* e.g. 0x00000042 = "0.42" */...
  11. AccessGuru

    I hate Access 2000

    I wrote a large commodity trading application in Access 2.0 then converted to 97 (1000 objects). That was in 1994 and until today they are still using both the 2.0 and 97 versions - for 2 companies. Why no 2000 you ask? But I have tried to convert the 97 to 2000 or sql backend or 2002. Well, i...
  12. AccessGuru

    Security Permissions for New User

    which version of access and mdb jet database are you using?
  13. AccessGuru

    Automatically Move Records to Another Table

    this can easily be done using an append query that you can call from a form or code which appends based on the date condition.
  14. AccessGuru

    Pivot tables

    Send the data or query to Excel and use the Pivot Table there.
  15. AccessGuru

    Security Permissions for New User

    Well, if we follow the steps to secure a database, users belong to no groups except the Users group which is compulsory. If you create a new group, let us call it Staff, make sure it can open the database, and make users belong to that. THat way when you programmatically create a new user...
  16. AccessGuru

    Pocket Access

    Here is another finding: http://www.pocketpchow2.com/where/where9.htm
  17. AccessGuru

    Pocket Access

    See this link below. Apparently there is no Pocket Access! I am also baffled why it is in the activesync. But I like the idea of putting pressure on MS. Does not help seeing that i just purchsed an iPAQ with CE 3 days ago and the Microsoft site has not been available in these 3 days! I still...
  18. AccessGuru

    Temporarily granted rights

    I would use a new group with the right permissions and make the user belong to it in code, and remove the user from there when the time is over.
  19. AccessGuru

    Chart problem

    For the first problem, In the design view of the chart, double-click the chart to call up Microsoft Graph, and set options in Excel to show all values evenif they are zero (right click on the axis and look for the appropriate option). For the second problem, I am still thinking!
  20. AccessGuru

    hyperlinking a pdf file?

    Try using the Shell command in access to simulate opening a file externally. You will have to know th epath to your linked file.

Part and Inventory Search

Back
Top