Recent content by AccessGuru

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...

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...

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.

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.

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...

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...

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...

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...

THis solution calls a DOS batch file. I have included both the access code and the DOS batch file text: Access Code: '----------- VersionNoFile = "h:\apps\ft98\v2-4-14.txt" If Len(Dir$(VersionNoFile)) = 0 Then 'file not found 'DoCmd.OpenForm "TextFileLocation", ...

Use this code to check. Open a macro and call it bu entering =init(). Modify it to debug.print what ever you need. 'This module demonstrates a technique for determining whether a user has the version 'of the Jet engine that corresponds with the Microsoft Access Service Pack. The function...

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...

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

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.

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

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...