Hi Experts,
Since installing SP3 on my XP Pro, Access 2003 , 2gb RAM set-up I've been getting into all sorts of problems with corrupted code and strange errors, such as "Out of memory". Rea...
Hi.....could you please tell me step by step how to combine tables with the excat same fields in Access. I read somehting aboutn a UNION query but have no idea how to do it. Thanks.
Hello experts. I am trying to create a sub procedure in VBA that will take the value of a date field in one table and add that date to the date field in another table. (Access 2003 database)...
I built a DB that has a form used to input data. The fields on the form are not bound to any tables. I am creating code to capture the data from the form and upload it to a table. Below is ...
Hi,
Is there anyway I can use VBA code in MS ACCESS to remove a linked table and connect a linked table?
I need the linking code (or procedure if it's big enough) to go in the following:
...
I am computer technicain supporting building with over 2000 users.One of them created Office 97mdb file and converted to Microsoft Acceess 2003.After convertion, some of the users having probl...
Hello:
My mission is to add images to each record in a database. These images are unique for each record. This is easy to do manually but for 2000+ records, manual is not an option.
I ...
I receive this error 3709 Connection cannot be used to perform this operation. It is either closed or invalid in this context. When trying to run code thru a macro. Here is the code sample. I ...
I have two buttons which do the following:
save button: it saves the listbox items into a file;
open button: it opens the text file and displays the items into listbox;
My question is w...
Creating a dynamic field called Overall Balance. Looking at one field for a "C" and another for the month. If there is a "C" and the month is = x, then put the value of the current balance o...
Hi everyone. I need help. I have a combo box in my form that i want to populate multiple text boxes after you select your selection in the combo box. Here is my set up.
The Fields that need...
I have constructed the connection string below in order to connect to an ODBC datasource. The problem is, my program exceeds the maximum connect time. In order to reconnect I have to quit MS...
how do I declare a global array and add values to it programmatically from one of the subforms?
Hi
I have record set that has been exported into the following date format:
Thu Mar 30 08:48:22 EST 2006
Thu Dec 28 15:07:11 EST 2006
Tue Jan 01 00:00:00 EST 1980
What query can I ...
Experts,
I need to ask for some assistance with an iif statement. I want to use it in conjuntion with a dlookup. I need to populate a field on a report with either of two other fields fou...
We have 7 Access 2007 databases that need to be converted back to Access 2003 if they can. How can this be done. I noticed that everything else can be opened with the microsoft download but ac...
I have a field in my table that is called OrderNo. This order number is based on todays date. Only the user has to look at a table to figure out what todays date is in Julien and thn they ad...
I've got a function that inserts some values into a new table in an access 2000 database. For a really simple example of this:
SELECT Field1,Field2,Field3 INTO [NEW TEMP TABLE] FROM [OLD TE...
I have an Excel template that I fill with data from Access queries using VBA. I have a form with buttons, and when a particular button is clicked, the corresponding function is called. All of ...
I'm at the point where I'd pay someone good money out of my own pocket to make this work. -_- I have a crosstab query that has different numbers of columns depending on one field in the quer...
I'm missing something in my code... It is not looping further into subfolders (as the msgbox states).
Can you please advise what's missing? Thanks!
Private Sub cmdEmailFolders2_Click()
'...
Access 2003
Excel 2003
Several workbooks in folder C:\Program Files\ImportExcel
I need to loop through each sheet called "shtFinished" in each workbook
Specifically looking at Column...
I have been wrestling with a data type mismatch problem for several days. The ASP page is submitting to an Access 2000 database. The table has two date fields- StartDate and EndDate. No matter...
tblScrapTickets:
ScrapTicketID, AutoNumber, Primary Key
ScrapTicketActivityType (linked to an ActivityType table)
ScrapTicketDate
ScrapTicketShiftNum
tblParts
PartID, PK, AutoNumber
P...
this can be solved 2 ways so whichever solution gets me there first is fine.
i have a sql query that i need to use in MS Access that is as follows:
select companytable.*, prospecttable...
