Search results

Hi, One possibility is to use a VBA function to return the first part of the post code based on table 1. Here is a suggestion: 1: Press ALT+F11 to go to the visual basic editor 2: Go to the tools menu and select references 3: Scroll down and tick "Microsoft VBScript Regular Expressions 5.5"...

Would it be possible to post a copy of the database and I'll take a look for you.

Sorry, you will need to enter the names exactly as they appear in the table, like this: [Customer Name] [Dongle ID] [Creation Date] A useful tip: In general rule it is best not to use spaces in your field names, it is much better to use the underscore symbol instead. But for now try this...

The control source is the field in your table where the data will be stored. If this is left blank then the combobox will be unbound The record source gives the list of values that will appear in the drop down box, so this is where you need to place the SQL code. Can you tell me what the...

Hi, You could also use the "On Lost Focus" event if you want the form to be unlocked when a user simply navigates away from the userform and leaves it open. An alternative would be to set the form's modal property to true, so that the form has to be closed before the user can do anything else...

Hi, This should be quite easy to achieve. I presume you have populated the Customers combobox with records from the Customers table. I would set the row source for your dongle listbox to the following: SELECT Dongle ID, Creation Date FROM Tbl_Dongle WHERE ([Customer Name] =...

Thought I'd take one last crack at getting an SQL UPDATE query to work. I hadn't appreciated which way round you wanted the dates to go which wasn't helping. The upshot is that I think you need DMin rather than DMax, changing from >= to <= wouldn't help, although my previous posts were wrong -...

The reason for the remaining null values is that no paydate can be found for the given transaction where the unpaidbalance ID is less than 393 or 114 (in the case you gave). What date do you want to assign to these oldest transactions? Possibly the absolute minimum paydate for that transaction...

It is not clear what you are trying to ask. Can you restate the question?

The information on baldyweb is exactly what you need. You just need to add an exception to handle when the ServiceEndDate is null. The solution is hopefully simpler than what you've been trying: T_Placements.ServiceStartDate <= [End Date] And (T_Placements.ServiceEndDate >= [Start Date] OR...

Useful to know, thanks Rain

Criteria Start Date: StartA Criteria End Date: EndA Actual Start Date: StartB Actual End Date: EndB The following criteria will return true if the two sets of dates overlap: (StartA <= EndB) and (StartB <= EndA) This will not give you the overlapping dates, but should give you a start. Credit...

Hi all, Thanks for the suggestions. Although it is possible to modify the conditional formatting using VBA unfortunately the limit of 3 conditions still applies. The advantage is that you can allow the user to modify the conditions. Stephen Lebans wrote some very clever code to do this, but I...

I have dreamed for a long time of owning a VW camper van. I'd love to be able to say that I'm not jealous, but I am a little bit! Which coast do you head for?

Hi, The networking issues may well be beyond my expertise - but I'm sure the friendly folk here will be able to assist. If you have multiple employees viewing and modifying the data then the backend database will have to reside on the file server where it can be seen by all employees. Maybe...

If I had a pound for every time I've had to hit my head with a saucepan I'd have very few brain cells and a very sore head. Glad to be of service!

It looks like the listbox you mention in lstComponents. Is this bound or unbound?

Hi, My set-up: Access 2007, Windows 7 Apologies if this has been asked in the past - I have searched but cannot find any similar posts. Is there a way to format controls (such as textboxes) on a continuous form in Access 2007 based on more than 3 criteria? As many will know this is the limit...

Setting up the tables and the relationships between them should be quite straight-forward for what you need. I think the challenge will be displaying the records in the exact format you want. It should be possible, but is quite a big ask when you're starting out with Access. I'm more than...

I think that the latter of pbaldy's suggestions will only show each individual amount for the last thirty days, rather than the sum of amounts for the last thirty days. I think you may be looking for the answer given in his first message.