Search results

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

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

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

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

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

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

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

Hello, I have copied the below code from either this site or microsoft's access help pages and it is doing exactly what it should. My problem is that i need to add an extra parameter to it but i am not sure how. Basically the code is summing the field DURATION which is a date/field in the table...

Hello, I have, with the help of this forum modifed some code that now returns a list of dates in sequence compiled from a start date and repeat count entered by the user. My problem is this - the output provided the dates as one record, is there any way that these values can be stripped and...

Hello, I have a form upon which I have 2 activex date pickers bound to startdate and enddate. Alongside these activex controls i also have text boxes bound to the the same fields. Once the date is selected via the date picker the text box will update and display the chosen date - but only after...

Hello, I have a table with 2 fields - WeekID(autonumber) and WDATE(date/time). What I want to be able to do is to enter a value for the first date and then have the next 25 entries automatically entered. Each entry is to be 1 week greater than the previous entry. Ultimately giving me a list of...

Hi, i have a problem whereby i have 2 worksheets and the data that is entered on sheet1 is automatically dropped into sheet2 by means of ='sheet1'!A2..........'sheet1!Z2' etc being entered as the formulae in the relevant cells. The problem is when rows are inserted into sheet1 the values are...

i have a query that limits the search results by their date. i have a form that has 2 date/time pickers both bound to a field start and end date respectively. The query criteria for the date is "Between [Forms]![frmMain]![StartDate] And [Forms]![frmMain]![EndDate]". This works fine except for...

I have a database that allows an accounts department to reconcile data. I have a table that contains several fields, two of which are date and period. What i want to do is update the period pending on the date - i.e. if the date is 10/05/2005 then the period is to be updated to 5; 10/04/2005 to...

i have a linked table from which i run an append query to produce a list of customer addresses. However the address appears in one field i.e addressline1 addressline2 etc and when displayed on a report it looks poor! is there any way that i can split this data out into 3 or 4 fields so they are...