I have a form 'frmMultiSelectHistory' that has two unboound fields 'StartDate' and 'ExDate' that are used to select dates. There are times when dates have selected values they work like a char...
I have a template in MS Word, I want to write Access code to fill up the empty fields where bookmarked in the template. But I encountered a prob:
In the template (see attachment), I put [bkmA...
I'm finally embarking on the large project of normalizing a portion of our database!
I am doing all of the steps in VBA so I can throughly test before it goes live. My question is:
How ...
I have the code below which suppose insert the values if there is no error. If there is an error then it should print a customized message box. It works fine if there is an error. It pops up t...
Hello,
In my Access database, I have a table with a list of photographs which are either taken in Black & White, Colour Slide, Colour Print, or Digital. Each type of film can have more tha...
I imported a file in Access where the birth date field was in the following format mm/dd/yy. When the dates where imported, Access changed some dates to future dates: ie: 01/20/29 became 01/2...
hi
this is probably pretty simple, i have a table named PNtable in access with just 4 fields, one of them called Notes, I have a form called PNform , I would like to have a coomand button o...
I get a type mismatch when trying to pass the error object to a procedure.
Sub DoSomething
On Error GoTo DoSomething_Err
DoSomething_Exit:
'Cleanup
Exit S...
I have a process that saves the record into the table from an unbound form. However, if the user needs to make additonal comments. How do I add thecomments without overwriting any comments th...
I need to find information about an image file that is stored in my Access database. The Access database is composed of link tables that are connected to a SQL Server database. Can someone try...
Hi,
I have a multitude of Combo Controls that I use throughout my database. They are usually based upon a query of some sort.
What I would like to do is have a Function that fires when ...
Hello,
I have a form that uses a timer function to track the duration of a phone call.
in the OnLoad event of the form I have:
Private Sub Form_Load()
Select Case MsgBox("Start Call...
Can this be done in code?
References would be helpful
Thanks,
Experts,
After we delete the main switchboard from the forms. How do we get it back? If we go to tools -> database utilities -> switchboard manager, the default switchboard is still there, ...
Experts,
Would you remind me how to do one thing in MS Access Report? The report is created out of a table of date, saleman, and various other entries. We want to create a report of this ta...
I have a form (frmMain) with a subform (frmMain_Sub).
In frmMain_Sub, i have a public subroutine in the general section of the VBA code:
public sub HideControls()
me.lstHMI.visible =...
How can I, through VBA, control the scroll bar position on a form?
I am requerying a continuous form which caused the focus to return to the first record. I have a search to return to the ...
Hi,
Is there any way adding a set piece of text into a Memo field after pressing a cmdButton, a sort of autotext. The Autotext could be saved in a table called tbl_autotext and could be cal...
Using an update query and how do I append a statement to the end of a field that might be empty for some records but not for others without deleting the existing contents. Thank you.
Can someone give me some code to create a button on an Access From when clicked it returns the images size of a displayed image on that form. The form has a field that displays images stored i...
Hi,
I have an Access DB where I have two unrelated tables
A) Consultants
B) Client team
Each contain a list of Company Names and other unconnected details. There are no names that are re...
Hi,
I am not sure what I am doing wrong with this code. I want to insert into the record then refresh the form. The error is with the insert.
Private Sub Form_AfterUpdate()
Dim dbs...
Basically I have 2 fields .. "Field A" and "Field B", both fields are part of a table, query, and form. We are happy with fields A and B.
I need to create a Check box "field C" that will ...
I am using the findnext method and for each record found, I take an action.
It's seem, that I have an infinitive loop.
Do I have to use the Movenext instruction with a findnext ?
Privat...
I would like to be able to create charts on the fly in Excel. The data is in an Access database.
I would like to be able to select a variable from the database, provide binning values, retu...
