I am trying to create a flat file that shows a row for each customer number... with the columns showing tags for each Product Group that they purchase. e.g.
Using queries I have created a t...
I need to solve the following problem:
On the rights site, we have a text file with data, delimited by comma (C:\DATA.TXT).
The fist line contains the field names. The first field is alway...
My Access 2003 database has a frontend called DatabaseAdmin.mdb and a backend called AccData.mdb.
I'd like to create a button on the frontend which backs up the tables in the backend.
Id...
I'm having problems with the below code; keep getting syntax error on the following line:
.Parameters.Append.CreateParameter("@strItem",adVarChar, adParamInput,,strTextParam)
Any s...
Access 2003
I have an sql (not posted) thatIa'm using for creating a querydef...
My problem is I can't get the code right to delete the querydef if it exists first...
' =========...
This should be straight forward but it just does not work for me...????
Sum of three textbox values into a 4th total box.
Have
textboxtotal.value = sum(textbox1.value + textbox2.value +...
Hi Experts,
Up until last Sunday our salesman was able to open up a snapshot viewer fiile located in Outlook. Now when he tries to open it it says to check the permissions and it won't allo...
I am using the code below on a textbox control source,
I would like to have it where it the field has "(" then do
=Trim(Replace(Mid([Cbolocation],InStr([Cbolocation],"(")+1,10),")",""))
e...
Experts;
I have a main form with controls that allows a user to define a custom query (it generates a SQL string based on their parameters).
I want to output those results in a subform c...
I have a passthrough query in an Access database. The query is supposed to execute a stored procedure like this:
exec sp_APP_Top10 @StartDate='1/1/2006', @EndDate='1/31/2006', @RepID='84'
...
Hello Experts,
I have a form in a Access 2003 ADP connecting to Sql backend. It opens a separate dialog to update values in the underlying recordset. Upon returning from the dialog, I do a ...
Crystal Reports 8.5 - I have a field in an Access 97 table that is of memo type and I'm trying to get the right 12 characters of the field and to compare them but get an error stating I can't ...
I'm running an Access 2003 DB that fills FormFields in a Word document template. When I call the Word document from Access for viewing, I'd like to be able to specify a logical name and not j...
This is a simplified version of a problem I'm having with an append query.
If my code is as folows, the code runs fine:
'SQL to insert orders into tblOrders$
SqlStr = "INSERT INTO [tblO...
Using Access 2003 and Excel
I've been around the block on this a couple of times (some postings on this site.) I have gotten to the point where I can populate a single Excel worksheet with ...
Hi all,
I am using Access2003 SP2 on WInXP SP2. I have multiple tables all of the same structure. I an using a list view control (not list box) to display the name of each of the tables i...
Is there a simple way, in Access, to have three fields automatically calculated (summed) with the results displayed on a form. The results will be "on the fly" and not stored. The answer wi...
Is there any way we can silently upgrade an instance of Access 2000 runtime to Access 2007 runtime? I had a look at the command usage of Access 07 runtime setup but none of them seems to be u...
I have some linked tables in an access database. The tables are in SQL Server 2000. The module looks like the following... When it gets to the .update command I receive an error. (Run-time err...
Is it possible to enumerate reports in an Access database using ADO in VB6?
I tried the following code, but no success. Did I miss something?
Option Explicit
Dim oAcc As New Access...
i am trying to use a list box in vba and i do not see the list property for the listbox. i want to move items up and down in the listbox and all the examples i see use the list property. i ha...
I have two tables appropriately linked:
tblA
EmpID
Start
End
tblB
EmpID
1st_Start
1st_End
I need to copy data from tblA Start and End fields into tblB 1st_Start and 1st_End.
t...
Hi, I have a MS Access 2000 database as my front end with a SQL Server 2000 database as my back end. All the access tables are linked to the ones in the SQL database.
My problem is that I ...
Hi -
I have a simple access database to record vehicle accidents for our police department. I want to create a form where we enter a range of accident numbers - say starting at accident 101...
I have about 10 tables in an Access Database that I want to bring into an Oracle Database using ODBC. Please help me with providing the exacts steps for doing this. Both, Access and Oracle Dat...
