Search results

Sorry, I didn't notice that you provided a link in your last post. Thanks very much.

I'm not familiar with that approach. Would you please describe it? Underlying sources are queries.

Thanks for the reply. I'm working with 2007, but it has to be compatible with 2003. How would you customize the report to always show zeros if there is no record? At the moment, the report(s) will show those fields to be blank.

- I have a form with five subforms, each with it's own table (recordsource). - Each subform is linked to the same Primary Key on the Parent. - The fields in the five subforms each have the default data value set to 0. My problem is that I would like each subform to save those zeros in...

Figured it out. This is one of those times that you come into work the next day and see the solution within minutes. The master back and had to have the ReplicaConflictFunction set to a custom function. The conflict resolver must be run from the back end and not the front end. I thought that...

I'm working with Access 2003, split database. I'm trying to apply a custom ReplicationConflictFunction as described in the VB Help file (and I've poured through many web pages looking for answers). I believe that I've done everything as specified. However, when I synchronize a replica via the...

Thats probably it. I've been working with Access for many years (not a programmer) but I've only recently worked with the split database\mde mode of operation. I think that you've explained it. Sometimes the obvious is hard to see. In working with the MDE I don't think that there will be a...

I gave that a try but didn't work. I've tried everything that I can think of to save a value on the form rather then in a table so that I can recall that value on the local MDE before a recordset is opened. But no matter what I've tried, the Form won't save the value after being shut down...

unbUserName is the listbox that you helped me with.

Sorry, I confused the issue (that time of day). Nothing to do with tag. Initally, I was trying to use the Form.Tag field to store the last users identity. But I found that when the form was started in the next session that the Form.Tag field was null. So I've created an unbound label and I'm...

That Worked! Thanks much. One more question: I'm trying to store the last user in the caption field of an unbound label. After writing that value, I then save the form. But the value isn't saved. When I restart the DB again it's lost. I'm obviously not understanding the .tag field...

I'm simply trying to select an item in a bound listbox. When I do this, the form locks up. I added a setfocus to an unbound button and that generated Reserved Error 2950. Stumped again. Dim lg As Long, lgIndex As Long, lgLastUser As Long With Me lgLastUser = Val(!LastUser.Caption)...

I found a solution here: http://www.developerfusion.co.uk/show/4073/ I had to change the second chunk of code on that page to work as follows: 1. The following line, "lstProcess.Clear" had to be commented out. This is referring to a listbox and my ACCESS 2003 listbox doesn't include that...

I'm afraid that won't do it for me. When a user tries to use the split database in remote mode through VPN it's unbearably slow, but it still works. So when users start the db it will connect with the master be and the user must sit and wait far too long for comfort before they can click a...

I have learned how to redirect FE table links from a Master to a Replicated DB (and back again as needed). Now I'm trying to find a way to detect whether the user is logged on to the server remotely via VPN (vs attached to the network locally) and then reLink accordingly. If the user is remote...

Thanks for your suggestion. It's a good one that didn't occur to me. I haven't used list boxes often but I see just what you mean. Since posting, the only way that I could see to work-around this problem was to create an entirely new table. So I wrote some code (Form_Open event) to use the...

I'm simply trying to open a new instance of Access with the following code: Dim objAccess as object Dim stTarget as string stTarget = "<DB PATH>" Set objAccess = CreateObject("Access.Application") With objAccess .OpenCurrentDatabase stTarget .Visible = True...

I'm working with Access 2003. I've created a database which will help to maintain test equipment. I have a subform with recordset = 'Equipment' table. This table includes a binary field titled 'Export'. The purpose of that field is to allow users to select one or more records for 'export' to a...

Please bear with me, but this is a strange one: I've created a database which will help to maintain test equipment. I have a subform with recordset = 'Equipment' table. This table includes a binary field titled 'Export'. The purpose of that field is to allow users to select one or more...