There is a table in my database that contains information on clients (tblClients). Two fields in the table - ClientName and ClientID - are indexed, no dups allowed. The client name is the firs...
The database here at http://www.dropio.com/tasksdb is not quite finished as the main frmAddTasks needs one item separated into a separate form.
Once it's finished though I will need to pu...
hello ....
I use the following code to create a unique form to the current logged in user. This works, however, in a multi user environment I get this run time error (2501): the copyobjec...
Hi -
I'm creating a budgeting/forecasting function. I've got the actual set of values in one table and the budget values in another table (didn't make sense to put them in the same table ...
In the application, the user opens an appointment form. From this form there is a button to open the client's data in another form. The user can possibly delete the appointment in this later...
I am using MS ACCESS as database and C# windows application..
While i am trying to insert a name with single quote(') access throws error.
Let me know about the syntax.
Thanks in advance
Hello,
I may have to ask a more specific question- but I am hoping when I explain what I am doing somebody will have an idea.
I usually- when I want a text box automatically filled on a form...
I am working with Access 2003.
I am a novice.
I have a form and subform setup and cannot get the main form to add a new record. My subform will allow as many records as you wish. I c...
I have a form and a subform that when the user filles in all of the information - I want some button's to be enabled and/or error's highlighted in errors. The code works fine when applied to ...
I have a form where I need to be able to select multiple options for languages spoken.
example
English
Spansih
Greek
Russian
What wo...
Thanks to the fine work of eghtebas who suggested in the related question, that I needed to put the rpt into a form in order to make fully customizable, this process has begun.
Currently, w...
I have a drop down box with five different listing, ex: CS, DW, HW, EEW, FMCS. When I click on one of these listing I want it to fill the box on on the form with the same name. I have 5 di...
Hello,
My code:
Dim varEmail As Variant, varEmail1 As Variant, varEmail2 As Variant
Dim strTo As String, strCC As String
Select Case Me.MARKETCONCENTRATIONS
Case "19"
...
On a form in Access
I have a txtbox [DateOut]
right now I have it display result of ([DateIn]+[number])
Now I need it to not count weekends ( saturdays and sundays)
example DateIn: August ...
I have some functionality that I've just added to my database with help from EE. I am displaying a picture that is referenced by a text box in a manner similar to the NW database. I have an ...
In my table, I have the following fields:
A# - can have multiple Treatment #s
Treatment Number - has 1 associated Hospital
Hospital - can have multiple Types of Treatment
I need to be ab...
Hello, I have been using something similar to this:
Function GetDateOut(dDate As Date, Span As Integer) As Date
Dim j As Integer, i As Integer, dtStart
dtStart = dDate
For j = 1 To Span
...
I have created 4 forms titled: Form1, Form2, Form3, Form4.
within the Form_Load Procedure of each form. I have placed the following line of code:
FormLoad.Stds_Form ("FormName")
This li...
Hello Experts,
I have a main form that opens another pop-up form requiring user input.
I want this popup to open in the same place on the main form every time.
I did not want include the po...
How can I autosave value in strFileName in a Pdffolder which is also in another folder named GrpReports
such as the file is stored in:
GrpReports\Pdffolder\strFileName
such that it look...
Ok so I have this access database that I inherited and I have been asked to add some boxes on one of the forms to show some calculation. I added the boxes and in the control source of the boxe...
I've created an Access 2003 update form that has its Control Source set to a query. However, the form is coming up blank (empty fields) because the query is not getting executed because there...
i have been struggling for days to create a form that will have drop downs for a user to selcet what filter they want to use on opening a report.
I can get the report to work on it's own, b...
. . . does someone know where I can find it? I'm using Access 2003. Thank you!
I need to rollback data was entered in a form(continues) in access.
