Rating Thread / Thread Starter	Last Post	Replies	Views
tools->option->view->uncheck in taskbar is coding using vba i want to uncheck windows in taskbar using vba. * Sent via Developersdex http://www.developersdex.com * x taol	01-07-2007 09:11 PM pietlinden@hotmail.com	4	36
Re: Detecting new record What exactly are trying to do in the AfterUpdate event? I think the problem is that AfterUpdate means AfterUpdate! The record is no longer "new"... missinglinq via AccessMonster.com	01-07-2007 08:14 PM missinglinq via AccessMonster.com	0	35
Running queries on new record and record modification Hi I need to run a query when a new record is inserted and another one when a record is modified. What events do I need to trap? Thanks Regards John	01-07-2007 04:36 PM Van T. Dinh	1	35
convert given date to first day of the given month I have dates of service for several people that range all over each month. ie: patient had dates of service of: 7/3/2006, 7/24/2006 and 7/25/2006. ... perryclisbee via AccessMonster.com	01-07-2007 01:12 AM '69 Camaro	4	37
Distribution and installation of an application Hi. I have some questions regarding the distribution and installation of an application. My current application is written in A97. I figure its... salad	01-06-2007 03:26 PM Rick Brandt	2	29
Update Based on Form Control Value I have a form that users use to input the fiscal year for an update query. I have that value (after input sitting in a public variable and a... Kc-Mass	01-06-2007 01:57 PM Kc-Mass	2	28
Re: DateDiff in a query rickmcq (AT) TAKEOUT (DOT) earthlink.net wrote: Another thing to be aware of is that at table design level you can decide whether a zero length... Rick Brandt	01-06-2007 12:19 PM Rick Brandt	2	31
Reusable report with a modifiable rowsource property and or code ? How do I call a reusable report with a modifiable Rowsource property and or code ? Like in the following case where the table name will change... u473	01-06-2007 11:00 AM Marshall Barton	3	33
Looking for Heirarchy code? Folks -- First - as this may be a FAQ question, I apologize for being off topic and needlessly recycling a question. I have not found an... Dan	01-05-2007 08:52 PM Tom van Stiphout	1	37
running a "variable" function ? Hi May i know is it possible to run a function when we pass in the function name as parameter ? eg retval = functionA(A) but i would like to have... chuaby@hotmail.com	01-05-2007 06:29 PM Larry Linson	4	38
IP Address Management using Access To Whom It May Concern: I too am trying to create a database using MS Access and need some help in getting started. I would like to create the... centexas66@gmail.com	01-05-2007 06:00 PM Chuck Grimsby	1	33
Access 2003 Can't edit VBA code Hi all, I'm trying to edit VBA code in my mdb file for a form. Basically, I want to delete and comment out some lines of code. (I'm quite good... jjbnfo@gmail.com	01-05-2007 05:44 PM Larry Linson	2	41
Simple Database Required I have been asked to build a simple database of customer records. Below are the fields required. My problem always seems to be deciding how many... Saxman	01-05-2007 05:07 PM chris.nebinger@gmail.com	3	34
Using Variable in DoCmd Export Statement I'm sure this has been answered, and I've looked but can't quite find what I'm looking for. I have Path = "I:/voucher.txt" DoCmd.TransferText... veaux@aol.com	01-05-2007 04:57 PM chris.nebinger@gmail.com	1	40
Record Search through Combo Box problem Hi, I have a table of around 1000 rows; patient records. Each row is individually defined by a Patient ID number which is my primary key. I have... mf193	01-05-2007 02:51 PM Jana	3	27
Using "MM" Date Format in Query When Data is "M" format I'm thinking this is easy but can't get it. I have a table with following: Table1 Date 1/1/2007 Table2 Type 0107 (This is MMYY of above) So I'm... veaux@aol.com	01-05-2007 02:42 PM Rick Brandt	5	35
Getting data out of Access 95(!) Hello all We have an Access 95 database which holds a lot of our customer data. We are running the database in Access 2007 and in the main it's... plasyncoed@yahoo.com	01-05-2007 02:09 PM plasyncoed@yahoo.com	6	38
Adding TIme to date while creating Backup in CompactDatabase Method I have been reading the posts regarding the CompactDatabase method and would like to say Thanks to everyone, especially Mr.Steele. I have taken his... pburling@nyc.rr.com	01-05-2007 01:48 PM Ron2006	3	37
Naming fields in a make table query Is there a way to specify different field names in a temporary table created using VBA? I just inherited a program and now the users want to export... Zammy	01-05-2007 12:05 PM Bob Quintal	3	33
Create a warning. Hey all, Is there a way to pop up a warning when someone goes to change a field? I would only like this to occur when the field is NOT... radink	01-05-2007 11:51 AM Jana	9	37
Event as form is loading Is there an event that triggers as a form is loading? I want to display a "loading form" event as the form is loading since it tends to take 20... BerkshireGuy	01-05-2007 11:08 AM deluxeinformation@gmail.com	4	42
pictures in tables? Hello, This is the first time I use a database program. I am trying to build a product database. Each product will have an ID number, a... Talal Itani	01-05-2007 10:57 AM John Vinson	9	60
Question About Column Charts I have a column chart with two series: 1) Number Of Applications 2) Number of Completed Applications. These are in a column format, so it looks... BerkshireGuy	01-05-2007 10:43 AM BerkshireGuy	2	38
modify data (insert one character to beginning of data string) I have a large database (for me) containing about 23,000 records and I need to add a single digit (the number 8) to all data currently in a specific... libadmin	01-05-2007 10:30 AM Ron2006	4	33
access 97, insert from sql server slow ( 1 2 3 ) I've got an access97 reporting mdb that pulls data (77,000 rows) from a sql server table into a local table to run reports if the local table is... lesperancer@natpro.com	01-05-2007 10:06 AM lesperancer@natpro.com	21	105
Machine Data Source When I am linking tables from an Oracle database to an Access database (ODBC Data Sources) which Oracle driver must I choose? I was informed to use... jmarr02s	01-05-2007 09:15 AM Tim Marshall	1	42
Pivot tables and no totals Hi I have a simple requirement to turn a query results into a pivot table The query results are: EID Name Service 1 ... Yitzak	01-05-2007 08:40 AM Yitzak	1	37
maintain hidden column permanently i want to maintain a hidden column in datasheet. Anybody can show the hidden column how drag column heading with mouse. i want to prohibit the... x taol	01-05-2007 07:52 AM Ron2006	2	32
Ms Access 2003 Project (.adp) database connection Hi everybody, I wanted to start an application using the MS Access 2003 Project, but as I create an .adp file it asks me to connect to a SQL Server.... gabry.morelli@libero.it	01-05-2007 04:04 AM gabry.morelli@libero.it	3	35
Invalid Field Data Type I've a database in VFP 6.0 which I converted to Excel format and then to MS Access 2003 format. Now its not accessible through ASP. If I convert this... sunilbassi@gmail.com	01-05-2007 03:32 AM sunilbassi@gmail.com	0	38
Transfer tables between secured external DBs using TransferDatabase I'm trying to use TransferDatabase to transfer tables from an external secured DB to a database created in the code. I would like to kind of use... rdemyan	01-05-2007 02:18 AM rdemyan	0	35
Tick Box as Date Field I have tickbox on a form, and I would like to use a date field as the control source. i.e. I would like to have it display as ticked when a date... andrewbda	01-04-2007 10:40 PM Tom van Stiphout	4	39
Array to "IN" operator Hi all-- Quick question: has anyone come up with an easy way to take an array and use its elements as part of a WHERE clause? For example: <This... Kevin Chambers	01-04-2007 10:40 PM Marshall Barton	3	40
Macro Conversion When I let Access 97 or Access 2002 convert macros to visual basic code with the built in utility in each (they do work somewhat differently in... Steve Cartnal	01-04-2007 09:16 PM Steve Cartnal	0	39
Design Dilemma - ContinuousForms and Buttons. ( 1 2 ) In my database, I uniformly handle records on a Record by Record basis, in a single form that contains New/Edit/Del buttons. Because I'm dealing... ApexData@gmail.com	01-04-2007 08:44 PM ApexData@gmail.com	13	62
help with form update Hi All, Okay, I've got a frmOrders with a subform of sfrmDetails. A frmClient has all the client info, plus a subform of sfrmDefaults that has the... Ron	01-04-2007 07:05 PM Ron	2	36
saving a report Hi All, In AccessXP I have a multi-user application sitting on a server and in that application I have a process(module,forms) that allows a user... bobh	01-04-2007 02:15 PM ManningFan	1	36
how to share foxfro application on other computer i have an application developed in foxpro, i have two Pc's now i want to use this software from my second pc plz tell me how to share it. by simple... faqi	01-04-2007 01:31 PM Cyberwolf	1	31
Testing Data after save on continuous form Hi, I have a continuous form with 'x' amount of records. 1 field on each record is a number, of which I have a field at the top of the form which... David	01-04-2007 12:44 PM deluxeinformation@gmail.com	1	33
Limit number of records able to be entered I have two tables, one with categories in it, and only 3 records - Wages, Salary, Contract. I have a second table that records hours and numbers of... OM	01-04-2007 04:24 AM OM	2	37
Integrating WordMerge module in MS Access Dear list, I have an existing MsAccess database application. And integrated a nice module for WordMerge into this. -> Works fine. Now I want to... Aristo WebDesign	01-04-2007 02:32 AM Aristo WebDesign	3	31
Simple search? Is there a way to code the following? I have frmIntake which is linked to tblIntake. I want a search button on the form to search the table for... Ryker	01-03-2007 08:40 PM Tom van Stiphout	2	41
Scan PDF file and input certain fields in database My company is seeking a software solution for the following scenario. Please let me know if you have any suggestions. We are a small consulting... Harry.PharmTouch@gmail.com	01-03-2007 05:12 PM Phil Stanton	1	37
Report Detail Section & Keep Together Property Access 2003. A report of mine was hanging on print preview. It turned out the issue was a bound text box where the data was too big to fit all on... Tim Marshall	01-03-2007 04:45 PM Tim Marshall	0	31
Help with normalisation of table Hello All, This has been bugging me for too long. I have a database that records medical interventions. I am familiar with the theory... Macbane	01-03-2007 04:08 PM CDMAPoster@FortuneJames.com	3	36
free screensavers and wallpapers Download Free ScreenSavers and Wallpapers! - http://surl.in/HLSCR238206SVRAKSX ameresh	01-03-2007 03:36 PM Larry Linson	1	36
How to list records in correspondence table Where [OutDate] Is Null AND [OutType]='06' ? But now here's the catch - I want to see information from an earlier record in the table. Suppose the correspondence table had these five... MLH	01-03-2007 02:14 PM deluxeinformation@gmail.com	7	42
couple of 2003 questions on code I was converting this from 97 to 2003 and ran into a problem in the code. The problem is fld.name name highlighted and says method or member not... sparks	01-03-2007 01:49 PM sparks	3	35
Making a "Find" button Hey all, I would like to make a command button on a form that lets you enter a users name, and then if finds and displays only the records from... radink	01-03-2007 10:49 AM Rick Brandt	5	42
Fields padded by spaces I am having a problem where fields are being filled by spaces when data is put in. I.e. in a text field length 50, whatever is stored in there is... andrewbda	01-03-2007 10:11 AM Allen Browne	1	73

Page 203 of 820

203

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