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

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

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

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

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

Hi I have scanned numeric data off of a paper statement into an Excel Spreadsheet (using TextBridge / OCR). Surprisingly, all characters are consistently recognized and placed in the correct column! Problem is, on occassion, a blank space is inserted between characters in the string (e.g. 1234...

I have developed a bolt-on to a a legacy accounting app. The bolt-on downloads data so that users have ability to sort, prioritize, filter and combine data more efficiently (for example, sort Account receivable balances at a portfolio level by amt outstanding or age). Bolt-on does not write...

Part of my app tracks the progress on resolving warranty claims. I have a query field that uses a nested IIF stmt to indicate what the next progressive step in the process is by analyzing which "completion boxes" have been checked (Steps in the process are logged by checking a check...

Hi I download loan balances (Acct #, Amounts and Dates) each day into an Access table. I then run an append query that adds each account balance to a cumulative table so that I have a running history of balances each day. What I need to do now is just extract month end balances from the...

I have a Make Table Query that I need to run daily. The Query deletes the existing table and replaces it with the new one each time. I can't get the primary key to stick, so I need to re-set it manually each time. Can I set the Primary key on the new table with code each time the Make Table...

I have a db that allows users to set followup dates and actions. They can open a "tickler" form that lists all actions and dates and filter by today, past due, future, etc. I would like to ad a feature that works kind of like an alarm function: ie, a popup form opens automtically to...

I have a standard subform that has a checkbox for each record. A date field on the subform is changed (SQL Update)only for records with checkboxes selected when I run the SQL UPDATE Code. HOWEVER, the last checkbox is not recognized whenever I run the code, even when I have the code save and...

Hi I have a text field that contains numbers and letters that I need to extract only the number portion from the string. Length of each string is different, and # of numbers (at end of text) is different, so using right / left functions do not work. Need some way to identify only the numerals...

Hi I have an address field that I need to extract only the number portion from the entire string. Length of each string is different, so using right / left does not work. Need Some way to identify only the numerals (1,2,3...) vs. text characters and return only the numbers. Any ideas or...

I have a pivot table on which the link to the source file and range was proerly set using the wizard. Someone tried to change the link (on purpose or by mistake, I'm not sure)and srewed up the link. I somehow need to set or confirm the intended link each time the Pivot table is opened so that...

I have a mainform with names of customers and a subform with invoices for customers, linked by customer number. I am trying to build a summary box on the MAIN FORM that will show an invoice subtotal, a count of invoices and a 1st and last (min / max) date from the linked subform. Any help on how...

I have a form based on a multitable (several One-to-Many relationships) query that gives the usual "Cannot update Rcordset". I understand why and realize there is nothing I can do to fix the query HOWEVER, I see that RecordsetType Property allows for "Dynaset (Inconsistent...

I print a batch of reports. I am trying to update a table with the date, time and customer ID for each record using the On Print Event. Does anyone have an idea of how to approach this?? Thanks JDTTEK