Sponsored Links

comp.databases.ms-access comp.databases.ms-access

Page 45 of 820

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Allen Brown's - FindAsUType - strange issues Hi all, I am using Allen Browns FindAsUType function which, for some time now, as been extremely useful and is just brilliant!! Yes, it is now a... DeZZar	09-10-2009 06:27 AM DeZZar	1	133
Draw A Line Across Both Columns I am using the report line method to draw lines in the detail section of a report. The detail section contains a subreport that is a two column... Steve	09-10-2009 02:52 AM Keith Wilby	3	64
DLOOKUP in a report I have a text box in the report header section. I want to to do a dlookup function. The function is not returning any value to the text box. Here is... Utah_Jackson	09-09-2009 03:33 PM MGFoster	1	69
access2003 - why doesn't refreshLink store the user/pwd using access2003 & sql2005 if I do this strNewConnect = "ODBC;Driver={SQL Native Client};Server=myserver;"... Roger	09-09-2009 12:13 PM Roger	4	50
buttons and controls don't work!! - Access 2007 After I copied my Access application onto another computer none of the controls or buttons work. The same application works on my computer. I think... jkingBoise	09-09-2009 10:19 AM Steve	7	69
pulling apart, padding out and re-assembling a pasted alphanumerictext string.... Hi all, (sorry for long post, but I need to explain a little) I've got another one today that I KNOW what I need to do and somewhat how to go about... DeZZar	09-08-2009 09:47 PM DeZZar	6	65
Shrinking form after report preview ( 1 2 ) Using A2003. I have a form with a button that previews a report. When the preview is closed, the form shrinks. How do I prevent this? Thanks for any... emanning	09-08-2009 10:49 AM Krzysztof Naworyta	12	91
Text box using DLookup is not updating unless I click on it. I have a form bound to a query. It loads fine. On that form there is a text box which does a DLookup to sum and get a total from another query. It... troy23	09-07-2009 01:02 PM troy23	3	63
What's a good way to create charts or graphs in A2000 I have some monthly inventory data that I need to create a line chart for. Karl	09-07-2009 11:08 AM Karl	2	63
Output Query to .txt file 255 character limit Hello, I am trying to output some data from a query to a .txt file. One of the query fields contains more than 255 characters. Any characters over... Albert	09-06-2009 08:38 PM James A. Fortune	3	71
Issues exporting to Fixed Width Text I have an Access 2000 query I am trying to export to fixed width text file to upload to another server via a web application. When I create the... Brian	09-05-2009 10:20 PM Jeff Norville	4	115
Can not see Fields When I go and create a combo box for two fields, I can not see them in the store that value in this field. I see the other fields that I have. I know... Dale	09-05-2009 03:09 PM Salad	2	85
OT. Texas is too good for us. 2010 gubernatorial candidates Debra Medina and Larry Kilgore spoke at a rally in Texas and their theme is "secede from the US!". As Kilgore says... Salad	09-04-2009 04:36 PM Tony Toews [MVP]	6	66
Implicit sets versus explicit sets ( 1 2 ) I start this new post because there is a lot of confusion in the previous one: "too many databases open". Phil started that post, because of his... hbinc	09-04-2009 05:58 AM hbinc	18	118
Records from a Form to a Report I've created a form based on a parameter query that allows a comma separated list of values for searching the records. I have all of the records... Ryan Diver	09-04-2009 12:09 AM Larry Linson	3	67
Relationships with Multiple Backends ( 1 2 ) "Larry Linson" <bouncer (AT) localhost (DOT) not> wrote in news:PQEnm.930$tl3.581 (AT) nwrddc01 (DOT) gnilink.net: I don't believe that you are,... elias	09-03-2009 06:21 PM David W. Fenton	10	114
Syntax Error on calc field What is wrong with this statement: IIf(=0,Null,((-)/)) I get a syntax error when this calculated field is executed. Thanks Ryker	09-03-2009 06:13 PM DeZZar	3	61
Add a record OR Edit a record on a data entry sub-form How can I add a record or edit a record on a data entry sub-form? zufie	09-03-2009 03:03 PM Salad	1	67
Query to pull patients never in accdb before certain date? Using A2003. I've been asked to produce a list of patients who were first entered in the accdb during a certain date range. For example, if the... emanning	09-02-2009 08:37 PM DeZZar	6	62
getting access to display logged on users Hi All, I have taken this Microsoft code that creates a list of current users and attempted to get it to fill out a List box. However, it only... DeZZar	09-02-2009 08:04 PM DeZZar	9	95
Help: sorting within GROUP BY I'm having difficulty reducing a dataset in Access using what I thought were standard SQL grouping and sorting technique. Someone set me straight,... Jeff	09-02-2009 06:32 PM Bob Quintal	2	46
clsPictureBox I have been using Steven Leban's clsPictureBox module for several years. Recently to refresh my database (due to linked table issues) I created a new... Lou O	09-02-2009 03:13 PM Lou O	0	65
FindFirst of a date Hello, I am in need of advice with the findfirst method again. this time i need to position a recordset with a date. my code: '---sales prior... bipin	09-02-2009 03:08 PM bipin	2	69
Font Installation Error When Switching Versions I switch between 2003 and 2007 several times a day. Recently, I have been getting an "Error 1907 Could not register font" each time I... John von Colditz	09-02-2009 08:58 AM John von Colditz	2	46
Tracking Changes in an Unbound form I've got an Access database on my file server that uses unbound forms and writes changes to the tables using DAO vba functions. I'm wanting to track... rsimonrules	09-02-2009 08:34 AM bsn	1	58
too many databases open ( 1 2 ) I had partially developed a Db in AK2 and abandoned it because if I opened more than 1 form at a time I got an error 'too many databases open'. The... Phil Stanton	09-02-2009 12:56 AM lyle fairfield	19	80
Reports are only totaling the fields for the first record ( 1 2 ) I found that the my reports are only totaling the fields for the first record so I must modify or create another query to resolve this. How do I fix... zufie	09-01-2009 05:39 PM Bob Quintal	10	101
Query Question I'm trying to add the values from a field in two different queries. Is there an easy way to do this? I was thinking of a union query but I don't... Ecohouse	09-01-2009 03:33 PM Steve	3	62
Reports Page Setup I have one client using one of my Access 2002 applications in an Access 2003 environment. One of the reports uses a specific printer (for printing... dpcman01	09-01-2009 03:03 AM dpcman01	2	58
manual update a field to table Hi, I want to manually update a field in the AfterUpdate method to its table before the form is closed. Is there a way to do this. For example, I... Dewey	08-31-2009 08:48 PM Dewey	3	49
Problems with report values coming from stored procedure Hi all, I wonder if someone can help? I have a report in an ADP that is fed by a stored procedure that is producing incorrect values. When I... DeanL	08-31-2009 02:00 PM DeanL	0	50
Count Rows On Last Page ( 1 2 ) The detail section of the report I am working on consists of a subreport. The subreport has a single row record and an internal subreport below... Steve	08-31-2009 07:40 AM Keith Wilby	10	141
COM$B$N2P$+$-K@$N@1(B, $B3JF.%%s%i%$%s%2(B$B!<%`(B, $B%F%-%5%9$N(BPC$B%2!<%`$N%[!<%k%G%`(B, $B%]!<(B$B%+!<%9%?!<%:$N(BCOM, $B%]!<%+!<$r:#$9$0(B, $B%]!<(B$B%+!<%F%-%5%9$rJ];}$9$k(B, COM$B$N2P$+$-K@$N@1(B, $B3JF.%%s%i%$%s%2!<%`(B, $B%F%-%5%9$N(BPC$B%2!<%`$N%!<%+!<%9%?!<%:$N(BCOM, $B%]!<%+!<$r:#$9$0(B,... super mario	08-31-2009 07:03 AM super mario	0	67
Linked Table Manager For development and testing of my DB, I link to tables in a local back end DB. To go live I re-link to tables in a back end DB on the LAN using... Lou O	08-28-2009 08:17 PM Lou O	6	60
$B>/$76bM;(B, $B%"%a%j%+$NL5NA%]!<%+!<%2(B$B!<%`(B, 2$B?WB.$J$6b$r2T$0(B, $B%$%s%?!<%M%C%H6b(B$BM;(B, $B%U%j!<(B $B%M%C%H%2!<%`(B, $BL5NA%2!<%`(B, $B>/$76bM;(B, $B%"%a%j%+$NL5NA%]!<%+!<%2!<%`(B, 2$B?WB.$J$6b$r2T$0(B, $B%$%s%?!<%M%C%H6bM;(B, $B%U%j!<(B $B%M%C%H%2!<%`(B,... herbert gruen	08-28-2009 05:09 PM herbert gruen	0	45
dividing by 0 I have a report that calculates a percent of change from one year to the next. The calculated field is =( - / ) Since this is a prebudget report,... Ryker	08-28-2009 04:23 PM paii, Ron	5	47
Access 2007 Import Custom Navigation Options into new database Hi I am trying to import all the database objects into an Access 2007 accdb. I am able to do this without anty problem. However, I would like to be... jeff001@stortvalley.com	08-27-2009 10:44 PM Sky	1	40
Print a list of tables in MS Access 2007 Help! How do I print a list of tables in MS Access 2007. First, I selected Tables-->View By "List", but when I tried to Print, but one table always... zufie	08-27-2009 02:45 PM Albert D. Kallal	2	57
Print List of tables in MS Access 2007 Help! How do I print a list of tables in MS Access 2007. First, I selected Tables-->View By "List", but when I tried to Print, but one table always... zufie	08-27-2009 11:57 AM zufie	0	42
query to determine Start Date and End Date for consecutive dates. ( 1 2 ) I have a database that has various heavy equipment (machines) sheduled. Each piece of equipment is scheduled for a specific location and each day... RCGUA	08-27-2009 08:08 AM Krzysztof Naworyta	14	48
Error -- There is no Object in this Control Our company has several Access programmers that work on a common project. When one of the programmers is performing an update, he will work on the... Vincent	08-27-2009 07:24 AM paii, Ron	2	44
LinkMasterField problem I have a main form with 2 continuous subforms. The first Subform 'SubWaitingList' shows members and the sort of storage areas they are waiting to... Phil Stanton	08-26-2009 09:42 AM Phil Stanton	2	44
Can Subreport Be Made Transparent Is there any way to make a subreport transparent so that lines drawn across the entire width of the main report can be seen through the... Steve	08-26-2009 03:28 AM Keith Wilby	2	53
Print Multiple Copies Without Collation I would like to print two reports a once. The first report is a sign sheet; the second is an order form. The sign sheet contains the same information... ccman	08-25-2009 09:44 PM ccman	0	23
Help with: Concatenate values from related records I am trying to work a concatenate function into a query that I have already created. The function can be found... Jim Doerflinger	08-25-2009 08:03 PM Steve	4	23
how to properly prevent 3021 error. No current record. (Error 3021) This error occurs after the unsuccessful application of one of the Find methods or the Seek method, when the... bipin	08-25-2009 02:28 PM Steve	3	41
can access accomodate an 'after keystroke' type event? Hi All, I am attempting to run an event after each key stroke within a text box. The end result would be a text box that a user enters a... DeZZar	08-24-2009 09:36 PM DeZZar	8	40
Output multiple filters to single report format I know that there has to be an easier way to set this up than to create an individual query for each timekeeper, but my trial and error has had... Rosy	08-24-2009 06:14 PM MGFoster	3	49
very new (basic question) & bloomberg hello, please humor my lack of knowledge as I am very new to access. basically: i want to build a database that appends data to the end of certain... jason	08-24-2009 04:21 PM Rich P	3	36
Cannot add or edit to form, nor select from combo box on form I cannot add or edit to my form, nor select from the combo boxes on my form. Here is the code behind my command button that brings up my form via... zufie	08-21-2009 04:21 PM Larry Linson	2	44

Page 45 of 820

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