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 again I've used some code that PHV posted in thread705-1550254 and all is working well. Dim adoConn As ADODB.Connection Dim adoRs As ADODB.Recordset Dim strSQL As String Set adoRs = New ADODB.Recordset Set adoConn = New ADODB.Connection adoConn.Open "Driver={MySQL ODBC 3.51 Driver};" & _...

thanks PHV Will post back when I find a solution. Cheers

Thanks PHV for responding so quickly. If you could direct me to some examples of how to use this library in MS Word I'd be grateful - I have not used ADODB before. Anything to give me a kickstart would be great. Thanks again.

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

Well, that's just brilliant and elegant in its simplicity. I use environ$ all the time at the front end for security purposes and to dump stuff to the users temp directory for mailmerge and the like - it never occurred to me to use it as an identifier in a remote table. That little gem will...

Thanks lamied The local table is used given that many users might be accessing the database at one time and they can't all be using the same remote table to house their respective data - the logistics of creating remote tables was too horrendous. I've had my suspicions confirmed regarding this...

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

Thanks for that that however I had tried that variation with no success until just now when I placed the page break at the top of the detail section instead of at the bottom. Things do look upside down from here in Australia! Thanks.

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

oops, obviously, for List1 above read List2. Cheers

Resolved: The problem seemed to lie with the delay between saving the record at the front end and the back end then returning a primary key - MySQL generates an auto-increment number at saverecord, not at newrecord. I didn't realise that I had a null pkey value running through the loop above...

Thanks PHV, If memory serves, x as 0 highlighted the column heading in list2, which I don't need. The problem isn't the scope of the set in list 2 but the fact that it wont iterate through the loop to highlight the most recently added case note when I'm logged in as a user. It will iterate...

Thanks for the response, genomon. Both the itemdata and y in the above code are integer values with no decimal point. Still, that doesn't solve my more pressing problem. Anyone else got any thoughts as to why I'm getting different results based upon how I'm logged into the database? Thanks...

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

Lightning response! I barely had time to spin in my chair. Thanks PHV Exactly the solution I was looking for. Works perfectly. Cheers.

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

Absolutely Brilliant! I only wish swearing were permitted here as I don't feel I can properly express my sincere gratitude without an expletive or two. Great to know someone who can properly discipline a misbehaving form. Cheers