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...Hello 04-11-10
Haw do you do?
...Vista Access 2003 & Ole
I have a DB I've been using, updating for several years. I use a =
different BMP on every record. Today I started to update it again. Last =
update a few weeks ago on my XP.
Today I went with 'insert object' 'create from file'. with XP I couldn't =
use JPG's so I made bmp's. Today even a bmp is just an icon.
How do I get the create from file to work again ?
more pix @ http://members.toast.net/cbminfo/index.html
...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?
...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <email@example.com> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...building form @ runtime vs. hiding existing controls
I'm trying to decide just how bad runtime design is. Most opinions seem to
steer clear of adding controls, events, etc at runtime. Instead, y'all
advocate keeping controls on the form and hiding them as necessary.
In my application (which will not be an MDE) , each user session builds a
new form - from scratch. Once the form is built, there are no design
changes. And when the user is done the form object is deleted.
Troubleshooting may be more difficult with a form that only exists at
runtime. OTOH, documenting and tracking unused controls (or not having
enough controls, ...Unable to launch GP
We have one workstation that cannot launch GP. It had worked in the past but
now we cannot launch GP from the icon or from Start > Programs. We've tried
dragging and dropping the .set file onto the .exe file. Even double-clicking
on the .exe file does nothing.
This PC has the same anti-virus software as the other machines - Symantec.
We also tried copying the GP folder over from a working workstation.
Exactly what does happen when you try to launch? Does anything show up in
the task manager?
Leslie Vail, CPA, MCT, MVP
MCBSP-Application for Microsoft Dy...GP Business Alert
We are using a 3rd party hosted email solution. We are using Outlook
Express on every client PC.
When I was going through KB article on GP Business Alert setup, under
the server type setup, the KB article called us to select Microsoft
Does it mean that I must use Microsoft Exchange Server to have
Business Alert setup?
Any advice is greatly appreciated.
...Need help with formula 01-13-10
I am trying to adapt a formula in I2 from another spreadsheet that works
well, but won't in mine. I've traced the error, but I would need help to
understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be
advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a
list of non-workdays, and defined the column of dates with the name "NWD".
What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb.
5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb.
5, and Feb. 6 and...unable to access mail after re-enable account
After enable an disable account and change its password,
it can login to its mail account. What's happening. Is it
Thanks a lot
What is the error message when user tries to access mailbox? Does the user
still show in ADUC has having Exchange attributes? Have you looked at the MB
using ESM to see if it is disconnected?
"Raymond" <firstname.lastname@example.org> wrote in message
> After enable an disable account and change its password,
> it can login to its mail account. What's hap...Keyboard hooking through Accessibility
I am looking for a method to hook the keyboard without running a
background process. I know there are APIs for hooking
(SetWindowsHookEx), but I want to avoid the overhead of running another
background process for this and make the task do by windows itself.
I am thinking of tweaking the Accessibility option in windows for this.
Can we anyway do this by writing any script or modifying or adding
registry entries for Accessibility? Or is there any Accessibility
specific APIs which can re-program the Accessibility feature to do our
tasks when we press a key with Accessibility feature-on.
The following formula works fine:
However, I cant seem to get the following to work:
I need to be able to summarise (using a headcount indicator (1) in Column
CI) ...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <email@example.com> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...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,...Error Site Modifier
I am trying to run site modifier and I am receiving an error I cannot
figure out. The error is [Microsoft][ODBC SQL Server Driver][SQL Server]Line
1: Incorrect syntax near '1'. I have tried reinstalling. Still same error.
Does anyone have any ideas to fix this?
...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...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...Modify Global Address List
Quite new to this, and have inherited a Win2003&Exc2003 Enviroment
One of the Managers has realised that the GAL has a full and uptodate list
of all the users in the organistion (appart from a few staff members with no
PCs), so has asked the the sites stop using pieces of paper with every bodies
email and Telephone Numbers.
In AD2003, we have gone through and created userid for staff with no
computers, but not creared email address, and entered telephone numbers under
the General tab, and Mobile, Ext, Home numbers under the Telephone Tab.
But the GAL is only showing the General Tel...Tr again: Modifying Calendar's "reading" view in 2003
In Outlook 2003, Calendar allows me to show the event's content in a
"Reading" pane at the right or bottom of the calendar. But the layout of
the Reading pane wastes a lot of space. Can its layout or content be
No, the content can't be modified.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com...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\...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <firstname.lastname@example.org> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...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...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...GP 10 sp1 Installation guide
Did anyone get a copy of the installation guide for the sp? I am downloading
the sp but I get an "access denied" error with the docs.
If so, can you email to me offline. Contact me and I will send you my email
I was able to download the install guide. Please send me your email and I
will email to you.
> Did anyone get a copy of the installation guide for the sp? I am downloading
> the sp but I get an "access denied" error with the docs.