adding a picture
Sat, 6 Dec 2008 14:50:42 +0200
Hi there
I am creating a windscreen repair database. On the "jobs" form. I would
like to insert a picture of a windscreen - just the basic drawing (just like
a block), on which the user must be able to mark on the picture where the
windscreen chip is located (with a spot or cross or something). Is that
...
|
Combo Box
Sat, 6 Dec 2008 14:31:37 +0200
Hi
I have a form for "Clients' which has a subform "Vehicles" to view all
vehicles for a specific client (this is a windscreen repair company
database)
I also have a form for "Companies" with a subform also for "vehicles"
then i have another form "Jobs" where I select the client from a drop down
list ...
|
Calculated tax percent keeps repeating same tax in each record.
Fri, 5 Dec 2008 20:35:00 -0800
HI,
Calculated tax percent is working and gives me the right amount of tax but
it keeps repeating the same amount of tax in each new record. The same tax
amount shows up even though I have not yet entered the original cost. I used
for the Tax field =Sum([Original Cost] *.051)
--
Thank you,
Gotoknow ...
|
DLookup Issues
Fri, 5 Dec 2008 15:58:01 -0800
Looking for someone with a lot of patience to answer my DLookup question.
Let me start by saying I am weak at best when it comes to expressions/codes
so be gentle.
I have a table, tbltest, that has the following fields:
testID = Autonumber
test# = Identifies the particular test. I have several 100 serie ...
|
ApplyFilter Macro
Fri, 5 Dec 2008 14:31:13 -0800
Using Access 2007 I created a List Form based on a query. I am attempting to
create a List Box (based on another query) that I can use to filter the
records on the form. The target field is a text field. When I create an
Apply Filter Macro as I have with earlier versions of Access, it does not
work. I us ...
|
Dynamic Query from Form
Fri, 5 Dec 2008 14:20:47 -0800
I have a Form set up, and it is linked to a Calendar. The calendar dates go
into tow TextBoxes just fine, but I can't seem to pass the values from the
TextBoxes to the QBE grid. I tried the following:
[Forms]![Calendar].[QStart] >= #" [QStart] & "#"
[Forms]![Calendar].[QStart] >= #" & CDate(QStart) & "#" ...
|
Dir() function does not work in a textbox
Fri, 05 Dec 2008 22:13:43 GMT
I've got a lot of Access and VBA experience but this has me totally stumped.
I have one user who gets a #Name? error in textboxes that use the dir()
function.
The original control source of the textbox is
=IIf(Len(Dir("T:\Claims\" & [carrier] & "\claim " & Left([claim register],7)
& "; " & [pro] & "\cost. ...
|
|
|
Subform to Main Form Record Problem
Fri, 5 Dec 2008 13:45:46 -0800
I have a main task table with a subform that has task elements and another
subform within the task element subform to record multiple employees. The
form is showing the same top level record two to three times depending on how
many subtasks I create. How do I get the form to only show the main top
level re ...
|
Concatenating a series of rows in a table
Fri, 5 Dec 2008 13:26:54 -0800 (PST)
Hi,
I have the following function which I am using to create a string of a
series of values in my table.
Function Concatenate(pstrSQL As String, Optional pstrDelim As String)
As String
Dim Rs As ADODB.Recordset
Set Rs = New ADODB.Recordset
Rs.Open pstrSQL, CurrentProject.Connection, adOpenKeyset,
adL ...
|
popup number selector form
Fri, 5 Dec 2008 13:17:05 -0800
I have quite a few users that like to "click" as opposed to "type". They
have asked that, when choosing quantities (or anything else that requires
numerical input) that a pop-up form is displayed to let them click the number
they want. So they would click the number 9 on the popup form, and the 9
would be ...
|
