When I export a report in snapshot format and then open it with the snapshot viewer, everything looks great. However, when I print the report, the font format changes on screen and it also pri...
Hi again Access Experts,
i have a subform built from a table. i need to loop through all the records in 2 fields in it to do auto calculatoins form some functions. any ideas?
I've installed Service Pack 3 and now the pulldown menus in Microsoft Aceess are showing up blank. Is there a fix for this?
Can anyone point me to any routines to parse out the components of a name string. The strings I have may or may not have a title such as Dr., Dr, Mr, Mrs., etc. It may or may not have one or m...
I am accessing Excel thru Access VBA code. I open a file, calculate some fields, then close the file. When I close the file, I'm prompted if I want to save the changes to the file. I don't ...
I have two radio buttons in a frame called: frmReportingPeriod. The choices are Monthly(1) or Weekly(2). I was thinking about putting a function in a module and calling it in a query when i...
I have a one to many relationship (a table on one side) and a view from a different table on the other.
Here is the SQL
SELECT dbo.IndependentContractors.DriverNo, dbo.IndependentContr...
If I have several dates in a particular month. In my query, how do I get a count for the month in access to combine all dates in each month?
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 have a subform displaying a column of equipment code values and I want the ability for the user to click on the label header to start loading in those values to the clipboard as a column to ...
I have emp, ID, name columns on the same excel sheet. EMP AND NAME ARE SIMILAR BUT MANY OF THE FIELDS ARE DONT MATCH. For example, I have "Jerry BB" in Emp column and it is " Jerry" in ...
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...
