Search results for query: *

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

...Me.Filter="[Adj_PO] LIKE '"&Me.[LkUp_PO]&"'" me.FilterOn=True End Sub Returns Mismatch data type error when I throw in "*" in the above code. (Adj_PO is text field): Me.Filter="[Adj_PO] LIKE '"*" & "&Me.[LkUp_PO]&"'" How do I...

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

I finaly got a solution from Microsoft help desk !!!! In my case it had to do with proper install and registration of Office Web Components during install and registration process. I registered by phone and apparently this causes a problem with the Web component install (???). They sent me...

Thanks foolio12. T His very helpful. Is the shortcut the shortcut on the desk top? Where wld I put this if I just wanted to do on open of the DB? Or do I always need to build the shortcut?

Thanks for quick reply. I have done that already. Problem is, each DB is tied to different workgroup with each user's securtity defined differently for each. I need to have join to correct workgroup happen automatically when DB is opened rather than have user have to go into WorkGrpAdmin...

I have several users that belong to several different Access workgroups, each giving them different access rights to different databases. Is there any way to automatically join / assign the appropriate work group when opening the access DB? This wld be for both 97 and 2000. Thanks JDTTEK

I have an Excel spreadshhet that is linked to Access DB. Users can only input data into unprotected cells on spreadsheet. This input is reflected in Access queries tat are tied to the linked (protected) spreadsheet. I need to be able to append new records to the protected spreadsheet using an...