Dear Experts.
I am using Access 2003 to build a simple staff database and want to record the languages spoken by each member of staff (this can be more than 1 language). I want to be able t...
I have following statement
SELECT Sum([PRIN BAL]) AS [SumOfPRIN BAL]
FROM [THREE-MRTG] LEFT JOIN [MASTER] ON [THREE-MRTG].[T-Loan-No] = [MASTER].ACCTNO
GROUP BY [THREE-MRTG].[MRTG-NO];
S...
With MS Access 2002, we created a Data Access Page that we have been using for several years with Windows Internet Explorer 5 or 6. The page includes a navigation control so the user can clic...
I have some VBA expeirence and very little expeirence using the calendar control functionality within Access. For the table I have ID and Date, I have a Query with ID and Date + 8 days. I nee...
I have a form that allows you click on a record and edit it and then save it again back to the table. I changed one line of the code becuase StoreNumber changed from a Number field to a Text f...
Hi!
I need urgent help!
I have a access database and it is placed an a share folder. I put permision to all users on the folder and also I put permision an the database. On the share folder ...
Hi,
I've got a query with a subquery:
(SELECT Top 1 a.boatEnvID from boatEnvData a, boatSightings b where b.boatsightingsID = boatSightings.boatsightingsID order BY abs(boatSightings.si...
vba access 2003
I'm using the code behind a form using the Text0_AfterUpdate property.
Basically I want to use the values typed into a textbox and create a string (nf1) to use these to...
I have downloaded and registered the vbSendMail.dll and MSWINSCK.OCX files and successfully added the SMTP Send Mail for VB6.0 reference to my MS Access project. I also copied the copied all t...
Can I put some code in the load event of my form that will clear the user's clipboard?
I have a database that when you open it it has a simple form that you select your name on a dropdown list and then type in your password. if correct it then opens up the switch board.
I have ...
I'm trying to get a specific PDF to open and print. Using the code below I am able to get the desired PDFs to open but not print. I've looked at many examples and they appear to be using objec...
Hi,
I am trying to figure out a way to set up outline numbering in an ms access report. I have 4 tables, which are all related. Each table is a subset of the previous table. For example, if...
When I create a new record if I tab to the number field I can enter number in fine. However, if I click on the field with the mouse when I start begin typing a number a Zero appears after the...
I have an Excel export that I would like to cancel if there is no data in the underlying report. The underlying report has a Cancel = True on the "On No Data" event. The problem I am having is...
I have a table with a list of prices for 4 different suppliers - I want to find the average of the lowest 2 and display on the next column on a report.
Table:-
Product Price1 ...
Can't seem to get this to work though I have gotten in the past similar things to work thankfull to Expert Exchange. Getting the error Syntax error (missing operator) in query expression '[Ma...
Experts,
I'm developing a database application based on a spreadsheet. I have experience with Access, but have been away from the tool for a long time. I asked a question earlier and LSMC...
I need help with a Left Function / Format Function that has a twist
Private Sub MyField_AfterUpdate()
Me.MyField + Left(MyField,2) & "-" & & Format(Mid(myField, 3), "0000")
End Sub
Wor...
Dear Gurus,
I have a great piece of code I got from a developer here. It works fine except I need it to enable WINDOWS AUTHENTICATION and not TRUSTED CONNECTION!
Anyone have an idea how?
...
If I run the following code....
docmd.setwarnings false
docmd.openquery "qryUpdate"
docmd.setwarnings true
how can I test if it has been successful or not. For example, because I have...
I have my access linked to mysql. I have a cutsomer form and from the customer form I need to add events. The code below is what I am using to add the events through VBA. I am getting an ODBC...
I am trying to print a text page on the printer. But, I cannot get it to go to a new line. The lines print on top of each other. See code. Where do I go wrong?
On my machine with access 2003, controltip takes about 5 seconds to display, which is annoying.
So, I am looking for a simple way to speed things up. A tools option (or even a registry ha...
Is it possible in a ms access report, to print the report footer on the first page of the report instead of the last? I need text just on the bottom of the first page, and I don't have room t...
