Recent content by jdttek

I am doing my 1st indirect synchronization. I have read everything there seems to be written about the subject (including Litwin/Getz/Gilbert Dev Handbook and Replication FAQ, JRO Replication, Jet 4.0 Replication whitepapers, threads,etc). Still cannot get indirect sync to work and suspect has...

I am doing my 1st indirect synchronization. I have read everything there seems to be written about the subject (including Litwin/Getz/Gilbert Dev Handbook and Replication FAQ, JRO Replication, Jet 4.0 Replication whitepapers, threads,etc). Still cannot get indirect sync to work and suspect has...

Bsman Thanks again for your reply. What you describe is exactly what I have been doing. Because I am deleting and copying/pasting to an existing table, the PK remains the same (Acct#). What I am trying to do is NOT have to delete and paste, but just import new table (or create new table...

Bsman Thanks for reply Daily I import updated account receivable balances that have been downloaded into Excel spreadsheet. Yes, update append works (also add delete for paid balances Found that just deleting all exiting records and then pasting records from spreadsheet worked just as well...

I am trying to figure out how to assign a primary key using code, after running a Make Table query or importing a new table. The query runs everyday to refresh a table but, because it always deletes the old table, it looses the primary key. As alternative, I have been using Delete Table and...

Assume, for some reason, you do not want the default 0 & -1 or True/False, Yes/No, etc. If that is the case, perhaps create a new field (Completed) and then, on the OnUpdate Event of the checkbox field: me.Completed.Value = 1. JDTTEK

To show # of records, simply put =Count(*)as recordsource of txt box. Use Wizard to add previous, next, last record, etc. Thanks Roy-Vidar on how to get record #. I was trying to figure out the same thing. Assume this adjusts for filtered records as will? JDTTEK.

Use workgroups and Access security to limit access to DB to only those with proper security clearance. Volumes have been written on managing this process. Start with "workgroup" search in Access help. You can design your own workgroup and get rid of the default admin which would...

Foolio12 Thanks for your reply, and to a certain extent I agree. Why try to reinvent the wheel. Several reasons: 1. Don't want to expose the DBA (in this case the Dept manager who wants to control the users) to too much complexity or detail. Form could be designed to be much more user...

I am providing a manager with Administer permissions so that he can add and delete users to the the security set-up. I would like to avoid exposing the manager to the User Level Security Wizard or directly to User and Group Accounts and Permission dialogs. Idealy, if magager is logged in, he...

Thanks Duane. # 2 worked, though limited to 3 digits in lookup field. Could never get the * to work after hrs and hrs of experimentation. Pls let me know if you have any more insights on the * issue. MEanwhile, I will use the "Right" solution (pardon the pun). A Star for you. Thanks

Golom / Duane If you are still on this thread: I have a similar situation that I am trying to filter with VBA. Have tried just about every combo but none work (syntax?) -Form with Text box :(LkUp_PO) -Enter 123 in LKUp_PO. -OnUpdate Event (LkUp_PO) should filter records that contain...

Dan I have found the same thing. Setting coumn headings allows use of crosstab as subquery. I have been able to do this manually. However, is it posible to set / change the column headings through VBA? It appears you can, per Column Propterties Help: "You can set this property by...

I have a main form that is already filtered when opened (using cmd btn on previous form that selects only certain data to display when new form is opened). Then, when I use "filter by selection" on my subform, it works fine. Problem is, when I then do remove filter on the subform it...

Bill / DigTwice Will switching to Unbound forms and specifying Record Source with OnLoad event improve performance on standared FE/BE configuration? or only if Client to nonAccess Server? I have same problem as Bill: One major form (Main Customer File)with multiple tabs,subforms and controls...