Search results for query: *

Thanks to all who have replied, especially Hap for those examples and pointers - a star for you! Our main issue on speed is the poor network connection we have to live with - no scope to improve this presently. This is so bad it even prevents us splitting the Access Db front and back end - have...

We have a large Access database which is a bit too slow for the growing number of users and records it now holds, so we have finally got agreement to upgrade to SQL server for the backend. My question is what is considered the best thing to use for the front end - can we continue using the...

Another thing that has caught me before now has been if the field holding your parameter data on the form still has the focus when you run the query - at this point the field is not recognised as updated so the query treats it as null.... Nigel Didn't someone say work is supposed to be fun...

Apologies for the delay, only just seen I had another reply on this. Interesting point dhookum - I wonder what level of help warrants the star as opposed to a quick thank you note? I know stars count towards tip master etc..... Not to decry at all the valuable steer PHV gave me, I am sure it...

Brilliant, works perfectly, many thanks! Nigel Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

Hi, could someone save me from pulling my last few grey hairs out please - sure I am missing the obvious. i am using a series of combos to filter down records, and for the most part it works fine - snippet below does for example: ' If Project Name If Not IsNull(Me.cboProjName) Then...

Hi, I;ve been asked to pull together at very short notice a database to track contracts on a short-term basis - up to 12 months. So quick and dirty will be fine for this if necessay! Apart from the obvious details like supplier details, there will be a number of fields that users can update as...

Brilliant, many thanks, I knew it would be something silly I was missing! Nigel Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

Hi, been a while since I've dabbled with Access and missing something very silly! I have this code: If rst1![Request_Type] = "New" Then 'New request, check for ID's with these SRNs or Names i = rst1![No_Users] For c = 1 To i str = rst1!("SRN" & c) The...

Perfect, thanks very much!! Nigel Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

Hi all, missing something simple I think but can't work out what! I have a number of chechboxes on an Excel sheet and need to make them visible or not depending on other parameters. The following works of course: If tp = "Y" Then 'make all checkboxes invisible Me.CON1.Visible =...

I have an automated Excel form our users complete to amend system access. It contains a fair bit of code, enables users to make a number of choices including the manager who should approve the request, then when they hit submit it mails the workbook to that manager. It works perfectly from my PC...

Excellent, thanks mate Nigel Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

I usually work with Access but have been asked to sort out someone elses Excel project. When running several of the code blocks the screen flickers annoyingly as it updates. In Access I would hide this using the Echo command, however this is not recognised in Excel. Is there an equivilant I can...

Many thanks! Nigel Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

Hi, sure it's a silly question, I know I've done this before but can't see wood for trees. I need to reference several field names in a recordset in turn, in a loop. I have the recordset, and using the field name directly works e.g. str = rst![FieldA] However, if I try and capture the name of...

Many thanks, will have a look at that Nigel Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

I have an Access Database which monitors an Outlook inbox and performs certain automated functions for incoming mails meeting certain criteria- generating reference number, mailing response etc. I'd like to take this a stage further if possible. Relevant incoming messages will have an Excel file...

Many thanks for the replies, Irish's solution now installed and working which is excellent news! Nigel Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

Hi there I have an Access database with a module which monitors an Outlook Mailbox for incoming messages. When it finds suitable ones it adds a ref no to the title and returns an email to the sender to advise of the reference etc, and then moves the mail to a specified folder. This all work...