Search results

Hi, I would like to be able to run some code from within a macro that will add a new text field to a table and also give a name to the new text field. I do not wish the new field to be populated with data, just an empty field is OK. Would anyone please be able to help me with this, ideally...

SOS, It is in a standalone version of access on a local PC using 2 queries based on tables. I have query A which contains for example 12 fields, one of which is a date field and one of which is a number field. All these fields are correctly populated with data when I run the query. I have...

Hi, I am using a union query to merge the results of two separate queries. For one of these separate queries I am setting the entire contents of a date field to null, similarly for a number field. However, when I run the actual union query I am getting the data type mismatch error. I presume...

Hi, Would anyone please be able to advise me on the best CPU type to use with access 2003 / access 2007 on a local PC ? For example, do I need a 4 core CPU or will a 2 core CPU be OK for maximum efficiency, ie, does access use all 4 cores / 2 cores or not etc. Also, is there any impact from...

I have tried to write the beginning of the code but am getting in a bit of a tangle. Below is what i have cobbled together and it compiles OK but does nothing yet as I have not got the "engine" installed inside the Do Loop. I set the below code up in a module named Loop_Sales_Status...

Galaxiom, Thanks for your confirmation about the missing part of the criteria. When I tried the "Between" option as the criteria for [InvoiceDate] on the 30 day data set the results were in line with what I would expect. If the form text box is not required to provide the date to the queries...

I tried running the query for the 180 day sales with the criteria for Invoice Date set to: InvoiceDate > [T_Dates].[SalesDate] -180 and also another option that I thought may work which was: InvoiceDate Between [T_Dates].[SalesDate] -180 and [T_Dates].[SalesDate] On both occasions the...

Galaxiom, My reply was slightly premature. I think I have an issue with the query result. I tested the 180 day query for the month of July 2009, ie, the 31 days in July 2009 were the dates in my [T_Dates] table. On running the query and checking for a customer it seems that the query is...

Galaxiom, Many thanks, it worked perfectly, most grateful for your kind help. Update: Spoke to soon, there seems to be an issue with the figures and it will not run on larger data sets. I tested it on 30 days worth of dates, however it fails to complete on the full 674 days data set. Thx...

Galaxiom, I am trying to produce a table with 3 sales figures: Total Sales in last 180 days per customer (calculated daily) Total Sales in last 30 days per customer (calculated daily) Total Sales in last 10 days per customer (calculated daily) However, I want the daily values for these...

Hi, I would be grateful if anyone could assist me by providing some code to run a Do Loop that carries out the following: 1. Pass a date from a list of dates to a text box on a form. 2. Run an append query in which the query uses the date set in the text box in the form. 3. Repeat the...

I have reposted this request in the Modules and VBA forum as I think I need to use a Do Loop and some VBA to achieve what I need. Please consider this thread as closed. Alternatively, a moderator can remove this specific thread Thx & Rgds Growlos

I wish to calculate the [SalesStatus] value each day for historic data, ie, from 1st Jan-08. If it was only today and moving forwards I would not need to run the repetitive calculations as I would run them each day from now on. The loop is to run the calculations for each day going back to...

Hi, I hope to be able to run an append query repetitively with each occasion of running the query representing an increment of 1 day. I have a date table containing the dates that I wish to use as incremental dates and I can join this table to my source data that contains the values for the...

ByteMyzer, The migration is to SQL Server 2000. Thx & Rgds Growlos

ByteMyzer, Is A2003 the migration assistant that will migrate access 2003 to SQL Server 2005? Rgds Growlos

Hi, Would anyone know if there is an SQL Server Migration Assistant that migrates an ms access 2003 database to SQL Server 2000 ? I can find the migration assistants to SQL Server 2005 and SQL Server 2008 for all versions of access but cannot locate the same type of application for...

DCrake, Thank you for the reply and interesting advice. I have not used the "Open File For Input/Output" before. Does it need to be run by code or is it a menu option somewhere ? I have checked out the main menus but cannot locate it. Is it buried in a sub menu somewhere ? Also, when you...

Rural, Thank you for the reply and the link. It solved the issue. I boosted the registry number to 5 million and it did the trick. Thx & Rgds Growlos

Hi, Would anyone please be able to assist with a message I am getting when trying to update the field format in a table using a data definition query ? The complete message is: "File Sharing Lock Count Exceeded Increase MaxLocksPerFile Registry Entry" I am trying to change some number...