Search results

I have a replicated database backend. Replication and internet synchronization are working. Now I'm trying to put a button on a front-end form which will initiate the synchronization of the backend. Using "Database Replication in Microsoft Jet 4.0"...

The Access help files and Access 2000 developers handbook suggest that I can use JRO code to manage replication programmatically. When I attempt to duplicate the example code, such as "Dim myreplica as JRO.replica" the objects are not recognized. What am I missing? Matt

I have used replication now on several machines with W98 and W2000. These have passwords required for shared folders, etc. Is that what you mean? There doesn't seem to be any problem getting the replication or synchronization to work. Matt

Try this: Private Sub Command2_Click() ' you don't have to use a button click... Dim SerToday As Date Dim SerBirthday As Date Dim SerThisBirthday As Date Dim SerNextBirthday As Date Dim SerLastBirthday As Date SerToday = Date SerBirthday = DateSerial(Year(Me!Birthday), Month(Me!Birthday)...

Thanks, I'll give it a try. I was wondering if there was a way other than query simply because I thought maybe the query would be too slow, and the combo box idea is so quick! Thanks again, and here goes... Matt

I now have data coming through a serial port from a peripheral device, and I've learned how to shunt it into the appropriate field for data storage. Now I'd like to use the data to locate a related record, in the same manner that a combo box can be used to select related data, return the record...

I'm not good enough to tell by looking where the problem might be. I recently discovered that the "breakpoints" in the debugger are useful even in small blocks of code like this. Go to each "if" line and each of the lines containing a calculation and hit "F9". Now when you run the form it...

I tried two variations on your code and was unable to reproduce that particular error. This code: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMessage As String Dim intOptions As Integer Dim bytChoice As Byte If CDate(Me!NewDate) < Me!OldDate Then strMessage = "....blah blah blah"...

You assume too much! One of the dangers of being a "cut-and-paste" programmer is that I don't always have the big picture... I was attempting to convert some VB code into VBA, and did not understand completely how VB works. So I missed the ".bas" module with the declarations! Thanks again...

Hello: This code works in VB6.0 as long as the ZP4.DLL is in the same directory as the VB project. But when I try the same thing in VBA in my access project, it breaks at "ZP4StartSession" and I get "Sub or Function not defined." Where should I put the DLL in order for the VBA code to see...

I found this: http://www.mvps.org/access/forms/frm0047.htm Matt

Hey, I just found this while looking for some other goodies... http://www.mvps.org/access/forms/frm0045.htm Matt

Thanks, Phillip. This is great stuff.

I found something the other day that might address this issue. Try this link: http://www.mvps.org/access/strings/str0007.htm Is that what you're looking for? I haven't tried this method yet... Matt

Phillip: This is interesting to me. More info please! So you're saying to set the default value of your data entry form as the [Forms]![prev form]![customer id]? Is prev form the name of the form with the button that generates the action? I need to do something similar, so details would...

In the after update event, you could reset the default value of the control. That way the next time you enter a new record, the new default is whatever you selected last time. Matt

You could create a hidden flag field of some kind. So in the click event, just before taking you to the CD form, a yes/no value for the track (Me!TrackSelected or something) is given the "yes" value. Now on your form, any track with the "yes" value is highlighted. Then other operations can...

If you link the outlook database using the "get external data" link, I think you can treat the outlook data as if it were in Access. Of course maybe there would be problems if people put their files in different directories, so you'd have to have the path to the outlook files entered by the...

Thanks Pat! It works perfectly, of course. I commented my version out, pasted yours in, and off it went! Matt

Looks great. What's the problem? Matt