Search results

just an update, as is always the case after spending hours trying to make something work, the moment you post for help you solve it! just in case anyone has anything similar i resolved it by adding the following into my modules - At the top of my module I added: Public Declare Function...

Hello, I have an issue with the sending of emails via an access db and the task scheduler. I have set up a macro that calls several functions in order, the purpose of these functions is to send follow up emails to clients based on their entry date to my CRM. When working in the database...

Hi, I am new to SQL server but have had a bit of exposure to MS Access. I am trying to run a simple update query on single table (dbo.tblClient). I ran the code as a SELECT script and it produces the correct results, but when I change this to an UPDATE i get a message informing me that the...

that is absolutely perfect! thanks so much

Hi, is there a way I can use an update query or piece of VBA code to automatically add a space after every 6th character in a text string. This string will vary in length from 6 to 36 chars. Thanks

excellent, thanks for the help!

Hi, I have a text box on a form that displays an address on one line by merging the address fields in a text string - [Address1] & ", " & [Address2] & ", " & [Address3] & ", " &[Postcode] - This works fine when all elements contain data, however sometime one of the address fields might be...

the database is designed to allow us to keep records or all of our employees driver CPC training and the dates that they have sat and completed the relevant modules and courses. for each module passed they receive a certificate which is then saved into the "folder path" directory. What I am...

Hello, currently I use the following code to open a folder and display the contents within it Dim strLocation strLocation = "W:\folder_path\" Shell "C:\WINDOWS\explorer.exe """ & strLocation & "", vbNormalFocus This works fine but what I want to do next is limit the files that are shown...

David, thanks for the prompt reply, now working perfectly Thanks again, Alan

Hello, I have an issue whereby i want to be able to present the user with a text box in which they can either enter a client id (numeric) or a client name (string) which will then form the filter on an underlying query for a form. I have entered the following code on the <afterupdate> trigger...

that sorted it! thanks

Hello, I am using access 2007 and have a basic form with a tab control with 2 tabs. My problem is that some of the labels I have created on tab 1 are showing on tab 2 and I cannot see how to stop this! What do i need to do to keep controls i create on one tab from being displayed on all the...

Thanks Paul, that worked. What I want to do next is calculate the number of crates in store and for how many days they are there - i.e. DATE TYPE No of Crates 02/11/2008 Delivery 100 15/11/2008 Delivery 150 22/11/2008 Collection 200 Hence we need to raise charges for 100 crates for 13 days...

Is there a way to perform a calculation based on the value selected from a drop down list? basically i am trying to monitor the incomings and outgoings of crates, i have a sheet where column A is DATE, B is TYPE (collection / delivery), C is NUMBER OF CRATES. what i want is to be able to have...

Hi, I currently have an IF statement that returns a value based on whether or not a value entered in a cell is greater or less than what exists in another cell. The code i am using is =+IF(D59<H55,"You are "& SUM(H55-D59)&" under the recommended quote price","You are "& SUM(D59-H55)&" over the...

Does anyone know why the copy, cut and paste shortcut keys would stop working in an access mdb? I can still right mouse click and select copy, cut and paste as i can from the Edit Menu but cannot use the CTRL C,X,V keys. The mdb is running for users in a Windows 2000 terminal server...

Background: I am trying to create a spreadsheet that allows the user to record all items of furniture in a house room by room and their corresponding cubic foot volumes. I have several worksheets depicting different rooms in a house, i.e Kithcen, Lounge etc... On each of these sheets I have...

Excellent. Thank you both for all the help. Cheers, Alan

sorry, post should have read date/time field and it contains the length of a phone call in hours mins and secs (hh:mm:ss). I just want to be able to sum/total this field based upon one or two parameters i.e MONTH and DEPARTMENT. Thanks