Form for table
Here's the problem:
Access 2003, XP Pro-
I have three tables that are related by primary keys. I have a
table[Table QC] that has the field [EmployeeID], the data type is
number--that field is linked to the autonumber primary key of the
Employees Table. So far so good. I am trying to make a form that has a
combo box that looks to the Employee Table to get me the drop down of
the employees (Last Name, First Name). The SQL statement builds out
okay, and I get the correct name config., but because the data type is
a number it won't accept the data. I looked at the Northwind example
and i...Build Dynamic Query from Form
I am trying to build a dynamic Query from a Form.
I keep getting an error that reads ‘Object qryFilter already exists’
I suspect it has something to do with the string of dates being passed to
strDateCondition = "([Trades].[TDATE] Between [Forms]![SearchForm]![cboFrom]
I am trying to add a means for a user to Query by Customer and Trader AND
all records between two dates. This was working fine for Customer and
Trader; when I added in the code to filter by dates I started having
I know the SQL will be li...No Form Assistant in Quote Product Screen
While entering data in the QuoteProduct screen, no Form Assistant is
Is it the usual feature or I need to configure something to view the
Also is it possible to see contact hierarchy in an account in the form
of a Organisational Chart?
Is their any add-on available in relation to this?
...Linked graphics into a Publisher 2000 document
I have a 400KB document (withgout graphics). I insert two
JPEG images each around 200KB into the document. I figure
the resulting document should be around 700KB. Result? An
I delete the images (document is now 400KB) and instead
insert the images using the "Link to File" option.
Graphics Manager confirms that the images are linbked into
the file. The size should not be more than 500KB. Result?
An 11MB file.
Question is how can I insert images into a Publisher 2000
documentr without the file blowing up? And why does it
Richard wrot...Sum in Form Footer
I've made a the following calculation in form Detail section into text
box and I've called my text box "Chaussures"
this sum calculate the sum of Units which are into these text boxes
"aldo", "Feet-First", "Transit" and "Globo" and this for each line
Now in the Form Footwear, How can I make the total of units
I've tried a lot of things and nothing seems to work.
Your help will be much appreciated,
Thankign you in advance,...Appending in a sub form
I am creating a venue ticket tracking DB in Access '07. tblVenueEvent has
info about Venue, date, time, event with a VenueEventID (key field) which is
linked to tblTicketInfo which has section, seat, row, etc.
I set up an entry form completing VenueEvent info with a sub form for ticket
Some of the venues have a standard set of seats that I want to "auto
populate" into the sub fom.
I have set up a Venue table with the standard seats for the venue.
I can set up an Append Query on the sub form, which does append the
tblTicketInfo, but does not capture the VenueEven...Background changes conditionally
I have a spreadsheet that shows the floor plan layout of my call
On each desk, the desk number and identity are displayed. I would like
to colour the background for those pcs that are on the same subnet.
I have a sheet called data - it contains Table Number, Desk Number, PC
ID, IP Address.
How could I get it to change the background colour if the pc is on
subnet 162, and set a different colour for those on subnet 167
PeterG's Profile: http://www.excelforum.com/member.p...Running an Excel Macro from an Access Command Button
Can anyone help me with this, I am trying to run an excel macro from an
access command button.
I want the macro to Bold the Headings on a excel spreadsheet.
The code runs without any errors but the macro doesnt seem to work, I think
I have got the line
ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong
Private Sub cmdRunMac_Click()
Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook
Set ExcelApp = Excel.Application
ExcelApp.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and
Settings\...Is there a way to convert OE 03 form templates?
I have a user that has upgraded from outlook 2003 to outlook 2007 and has a
form template from 2003 that is in a FDM extension.
Outlook 2007 is unable to read this form.
Is there a way to convert this form, or will the user just have to create a
new form with their new version of outlook?
Any information appreciated.
What happens when you try to install the form?
Any error message?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
http://www.ms...Link to Power Point
I placed a hyperlink to a powerpoint file on my web page. Upon clicking on
the link the "Run/Save" window comes up. Is it possible to just have the
Power Point file run without the "Run/Save" window coming up? If so, how?
Posting a question 4 times isn't going to get you an answer any quicker.
Try to be a bit more patient.
>I placed a hyperlink to a powerpoint file on my web page. Upon clicking on
>the link the "Run/Save" window comes up. Is it possible to just have the
>P...Multiple Item Forms
Hi. I am new to your form and am struggling with the Multiple Item Forms. I
want a combo box on the top that will select an id number from a table called
'SurveyA'. The multiple item form should then only display the records in a
table called 'ActTravDiary' with that id number. As the ID number is changed
a new group of records should be displayed in the form.
I know how to initiate a change in one combo box based on another combo box
(i.e. Row Source), but I cannot find a similar property for the multiple item
forms. Please help.
On Fri, 12 Feb 2010 21:00:2...Hyper link one column to another
I would like to have my columns hyper link one another.
For example: Click on B2 would take you to N2, and vice-versa. Click
on C2 would take you to O2... and so on through column j linked to V.
Is this possible without having to make the link for each cell?
This is a timesheet template and the columns b though J are the hours
and N through V are the text comments for those hours. When I copy the
template to a
new sheet, there will be no data in any column. I would like to be
able to enter an amount or formula (=end-start) for time spent and then
be able to click on that cell and hyperlin...linking sheets
How do i link my drop down list in a13 sheet 1 to column f in sheet 2.
if using Data Validation to create your drop down list the easiest way is to
range name column F in sheet 2
(go to sheet 2, click on F, click in name box (left hand side of formula
bar) type name (no spaces), press enter)
then click in Sheet1!A13, choose Data / Validation, choose List - click IN
the big white box, press you F3 key to bring up list of names in workbook,
choose the name, click OK, click OK again and it should work fine.
Hope this helps
"Jinx" <anonymous@discus...Set Enabled On All Controls in a Form?
I am trying to set all controls visible, unlocked, and enabled, as the
baseline for disabling or locking down some fields based on other
criteria. Here's what I tried, which gives me an "Invalid or
unqualified reference" error:
Dim ctl As Control
For Each ctl In Me.Controls
.Enabled = True
.Visible = True
.Locked = False
I based this on several examples that were intended to do something to
all text boxes on a form. (I have never done this before, so sorry if
this i...VBA using an image as a toggle switch
Hi hope you can help.
I know next to nothing about VBA and have adapted code below from stuff I
I simply want to show hide portions of my page to cut down on screen
I have assigned my macro to a screen image but was wondering if I could have
a hide and unhide under the same button.
Any help would be much appreciated
Application.ScreenUpdating = False
Rows("25:75").EntireRow.Hidden = True
Rows("98:148").EntireRow.Hidden = True
Rows("171:221").EntireRow.Hidden = True
Rows("244:294").EntireRow.Hidden = T...Remove format link?
Is there a way to remove the format link between fields in Modifier? Help
just shows how to set it and the usual stuff doesn't seem to be working.
...filter records in a form
I've created a form with its subform to enter tasks of employees. however I
need filter records only for active employees
The form has as a source, the table CARD_EMP (employee card). It has a field
ST_EMP for the employee status (Active , Pasive)
In the Event Form_Current I wrote
but it doesn't work
Thanks for advance
Message posted via http://www.accessmonster.com
Your advice was the solution
Thanks a lot
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscodin...GENERATE a TEXT FILE Using INPUT from a Form ??
I need to generate a Text file using (partly) information entered by the user
on a form.
I already have the TEMPLATE for the text file......I need to generate a COPY
of the file with the word entered by the user into the form INSERTED into the
The text file is actually code for a web page (will have an .htm extension).
The file is simply an exact copy of an existing template with only ONE ITEM
of the text changed to a word that is entered into a form by a user.
One line within the template file is:
"We have several of these items available in BLUE."
I have...Missing send/receive button #2
After I installed Outlook 2003 on a new computer and migrated my data file,
there's no send/receive button when I click on personal folders in Mail and
it doesn't appear on the tools menu. I've done reinstall/repair twice
without fixing the problem.
Is there some configuration procedure I need to do? Thanks for any help.
> After I installed Outlook 2003 on a new computer and migrated my data
> file, there's no send/receive button when I click on personal folders in
> Mail and
> it doesn't appear on the tools menu. I've done reinst...In excel how do I delete an option button form already in worksht
Hi Va Run,
Activesheet.Shapes("Option Button 1").Delete
Change the name of the control to accord with your situation.
"Va run" <Va firstname.lastname@example.org> wrote in message
...Displaying time from 00:00 to 0.00
I want to do the opposite to what I have seen on the forums and convert
time back to decimals ( I work on aspreadsheet but it has been
passworded so I can't crack it. :)
I want to be able to write
(van out) (Van back in)(Total Van time)
7.25 11.25 4.00
Can anyone help me please ( or a way to crack passwords):cool:
North for Short
North for Short's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22695
View this thread: http://www.excelforum.com/showthrea...How can I use a form (Excel) to add a column of data to the right.
How can I use a form (Excel) to add a column of data to the right of a list?
It's a simple matter to add a column to the left of a list by writing a
macro that inserts a column and then pastes the values. However I want to
have the data pasted on the right of a list, if only so that I can easily run
a chart from it.
...Multiple Background Shades in Graph
I'm trying to create graph with multiple background shades. i.e if i were
trying to create a graph of the price of a stock, when the stock has had an
upward trend the background would be a different color than that of when the
stock has had a downward trend. Also if the colors of the background would
only be on top of the stock plot. Any help would be greatly appreciated.
...Linking a table from a Secure database
I have 2 database both with their own workgroup file(mdw) I like to link a
table from one secure database to the other secure database. Is this posible
with them having two different workgroup(mdw) files.
On Thu, 10 Dec 2009 12:30:01 -0800, cpager
I don't think so.
The more common scenario is where several apps are secured using the
same MDW. After all, if Joe is in the ShippingDept group, he is so for
Microsoft Access MVP
>I have 2 database both with their own workgroup file(mdw) I like to li...How do I get a list of data on one sheet into the form on the fir.
I have a timecard form on the first tab of a workbook & the various employee
crew combinations on each of the subsequent tabs (each crew on a seperate
tab). How do I format the for to get the employee name info from the
individual crew tab required?
Let me clarify my question - I am trying to use the first tab (the form) as a
constant form & just change the employees names in that specific field based
on the crew I want to generate the timesheet for. The crew lists are on the
sugsequent tabs. I would like to be able to select the crew & print the form
with only those emp...