Rating Thread / Thread Starter	Last Post	Replies	Views
Newbie: Date range query by quarter Hi, I'm trying to do query that will return all rows within the last quarter of any year. I've tried: "Between #10/1/????# And #12/31/????#" and I... Mark	12-01-2004 06:32 PM Mark	3	46
Form cross-field edits On a form I developed, I want to do some cross-field dependencies. If field1 = "xxx" then field2 must be "yyyy" and so forth. Apparently I cannot... Bob Alston	12-01-2004 06:23 PM Bob Alston	1	58
Report stretching/reducing Hello to all. Ever had a problem when your print some reports in a printer other the one you use more frequently, in which the report width span... Filipe Martins	12-01-2004 06:05 PM Filipe Martins	0	65
Looking for a full page calendar control or API needed There are many techniques and code snippets that will open a popup calendar so that you can pick and insert a date into Access. However, I have been... Tony Ciconte	12-01-2004 05:43 PM Tony Ciconte	2	34
List Box Multiple Selections Generating Reports Trying to create multiple acct reports based on the selection in a list box. I've set the list box for multiple selections, and in the report data... jeffgeorge	12-01-2004 05:33 PM Scott Simonson	1	62
Using "Hyperlink" OR "OLE Object" Datatypes in VB/VBA I have hundreds if not thousands of documents in various formats that I have been asked to organize in such a way as to make it easy for the people... ajames54@hotmail.com	12-01-2004 03:05 PM ajames54@hotmail.com	2	62
Report object "visable or not visable. That is the question" Hello experts! I hope to tap your vast knowledge of unbound wisdom. Please help this humble squire in his search for knowledge. Product: MS Access... Michael	12-01-2004 02:08 PM Michael	3	36
Current/System date in Access ( 1 2 ) Hi All, I'm making library db using SQL. I have date when book has been loaned (Date loaned) and date to return the book (Return date), which is 4... Miikka Hamalainen	12-01-2004 01:50 PM Billie Kennedy Jr	11	72
Which page am I on? Hello, I have a form with two pages - that is, the height of the form is about two screen heights and it has a PageBreak half way down. I move... Adrian	12-01-2004 01:47 PM Bas Cost Budde	8	88
Consolidating rows in a DB? I have a printer log that I need to manipulate. Each row contains document name and total # of pages in the document. Document names contain... mmmGrubb	12-01-2004 01:46 PM Bas Cost Budde	2	58
3146 ODBC - call failed......an urgent task for my boss ARGH! Hi, I'm a relatively new VBA programmer but have been given the task of repairing a database that currently appears with "3146 ODBC--call failed."... Doolittle	12-01-2004 01:38 PM Salad	1	110
Qurey question Hi there I'm a complete beginner with access so please be gentle! I need to write a qurey to calculate the daily interest earn on a... KinRsole	12-01-2004 01:24 PM KinRsole	1	87
help wanted hello How can I update more than one tables on the same form? The relationship is one to many from a master table to 3 other related tables. on the... newbie	12-01-2004 12:58 PM newbie	8	106
Updating a related table Hi all, Im using the after update event of a field from a bound form to add records using the recordset object, to a related table. However i'm... Gerry Abbott	12-01-2004 12:42 PM Gerry Abbott	3	71
Randomize fields Hi All, I have an Access DB of Questions, Answers, and Distractors. The field names are as follows: Question, Choice1, Choice2, Choice3,... Rob South	12-01-2004 12:10 PM Rob South	3	50
.ldb file size Just a short question.. should all access .ldb record lock files always be 1kb in size. i have noticed on my app that at times the .ldb files can... Lee-Anne Waters via AccessMonster.com	12-01-2004 12:05 PM Bri	3	60
ASP ContentType Hello all! I have the following problem. I have both text content and image content of the web page created in ASP language. How to do combine these... Kamyk	12-01-2004 11:49 AM Kamyk	2	63
Professional Data Recovery Book (World's First Book on Professional Data Recovery Programming) Hi! I am glad to introduce World's First Book on Professional Data Recovery Programming. Book also Includes a FREE CD, which contains complete... Author Tarun Tyagi	12-01-2004 11:44 AM Author Tarun Tyagi	0	61
Error message on combobox I have a dropdown box called cmbCompany2 which is based on a table tblCompany on a form frmMain which is based on a table tblMain. The data selected... Tony Williams	12-01-2004 11:36 AM Keith	1	67
Message box Code I have a message box which pops up a message after a check on a total. The code on the Before Update Event is: If ( + ) <> Then MsgBox "Row 1 does... Tony Williams	12-01-2004 11:31 AM Tony Williams	8	66
Creating new record with default values Hi, I'm trying to use a (simple) form to create a new record, with all values being default values coming from a previous form. My problem is that I... jerome g	12-01-2004 10:41 AM Ed Robichaud	2	68
lookup problem I am having a problem with how to get a lookup to work how i want. What i want is the user to be able to use the lookup on a form to select the... Splashout	12-01-2004 10:36 AM Ed Robichaud	1	75
Redefine field data type Hi, I am trying to write a function in a module in MS Access 2000 that will change the data type of a field called 'Start' in... Josh	12-01-2004 09:16 AM Brendan Reynolds	4	45
Formatting subreport "report" headings I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user... Ellen Manning	12-01-2004 09:02 AM Ellen Manning	7	58
Access ducumentation program Back when I worked with Access 97 I used a developer's tool kit that documented my programs and did analysis of my databases, queries, forms and... mar10a	12-01-2004 07:51 AM Alan Webb	3	46
Callback function to populate listbox with filelist I have a callback function that populates a listbox with a list of file names in a folder. This code came from Terry Kreft/Dev Ashish some years... Grant Hammond	12-01-2004 03:18 AM Trevor Best	1	61
Neat database diagrammatic documentation scheme Recently, I've been working on an Access application that is supposed to be the prototype for a larger system that will be developed by a team... Steve Jorgensen	12-01-2004 03:10 AM Trevor Best	8	37
How to admin a remote hosted Access db Pardon me, as I am an Access newbie. How do I admin a hosted Access db? Is there something like Enterprise Manager or phpmyadmin that I can use for... steve	12-01-2004 01:50 AM steve	2	58
Images As External Files Hi, Does anyone know how to display external files (i.e. jpg files) in reports? I have stored the file location in a table and am looking for a... Kevin	12-01-2004 12:20 AM Larry Linson	6	58
determine fields of query based on form checkbox Hey, I have built a form that has certain combo and text boxes on it, which a user specifies his criteria and then clicks on a search button to run... Matthew	12-01-2004 12:08 AM Larry Linson	1	40
Calling function with arguments from external VB application I am trying to call a module function in an Access db and then open a report from a VB application. The problem I've found: I can't find a good way... Adam Kramer	12-01-2004 12:05 AM Larry Linson	1	43
sample data base source Hi if someone can send mi a samlpe file *.mdb. But it should be more then 2000 records and it should be easy to do something on it. I've got exercise... adam	11-30-2004 11:59 PM Larry Linson	1	40
Multiple categories Hi all, Please help me here. I need to have a form which will allow me to select a particular type of service through a combo box and based on that... Zurghew	11-30-2004 11:20 PM MGFoster	1	53
Run a Public function from a macro I thought this should be easy, but I can't find a way of doing it. I have a public function in a module that I want to run as the first part of a... dixie	11-30-2004 10:20 PM MacDermott	1	40
How to learn Office Automation with Access? Hi, I use Visual FoxPro all the time to import and export data from and to Excel (creating workbooks in code, etc...). There is an excellent book... pw	11-30-2004 10:18 PM pw	4	62
Database in an unexpected state I just started doing some developer work for this small company. The guy before me built some databases that are used by various departments around... Steve Z	11-30-2004 09:46 PM Steve Z	0	47
Electronic Data Interchange I found only five small threads discussing Access and EDI and none of them were very recent. Is anyone interfacing with EDI using Access? Can anyone... Hank Reed	11-30-2004 09:12 PM david epsom dot com dot au	2	42
ADO Newbie: Querydefs? I know there are no querydef or tabledef objects in ADODB. In the past, I've used DAO to create Oracle pass through queries like the following so... Tim Marshall	11-30-2004 08:44 PM Eric Schittlipz	3	62
Graphics On A Form Or Report Word has the following method: range.InsertSymbol 254, "Wingdings" where 254 Wingdings is a checkbox with a check. Is there something similar in... Susan	11-30-2004 08:18 PM Dave M	1	58
Union queries Hey! Please help me... I'd like to know if there's a limit of tables that I can unite in a union query (maybe 16?). When I add more than 16 tables... Fl?vio	11-30-2004 08:17 PM brett valjalo	1	62
Converting messy Word doc to Access 2000 I have a Word 2000 document where each line is separated by a CR: It goes like this: 2.0 MAIN HEADING 2.1 Sub-Heading Description of sub-heading amywolfie	11-30-2004 07:31 PM amywolfie	0	52
TransferDatabase wont kick-start! Hi guys, Using Access 2003 on XP. First time caller, long time listener. I am not a programmer per se, and all my training in coding in the past... Dave Gehrig	11-30-2004 06:10 PM Dave Gehrig	6	54
DateDiff, Sum & Negative numbers? Group By - Client Sum - Past:IIF(DateDiff("d",,Date())>30,,0) Sum - Current:IIF(DateDiff("d",,Date())<31,,0) Works for positive numbers, but if... Kevin	11-30-2004 05:48 PM Kevin	0	47
sequential numbering in a query I have a table which has employee number. I have attempted to creat a function whic will derive a unique number for each record how ever the code... Anderson	11-30-2004 05:36 PM mar10a	2	47
Report Sum How do you get a sumon a calculated field in a detail section on a report? I have a group footer that I need the sum on. Thanks DS DS	11-30-2004 05:28 PM DS	6	86
Security problem in Access 2000 - Admins user can't change query design I create a new user and make them a member of Admins. I then log on as that user and try to modify an existing query. I'm told that I don't have the... Richard Sherratt	11-30-2004 05:23 PM Richard Sherratt	2	54
testing - plz ignore Having trouble posting to this board.... Bwalker252	11-30-2004 04:52 PM Bwalker252	0	43
Add label when exporting report to PDF I have a table with several fields In the field "ImageName" I enter the name of the image for that record. The images can have multiple pages, so I... Jacky11	11-30-2004 04:02 PM Jacky11	0	43
Access ADP's I am creating an Access client to a SQL db and decided to go with an ADP instead of an MDB. But I'm having some issues. My previous post... Andrew Chanter	11-30-2004 03:49 PM Nicole	4	86
DCount problem Hi, I have a problem with DCount, the following code doesn't work: DCount("", "qryOrder", "( = Me! AND = 'drink')" > 0 Please help. Thank you. Paul T. RONG	11-30-2004 03:39 PM Paul T. RONG	2	64

Page 520 of 816

520

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