Hi, I'm trying to set up a parameter query that prompts a user to enter a value, but I'd like the user to pick the value from a list. I haven't discovered how...
4517
Margaret Watrous
mwatrous@...
Aug 6, 2002 2:42 am
Lang, I create a form that includes a list box or combo box based on a table or query. (Access wizards will help you make the box.) Then I create a report ...
Mararet and James (personal response)--thank you so much, these solutions work perfectly! Lang Waters ... table or ... a report ... and ... make the ... ...
I am in the process of creating a database for a company with a multi user network connecting approx 10 computers, possibly more in the future with Internet ...
You will need to use SQL for the database on a Microsoft .NET frame and you will need to bring out the $$$'s. .NET is cutting edge and the future, Microsoft is...
Hi everyone I have written an Access app that uses the references to Microsoft ActiveX Data Objects 2.7 Library and Microsoft ADO Ext. 2.7 for DDL and...
Simply go to www.microsoft.com/ado <http://www.microsoft.com/ado> and download the retail development kit for ADO 2.7 then install it on the server... ... ...
I have a form where the user enters up to 5 percentages. I add up the amounts and display the total. I would like to print a message if the total does not...
Use the MsgBox Function (Documented in your help file if you search for ... It goes where you want it to go... depends on whether you want it to do it when...
4528
Margaret Watrous
mwatrous@...
Aug 22, 2002 1:44 pm
Yes, it goes in an event procedure. Good places to put it: On the field's Lost Focus event, or the following field's Got Focus event. Here's an example, where...
Can anyone help a new Access user? I've been trying to split a table using Analyzer in Access. It works fine except that it always misses out some values in...
Can someone please help a very newbie? How do I get a report from MS Access Inventory Control Database template to list Category - Product Name, Units on Hand,...
I have many different dates in a text field that were imported from a works document. Unfortunately many had the year of 1900 - 1902. how can i replace just ...
Jason, I would change the format to Date/Time, then try running an Update Query using the DateAdd function to add 100 years to the date. If you need to keep...
Create an update query and run it on the table with similar sql code to the following: UPDATE myTablename SET myDateTextfld = Month(Cdate(MyDateTextfld)) &...
Is it possible to set up a query so you can enter a date one time and check different fields for that date? Example: get date range from 05/01/2002 to...
Yes, just use the same parameter names in the different criteria ... I am assuming you mean you want to return any records where one of these dates falls in...
Thank you, that worked just fine... ... criteria ... ... these ... <http://rd.yahoo.com/M=229441.2336363.3766536.2225242/D=egroupweb/S=17 05 ... ...
4537
Greg Kane
integrity@...
Sep 16, 2002 10:37 pm
Dear Brainiacs, I've got a _simple_ A2K db that not only won't work, it keeps crashing Access. Very frustrating. I've been managing my consulting business ...
4538
Greg Kane
integrity@...
Sep 17, 2002 12:40 pm
In a form based on a multi-table query, what controls which table the 'new record' button at the bottom of the form gives you a new record in? Say your db has...
Create a form for the one side, then create a subform in that form for the many side... then you use the master/child properties of the subform control to link...
4541
Greg Kane
integrity@...
Sep 17, 2002 2:27 pm
MessageNope. Where'd you get them? GAKane Have you applied the latest service packs? ... From: Greg Kane [mailto:integrity@...] Sent: Monday,...
4542
Greg Kane
integrity@...
Sep 17, 2002 2:37 pm
MessageJim, Thanks. But isn't that going to limit you to searching just the manys linked to a single one? Say you've got one->many tables, vendor->invoice, ...
Do you have any Memo or OLE Object fields? I smell corruption.... HTH, Steve ... Dear Brainiacs, I've got a _simple_ A2K db that not only won't work, it keeps...
In reference to your original question: It should be created in whatever Table was the inner-most one side of the relationships in the query say your querys...
