Hi Experts I have a select query that uses text boxes from a form as its criteria. The SQL looks as follows:
SELECT GLExtract.BusinessGroup, GLcodes.RCode, GLExtract.DataItem, GLExtract.Month...
I have a linked MySql table in my access database. The access database stores russian strings but it appears ok. I think it uses unicode to store them. However, the mysql database stores the d...
Hi
I have found so many references to MS Access help about how tables with NO data can have the auto number start value modified, and if you have records then you have to use an append query ...
Like it says, really! Most times when I open Access or one of its apps, a dialog box comes up telling me that it is installing, configuring, etc... it. The app then opnes but the following pro...
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...
If the limit to columns in MS Access is 255 accross and I am trying to import a DB that has 1800 columns ? Is there a way to get that to come over in Access or is the only way to do that found...
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...
When I run
DoCmd.OpenQuery "q520S1C3_b"
it works fine; but when I run
CurrentDb.Execute "q520S1C3_b", dbFailOnError + dbSeeChanges
I get this error: Run-Time Error 3061 (Too fe...
I have a Make Table Query and I need to have the Item field change from text to integer in the new table. Here is the SQL for it. What needs to go in it to make the ITEM field be and integer...
I have an Acess DB that has a few tables and forms and queries. I originally wanted to have a text box on a form take a string and store that in a variable and then pass that into an existing ...
I have 2 databases; one called Employee1 and the other Employee2.
They both contain the same fields: FirstName, LastName, EmailAddress, and Center
The same record might exist in both databas...
I was just able to successfully add an appointment from access to outlook using the general instructions here:
http://www.access-programmers.co.uk/forums/showthread.php?t=31517
However, ...
I created a crosstab query in Access that lists the Sales, Cost of Goods Sold(CSG) and Margin for each day of the month by Client Grouping. Then the user asked to have an additional line adde...
Experts,
I am trying to run the following update this update statement works:
UPDATE MJM_ATTEND_PAY_INDIV SET MJM_ATTEND_PAY_INDIV.ATTEND_PER_MONTH = 4
WHERE (((MJM_ATTEND_PAY_INDIV.ROW_I...
I'm using the below code in an Access module to add gridlines to an Excel spreadsheet but it doesn't work (no gridlines added).
How to do it?
I need to import data from one Microsoft Access database to another, preferrably using a single SQL query within a C# program. For the particular data I'm working with, it would not be useful...
Hi Experts,
I am completely ignorant of Pivot Tables & Charts but, from what I've read, I think they may possible meet my requirements but I need some help putting it all together.
The app...
I have a table in Access 2002 with the following fields (and others not listed here) -- ItemNbr(double), Week Ending(date),AvgWeeklyDollars, and Promo(either X or blank). I want to update the...
Hello,
I know what the error message is I just don't know how to get around it or handle it correctly. I am using the subform as a type of lookup form for a field in my main form. If the ...
Access 2003
vba
What I have:
Access database MyStuff.mdb
1 Table
tblMyFiles
Three Fields
fldId-Autonumber-Primary
fldRacId-text 30
fldProject-text 50
fldFileNames- text 100
...
I feel silly even asking the question, but how do you hide and unhide forms from the user interface in Access 2007?
In Access 2003 and earlier, when I had an open form I could go to Windo...
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...
I have an access database that I need to limit access to only forms (in ordert to add, edit and save data in tables) However, do not want users to have access to programming code, queries, et...
I have used this statement occasionally in Oracle and it works. However, I can't seem to get it to work in MS Access. The statement follows:
insert into TABLE2
(ED_NUMBER, BUILDING_NUMBE...
I am having difficulty while trying to link tables from Oracle database. The error I'm getting is "ODBC -- call failed... Restricted data type attribute violation. Any idea?
