Search results for query: *

I have another solution. This works well on a network, but could also be used for a single user. Basically, you copy a compacted version of the CODE MDB from the network drive to local drive C each time you run the database. Then you run the code from drive C. and the shared files remain on the...

When I boot up my PC and also when I shut it down, I get this annoying message in a large message box: Briefcase is making your file replicable so changes made to one replica can be synchronized with changes made to the other replica. Your database functions will continue to function normally...

It seems to me that this part: "BuildID=" & Forms!frmBuildsNew!BuildID & " AND should be "BuildID= '" & Forms!frmBuildsNew!BuildID & "' AND or "BuildID= val('" & Forms!frmBuildsNew!BuildID & "') AND Otherwise, I agree that the query should be...

Another method is to use the DMAX function as follows: LastID = DMAX("ThisID","TableName"). This function puts the highest value of "ThisID" from table "Tablename" into variable "LastId" Good luck [pipe]

I used a progress bar to inform the user of progress when checking that all tables were linked. The number of tables was in "Thisdb.TableDefs.Count" VarReturn is a variant. strMSG is a string, intI is an integer ------------------------------------------------------- strMSG =...

One way is to trap any extrneous key strokes. I assume that quantity is always positive. You can code a trap to allow the user to enter only the charatcters "0" (zero) thru "9" In the "On Key Press" event for the quantity field on the form enter this code: If...

The shortest way is to use DOS. Write a BAT file with a copy on it. Do a macro command to run the bat file. Firstly, compact your database to make sure that the backup is small and that the latest changes are included. Then run the macro. Example BAT FILE called COPYIT.BAT: @cls @echo off...

OK Glad to have helped. Send me an e-mail on rvparkes@hotmail.com and I'll send you the complete routines as a ZIP file. PS When I was 50, there was no such thing as visual basic, let alone Access 2, Access 97, Excel etc etc Glad to hear you've cycled half the USA. I lived in Manhattan for 7...

Oops, sorry I misunderstood. I suspect you will need to change your connect string using code. Here is a function which lists all linked tables in the current database. Public Function ListConnections() As Boolean ' Displays the linked tables on the current database. ' Dim gDB As...

yes you can get the current path pretty easily. Try this in the immediate window. ? CurrentDB.Name This give the full path such as H:\Database\Payroll\PayData.MDB Here is a short function (not good coding standards - please be tolerant) to get the path itself from the above Public Function...

Sandy, I appreciate all your research. I am coping using a workaround to get past the problem at present. Macintosh - what's that - an English coat? I'm using Access 2000 on a Windows machine. ESCOLAR

Sandy, Thanks for the help. I am close. ACCT_SEQ is a defined Oracle Sequence on the database. When I run the qdf.execute with "CALL ACCT_SEQ.NEXTVAL" I get this message: "Error Code = 3667 Error description = "A different operation is preventing this operation from being...

Thanks Sandy, This looks like the sort of stuff I need. I'll give it a try within the next few days and keep you posted. ESCOLAR

I am running queries and updates against an Oracle Database using Access 97 connected via ODBC. This is a much friendlier environment than Oracle's SQL Plus All goes well until I have to insert a new record using an Oracle "Sequence". This function is similar to AutoNumber in Access...

Hi there. My solution is not case sensitive. If you want a case sensitive result for the password, remove the two Lcase commands. :-) Here goes: In your table called Users include a text field called UserId and one called Pword (it's unwise to use Password, since it's a reserverd word) Create...

How do you analyse macros in Access 97 using VBA? :-V I have written a cross reference function in VBA that can find a nominated string and list the table, query, form, report or module it is found in. The function can also replace strings by opening one of the five objects above in design...

It seems to me that your date format for sorting should be YY/MM rather than MMM/YY.

I take it that you are opening and closing the form on the timer event. If you wanted to leave the form open, you could use the Me.Refresh method on the timer interval. If you do not want to see the form you could open it minimised and the timer functions should still work.

Scampi, I'm not sure what you mean by Tools macros visual basic editor. It does not seem to apply in Access 97. BNPMike, Thanks for the tip, I may have to convert the macros to VB. It's a pity that Microsoft does not allow the same functionality for macros as it does for Tables, Queries, Forms...

I need to be able to modify macros from VBA code. I scripts to find the macro names but all I can modify is the names themselves. For this I use DoCmd.Rename "CurrentName", acTable, "NewName". But how do I change a macro's contents? How do I view its parameters in code? Is...