Search results for query: *

Hi all Running Outlook 2007 in our organisation. I have several client rules that, for one reason or another, must remain client rules. The main account I use is an IMAP account. The issue is that the rules only work intermittently. I've followed every suggestion I can find on the 'net to...

Hi gurus I've designed several autoforms in MS Word for our organisation. The question has been posed as to whether client info entered into the forms can be recorded in our case-noting system, which is housed in a MySQL database on a remote server. The logic of it seems simple: 1. Compile...

Hi everyone BACKGROUND: I developed and administer a case noting system for our organisation. I am trying to institute a 'history' function for users - to save time conducting a search they can just click a button to view the 10 most recent records updated. The three relevant fields in TblA...

Hi all, This is just beyond my reach brain-wise, any assistance greatly appreciated. BACKGROUND: Front End MS Access 2003, Back End MySQL. Pass-through query (QryA) references all data in remote table (TblA). Local Table (TblB) is created from QryA based upon user-specified criteria. The...

Dear Gurus BACKGROUND: Client database for which weekly contact sheets are generated via an Access Report. The Report contains a case note history in the form of a subreport populated by a query. The Sub report is in the bottom half of the detail section of the report. The sub report for the...

Hi Gurus Background: I designed and maintain a case-noting system for my organisation. It is set up so that a shortcut copies the front-end to the users temp directory (only 1 meg so 2-5 seconds at best) and then launches. Backend is MySQL. Users enter search criteria on the main form...

Greetings Scenario: Mainform with Subform. Subform is continuous form based on a query. Option group on Mainform enables/disables access to Subform. When Subform is enabled, users can update checkboxes on the continous form in Subform. Problem: My end users are indecisive. If they enable...

Hi all Usually trawl these forums for help but I've been struggling with this one and just found the answer. Time to give back! My project requires users to specify a date & time for when they want the record to expire and so it seemed more useful to have the dtpicker default to the current...

Task: 4 checkboxes. The checking/unchecking of each box needs to update the values of the other three. Problem: the code for each checkbox that changes the value of the other three is firing the onClick event for the other three checkboxes. EnableEvents=False is not recognised in word, only...

Greetings wise ones FrmMain comprises 2 subforms. Sub1 has scrolling list of all client names. Sub2 has specific details of client's records. Both are subforms of FrmMain, not one of the other. The user can: a) clicks on a name in sub1 which filters sub2 to show only details of that client's...

Hi all Have an MS Access database which generates a table based upon a qry, the table then used as datasource for mailmerge action in a word document. Until recently this worked fine but now, as end-user numbers increase, I want to move to a different mode. Using VBA I've managed to export the...

Dear Gurus My Access 2000 DB project is used by a few operators at the same time. It launches Word letters through the access interface. Have discovered that when a user has a given letter open it will prevent other users from opening that same letter from the Access interface. I've searched...

Resident Gurus The following is a true story, only the form names have been changed to protect your sanity. - have a form (frmA)with a private sub that is called each time a control on the form is updated. - Data from the form is in a table (TblA) and is allowed to store duplicate data. -...

Have developed a DB (Access 2000) which one user in my network seems to be using contrary to every other user. Much of it has to do with being able to sort reports according to any field within them. The report data is presented in a form and, with the right-click menu, users can sort by any...

greetings VeeBees What I want to do: interface presents lists of reports for user. user clicks buttons to view reports in preview. User closes report and is prompted with vbyesno if they wish to print the report. After choosing yes/no, user is returned to report menu. Problem: Using Access...

Hi folks Long time reader, first time poster. I've got a situation where a report, which contains a lot, and I mean a lot, of calculations, based upon 3 separate queries (for reasons too complex to discuss they must remain separate), forecasts our activity for the next 3 calendar months. As...