The SQL below updates records to an access table. It is causing the error message "Not enough space on temporary disk." INSERT INTO NS_Pmt_Temporary (...

Hi, I have a public procedure in a standard module that updates a table, setting variables depending on what form it is called from (CalledFrom passed as a...

I help to run a football league and we have 6 division (premier,1,2,3,4, & 5). What I would like to do is to generate fixtures for each division (Home &...

I have two different tables, one with turnover values by customer by month, and one with some cost values by customer by month. I currenlty have two queireis...

Hello. I'm trying to figure out a query that will show me the top x% by group. I have a query that counts the number of occurrences of a given event,...

I would like for a query to extract last name, suffix, first name and middle initial (in that order) The data field is setup as first name middle initial...

I am using WinHTTPRequest Services in MS Access on my client computer . All seems to be OK except that the file returned is not...

Hi, Could someone help me with next problem, first table with start dates and days to add ID Name StartDate Days 5 Louise 11-jul-08 2 2...

I am having a problem with my MS Access 2003. When I try to append a table to another I am not seeing the first table in the list. I have tried to force it...

Hi, I have a Main table that has 10,000 records. Fields include Main ID, Name, Address, etc. I have another table that contains the same Main ID and phone...

I have a find unmatched query in my access 2000 database. When I delete some of these records, the 'You Are About to Delete' warning appears. The records go....

I am trying to convert the dates in my query from the format of mm/dd/yyyy to yyyy-mm-dd and it is driving me crazy. They will not upload into another...

I have a bound text box and I want to display a date, but formated like this "dd/mm/yyyy". I tryed to input a mask like 99/99/0000;0;_, but when I insert in...

Hi everyone, I'm pretty new to access 2003 and I have been given some excel address spreadsheets to import. Trouble is the excel columns have been messed...

I have a bound text box and I want to display a date, but formated like this "dd/mm/yyyy". I tryed to input a mask like 99/99/0000;0;_, but when I insert in...

I have the option of referencing a control on a form for criteria in a query which is the record source for a report, but would prefer to reference a...

My database has a date table with 'manually keyed' weekly date ranges (1 record/row in the table per week/date range) that show as combo box drop-down lists...

do i need ot have sync center on my start up and what is sync center.. I do not use a pda or have this system communicate to any other device.

I'm not very skilled at using VBA. I have created an update query that reduces a number by 1. This is the criteria: IIf(=0,"You cannot claim this...

Hi I'm struglling to figure this one out and some help would be much appreciated. I have a data capturing form that has some VBA code attached to it...