What is the VB code I would use to create a link for a table that currently has no link.
i.e. ("Table1" has no link created for it yet. It has data in it, but the data in it currently does...
Relatively small Access db hosted on server. Excel used by several users to download data. I've tried using both ADO and DAO, but still have a problem with the database only allowing at most...
Dear Experts,
In the following VBA I am trying to use a Lookup sql to retrieve a value...But, it doesnt like the syntax....Can you please tell me what it ought to be?
If Me.Form.Head_Fam...
Dear Access Expert
I am using Access as my front end but I download a large amount of data into Excel, massage it there, and then import it into Access. I would like to have a form with a ...
I have a customer who wants to use runtime access 2003. If I purchase the full Access 2003 license/CD does it come with Access 2003 Developer Extensions?
MS Access
When I open my form all records show up. I'd like to be able to have a drop down list filter as follows:
- Show all records for this week
- Show all records for this month - (defa...
Help needed please!
I have a form called PupilAttainment3 which shows pupil details, attached to this form is a subform called fsubPupilAttainment. They are linked by Pupil ID. I wish to fi...
I have a MS Access 2003 database and have recently added a new currency field. However, the problem is that I now need to be able to select different currencies from another field. The curre...
Can't find an explanation anywhere.
how to use checksum in microsoft access
I'm running the following SQL statement and it breaks when rstTimekeeperList!ProfName = O'Reilly
'sum timekeeper hours
strSQL = "SELECT tblProfessionalsTime.ProfName, tblProfessionalsTi...
Now that it opens when calling the .bat, I need to suppress the message to make it auto-run.
This is driving me nuts.
I have an access database, with a form called frmStatus.
The form has txtStatus and lblStatus
I have a module which wants to change the value of the textbox or l...
Hello
I am trying to change the format of a write to file to left justified format with trailing spaces instead of right justified with leading spaces (apparently default)
The below code s...
I am trying to create a function in vba that will return a file name from a format simialr to the below:
\\server_location\xxx_yyyyyyyyyy.ext
from the above example I would only want the...
As it says, I want to stop the Users of my app from using keyboard shortcuts while using it. Call me control freak if you wish...
Many thanks.
Hi,
So I have a text box with a control source DLookUp value. I want this value to update after I do the following which already works:
1 - Run Code that produces msg box (ok cancel) which...
I am getting "for without next" error on the last line of this code. It's referring back to this line:
For Each rptobj In CurrentProject.AllReports
this code is a conglomeration of a functi...
Is there any way to sum records in access report with dsum only when ID changes using vba?
GrantID and the amtawarded associated with it will appear numerous times in a report (because ther...
I just finished a class module, but I'm not quite sure how to use it.
What I want to do, is on a form, set up a timer (500ms or so), and in the ontimer event, check to see if a control has ...
I am working on a routine that requeries a form, then does some other processing assuming that the form's resultset is up to date. It worked on fine in one form (where there were very few entr...
I have a report feeding from a query which I'm trying to group in a report. I'm using the "sorting & grouping" wizard. I've selected the field i want (CustodianID) and added the expression to ...
I have an application that is processing a large Access database (tables are external of program). The routine in question was originally using ADO LIB 2.1 connections and recordsets. I rewr...
I am trying to add a record to a form based on the AppID of the form I am on.
I believe the code for this to be:
docmd.openform "frmLetterOfCredit",,,"[appID]=" & Me.appId
but my problem...
I am creating some custom reports and I want it to be as automatic for the client as possible. SO I made a switchboard that pulls up all the different reports available. Each project that th...
