Rating Thread / Thread Starter	Last Post	Replies	Views
Start an application with a click on a button? Hello, We want to start an application (open the file) with a click on a button. We only have the filename, so windows has to start the belonging... Eddie Smit	07-25-2003 03:56 AM Eddie Smit	2	48
Date conversion Hi I have 2 strings I want to convert to a date d1=2407 'day and month I extract d1 and d2 from a string with the Mid( .....) d2=2003 '... Alfred	07-25-2003 03:49 AM Keith Wilby	4	56
Query - "Is Null" and Blank field issues PROBLEM Hello all, I am trying to build a query that will compare records in two tables (Table1 and Table) Tables have identical design, however besides... Vasilije Petkovic	07-25-2003 03:13 AM russ	1	38
Access Date - Rule Validation I need a vadation rule for a form entry to a date field. The date entered by the user must not be today and must not be in the future. The date... Chris C	07-25-2003 02:58 AM Chris C	0	50
EMail to L-Notes or SMTP On Fri, 25 Jul 2003 01:32:37 +0000 (UTC) in comp.databases.ms-access, "John Hawkins" <junk (AT) fabalou (DOT) com> wrote: I got it from another... PJ Smith	07-25-2003 02:23 AM Trevor Best	2	52
MS Access + ASP + Error Catching. . . Hi: I have a table with a text field called NICKNAME. This field must be unique. How do I error handle that so that when a user enters data via... cam	07-25-2003 02:01 AM cam	0	59
converting a string to a variable name Could someone please tell me how I can convert a string to a variable name as in dim str, var1 str = "var1" now I want to be able to set the value... Brian Rypstra	07-25-2003 02:00 AM Roy in \(H.E.Double Toothpicks\)	1	43
word formfields Hello there group ;) I am trying to export a value into a word documents form field and am using something like strDocName = "c:\test6.doc" Set... Michael	07-25-2003 01:17 AM Michael	0	62
Follow up to Urgent Help Needed Regarding my massive (over two gigabyte) file with photos in it: I get that the photos are the problem, and that my .mdb is over 2 gigabytes, which... Alec Smith	07-25-2003 01:04 AM Russell Doig	6	48
Linked table with a secured database Hi there, I'd quite like to use a linked table in my database. Because the table I want to link to is in a secured database I can't link to it.... Alex Laming	07-25-2003 12:58 AM Russell Doig	1	49
Can't get queired items to display AfterUpdate is run I've gotten closer to the answer, but not all the way yet. I have two tables, tbl_District and tbl_County. tbl_District contains dist_ID and... John Paul	07-25-2003 12:42 AM John Paul	0	38
Suppress Promps in Insert Sql Hi, How do I surpress the prompt "Append x Rows?" when running a sql insert statement in code? Thanks Rich Richard Albrecht	07-25-2003 12:35 AM Wayne Gillespie	1	51
How can I get unique values from a combo list I have a table, tblDepartment, which has the following columns: DeptID(Auto#) CollegeName DeptName 1 Science CS 2 ... Lionel	07-25-2003 12:23 AM Lionel	0	50
Code needed to change background colour of field would someone please tell me the code and event needed to change the background colour of a field called "dblDate" to yellow if dblDate =... wolftor	07-25-2003 12:17 AM Peter Russell	3	38
Wanted Routine For Fuzzy Currency Search Can anyone please help. I am in search of a routine for an Access 2000 database that can take a recordset of currency values and find any... Mark	07-24-2003 11:37 PM Mark	0	37
Unable to return exact format in query grid I'm wondering if anyone can help me with this problem. I've spent hours now trying to get the results I want – but to no avail. I am using a... Michael Bazinet	07-24-2003 11:32 PM Tom van Stiphout	1	41
List box in a multi-user mdb I have an A2K mdb with 2-4 users daily. Currently there's a multi-select list box in the mdb but I've been asked to modify it something like the... Ellen Manning	07-24-2003 11:17 PM XMVP	2	61
Operation must use an updateable query. Hi: Using Win2K / ASP. Trying to do a simply insert statement. I get the following error: "Operation must use an updateable query" Any... cam	07-24-2003 10:27 PM cam	0	40
MS Access consistency problems Hi Folks, It appears I can write MS VBA programs that execute well on one machine, but not on another! Specifically, the Visual Basic... Dale Mahan	07-24-2003 10:11 PM Larry Linson	1	51
Line continuation problem in VBA I have the following piece of code (the real code is in fact a lot longer) which I wish to split up onto multiple lines. However, I can only get it... Trevor Williams	07-24-2003 09:46 PM Alex Jamrozek	3	53
Re: Hiding / Disabling the "Start Up" option under tools using Access XP "RWC" <hemmingway (AT) shaw (DOT) ca> wrote You say you are distributing with the Runtime. In Access 97 the Runtime environment didn't allow you... Rick Brandt	07-24-2003 09:45 PM RWC	1	44
function or query syntax for comparing a date with previous date ranges? tom: thanks for your reply. i will try this. seems that it might work. thanks! p "Tom Wickerath" <AOS168RemoveThisSpamBlock (AT) comcast (DOT) net>... pasaga	07-24-2003 09:14 PM pasaga	1	45
Disabling Database Window Hi there. I have benign trying to disable the database window by unselecting the option in the startup menu but when I restart it still come up. I... John	07-24-2003 09:07 PM John	0	51
Top anyone? I've got a table which looks like this: Date, Time, Venue, Value Multiple entries for each Date/Venue combination. I want a query which will... Mark	07-24-2003 08:53 PM John Hawkins	1	82
Is it possible for access to give sums Say I have a database of employees used to track time by work order. If employees fill this out daily and fill in time spent on each work order, is... Dana	07-24-2003 08:21 PM Betsy	1	49
Windows Installer keeps coming up in Access 2002 Everytime i try to use the database wizard in access 2002, the windows installer comes up. it doesnt prompt me for the cd or anything though. It just... Sajid	07-24-2003 07:58 PM Sajid	0	43
Re: Tab Control David, There are several ways to do this but let's start with something simple. If your frm_Overpayments is always opened by the first form and the... Rick Collard	07-24-2003 07:03 PM Rick Collard	3	71
Count of various data in a single field. Hello My database is for managing the attendance details of various employees.It has the "Date","Name" and "Status" Field."Status" field has records... Probal M	07-24-2003 06:48 PM Probal M	0	45
Re: Updating links to external files The following code is from MS Access 97 Developers Handbook by O'Brien, Pogge, & White. Very well worth buying --- if you can still find it! Sub... Walt	07-24-2003 06:34 PM Marcus G.	1	46
Error message while trying to Paste from Excel I believe you don't have to save the Excel file to .txt or .csv first. Providing the Column Headers in the Excel file match the field names in... Linda	07-24-2003 06:32 PM Greg Homyer	1	43
Re: ComboBox Thread "Oren Kaplan" <kplnoren (AT) hotmail (DOT) com> wrote In Access VBA, comboboxes have an indexed Column property which you can use to get at a... Joe \Nuke Me Xemu\ Foster	07-24-2003 05:31 PM Joe \Nuke Me Xemu\ Foster	0	47
multiple pages of 1st report page prints In Access '97 I have created a report page that has various labels set up and blanks for information to be written in. In addition, there are... Carroll Iorg	07-24-2003 05:08 PM Arno R	1	48
Re: Increment Number in field when New record is selected - code doesn't work in A2K Hi Wayne & Patrick, Once again, thank you for your assistance! And for your patience with my lack of knowledge. Here is the new code... Private... Loribeth Pellegrini	07-24-2003 04:30 PM Patrick Finucane	2	42
what does the me. and me! portray in form controls I'm really new at Access and was wondering what these mean. Thanks. Eric Lohr	07-24-2003 04:17 PM Bob Quintal	1	48
check/uncheck all of bound checkbox in detail section of form hi!!!! there are two doubts first problem have a bound checkbox in the detail section of the continuous form. have created a command button in the... bala	07-24-2003 04:14 PM bala	0	46
Periodic slow reports 5 seconds to 20 minutes back to 5 seconds in 2002 I have a somewhat complex crosstab report that varies from 5 seconds to 20 minutes to run. I suspect network issues, but I would love... Bernie	07-24-2003 03:56 PM Bernie	0	36
Parameter query form from Public Folders I am currently displaying a number of Management Information Reports in an html format in the Public Folders section of Outlook as homepages. However... Stephen	07-24-2003 02:50 PM Stephen	2	38
change control property based on value causes screen flicker I am trying to change the bordercolor of listbox controls to show a different color based on the control value. The basic scrip is shown below. This... Nancy Moon	07-24-2003 02:46 PM Nancy Moon	0	42
importing Data from a Word file Crossposted for lack of knowing which group is best. I'll read followups in all groups. Sorry for the repost to mpae - I'm looking for some... Jayjay	07-24-2003 02:36 PM PC Datasheet	1	41
running a module function You're right. I always tend to bracket the arguments (ie. use parenthesis), although I see that I failed to include those in my post. So, if... John Hunter	07-24-2003 02:02 PM Tom Wickerath	3	50
Report parameters based on crosstab query I have a database used for customer surveys that asks 4 questions; Courtesy, Efficiency, Knowledge, Overall Satisfaction. Each question has 4 posible... Scott Sabo	07-24-2003 01:55 PM Scott Sabo	0	46
Converting 97 to XP Requerys in design view I am converting a 97 front-end to 2002. I am getting what I suspect are corruptions caused by the conversion process. Most things seem OK, but... James Griffiths	07-24-2003 01:37 PM James Griffiths	0	41
Checkbox in Report - Change Property at Run Time I have a checkbox (chk1) that I am trying to change the visible property of depending on the value in a nearby textbox. These controls are both in... Bruce B	07-24-2003 01:07 PM Bruce B	0	41
Re: Tab Controls and sub forms Tony. Are you sure it is the position of the subform itsself that changes? Maybe the controls on the subform change position because the subform... Arno R	07-24-2003 01:01 PM Arno R	1	54
Retreiving RecordSource of a Report object without opening it Hello, Is there any way to retreive the RecordSource property of a report object without opening the report first. I tried to access the AllReports... Lars Reimer Jensen	07-24-2003 01:01 PM Lars Reimer Jensen	2	45
Rounding Again Why not use your own rounding function if the access ones don't work for you? It's not my work, I've used this one over the years but cannot... rdf	07-24-2003 01:01 PM Stuart Gilliland	2	87
Re: Year Field - Best Option - Date/Time or Text Thanks: I'll use the "unbound field" option; seems it may prove the simplest. Have a good weekend! Cheers, Dave "Tom van Stiphout" <tom7744 (AT)... Tom van Stiphout	07-24-2003 11:57 AM David Brydon	4	67
Simple circular relationship question This is probably DB 101, but I checked the FAQs and didn't find an answer: I have a table for Companies and another table for People with a foreign... Jeff Wilson	07-24-2003 09:57 AM Fletcher Arnold	2	50
Password problem Hi Don!, Here's a little code to help you automate your reply system... :) ****************************************************** Private Sub... Stuart Duncan	07-24-2003 08:25 AM R.Soul	7	53
Copy a single record in a form to a table using command button ( 1 2 3 ) On 22 Jul 2003 02:25:10 GMT, Lyle Fairfield <lylefair (AT) yahoo (DOT) com> wrote in comp.databases.ms-access: ....with precision and scale being... W Crawford	07-24-2003 08:03 AM David W. Fenton	24	129

Page 799 of 820

799

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off