Rating Thread / Thread Starter	Last Post	Replies	Views
field contanins column name for query Hi,i'm new to access and not sure whether it's possible to create a query on two tables below to get data from tblB or i should do some trick through... dim1ann@yahoo.com	12-30-2004 03:24 PM Bas Cost Budde	3	40
Unpredictable db size increase during INSERTs - Memos? Hi, I have an Excel 97 app in which I'm using SQL INSERTs to insert data into an Access 97 database table. The table structure is as... deathyam@yahoo.com	12-30-2004 03:20 PM Tony Toews	3	38
Help please! Linking, showing, but not embedding images Hello all. I hope someone can help me here. I need to make a db on many pictures, however, if I OLE them, the access database grows hugely. If I... theo.bruening@gmail.com	12-30-2004 02:42 PM theo.bruening@gmail.com	6	43
Stop importing Is there a way to stop importing tables from an mde database to a newly created database. I wish to protect the data in the mde so that it can... Ian Davies	12-30-2004 02:30 PM Rich P	4	57
A2K or later: Format a time field as 24 hour time format? Is it possible to create a data input mask for a text box bound to a date/time field so that it will display and guide entry of the time values in 24... Lauren Wilson	12-30-2004 12:38 PM jv	1	46
Finding complimentary data sets in MS Access Using Queries Hello all. I'm an access newbie trying to learn how to do basic database data manipulations. I had a hard time searching the archives on this... User 2084	12-30-2004 11:02 AM user2084@hotmail.com	2	39
newbie help I created a table by copying an existing table and then deleting all of the rows from it. For some reason I can't change the column name of a field... Modest Marsupial	12-30-2004 10:02 AM Modest Marsupial	4	54
Query forms Thank you. I have never used Filter by Form, so I'll have to study a little. I have concentrated my efforts on queries, with no results. Now I'll... Luisa Lopes	12-30-2004 08:56 AM Luisa Lopes	4	76
find duplicates wizard Fao Darryl Kerkeslager Hi Daryl. Thanks for you interest. I don't have the SQL, unlesss you mean the SQL behind the query? as to the "re-structuring" The first part of the... Phil	12-30-2004 08:41 AM Darryl Kerkeslager	1	38
Access: using as the backend Before I retired, I was a systems analyst with the State of MI. We used Access as several of our databases. I want to use VB5 to write programs that... mr_wizard	12-30-2004 05:51 AM Douglas J. Steele	3	51
Re: random password You could also check out this cool generating random passwords: http://www.info-pack.com/apassword/ Regards Info-pack.com infopack@gmail.com	12-30-2004 04:49 AM Bas Cost Budde	1	40
a2k - how to split up field contents Hi, It's been a while since I posted but good ol' google groups is confusing me these days and not giving me nice answers. I have this field in a... Pilocarpine	12-30-2004 04:34 AM Deano	4	45
field contanins column name for query Hi,i'm new to access and not sure whether it's possible to create a query on two tables below to get data from tblB or i should do some trick through... dim	12-30-2004 02:21 AM dim	0	43
Change how a Lookup Value is stored One of my tables has a lookup field in it. It looks up a part number but stores it as the part's name (bad idea). How can I change it back to... MJ	12-29-2004 11:57 PM MJ	4	43
Query - fields showing up that aren't selected I am having trouble running queries. I select the fields I want to show up in the query, but they show up along with the rest of the fields. What... MJ	12-29-2004 10:24 PM MJ	2	49
In Access 2003, how to: output a value, followed by a percent sign (%), from a SQL query on a Report Hello world: I'm having trouble finding how to escape the percent sign ("%") from a SQL query so that it will show up in an Access report. Here's... Alan Lane	12-29-2004 09:43 PM Tom van Stiphout	1	48
Why can I not add a field to form??!! MS Access 2003 on Windows XP Sequence of steps taken to date: 1. Created 7 tables 2. Established relationships with all tables using a single... TroutFisherMan	12-29-2004 08:56 PM Rick Brandt	2	50
More trouble getting Dates What is it with these dates? What are they so much trouble? All I want to do is subtract an hour, but not if that makes dtmTest less than... deko	12-29-2004 08:53 PM deko	9	50
Access and MYSQL continous form problem I am using an Access2K front end to a MYSQL database. If I enter a new record in a continuous form the record appears as #deleted as soon as I... Paradigm	12-29-2004 08:14 PM Albert D. Kallal	9	43
ListView Control: Some way to estimate size needed? I'm using one of these things as a dynamically-populated picklist. If nothing else, I'll just save .RecordCount after populating it and... (Pete Cresswell)	12-29-2004 07:59 PM Douglas J. Steele	4	44
80004005 too many columns selected Posting a solution to a problem I had. In the the following code I was getting an error something like "80004005 too many columns selected" After... Raposa Velha	12-29-2004 07:36 PM Raposa Velha	1	44
Query I am having trouble running queries. I select the fields I want to show up in the query, but they show up along with the rest of the fields. What... MJ	12-29-2004 07:30 PM Jeff Smith	1	118
Query - fields showing up that aren't selected I am having trouble running queries. I select the fields I want to show up in the query, but they show up along with the rest of the fields. What... MJ	12-29-2004 07:16 PM MJ	0	44
Query - fields showing up that aren't selected I am having trouble running a query. I select the fields I want to show up in the query, but they show up along with the rest of the fields. What... MJ	12-29-2004 07:16 PM MJ	0	40
OpenArgs from a combo box? Hi. Okay, I've got a combo box , zip, of zipcode, city, state,zipcodeID on form Clients. It shows the zipcode, but the bound column is 4, the... Ron	12-29-2004 06:44 PM Ron	2	46
Vary gap widths in report charts (ACC2000) I'm working with an Access 2000 report that displays a number of bar charts. The charts tend to have 1 to 5 bars on them, but occasionally there is a... parrishioner@gmail.com	12-29-2004 06:32 PM parrishioner@gmail.com	0	46
Enter Parameter Value dialog appears on only one PC I have a customer with an Access 2000 database that was created by a former (and no longer available for questions) employee of theirs. Recently, the... Michael Quinlan	12-29-2004 04:57 PM PC Datasheet	1	41
find duplicates wizard Hi. There is probably a very simple explanation for this. I am using the find duplicates wizard, I am asked for the fields that may contain duplcate... Phil	12-29-2004 04:26 PM Darryl Kerkeslager	1	48
list all dates within a range except for those in table Aloha, I have a problem that I can't think of a (easy) solution for. I'm building a web app (asp/access) that will allow people to book a cruise on... Tony	12-29-2004 04:13 PM Tony	0	46
ASP and access Can someone please tell me what is the correct way to submit to a checkbox field in Access from ASP script? Should it be 0/1 or T/F or Y/N or... Neil	12-29-2004 02:31 PM Neil	2	90
Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software ) Hi, I am a Data Recovery Specialist and Professional Data Recovery Software Developer in New Delhi. I've placed the Complete SOURCE CODE of One of... Author Tarun Tyagi	12-29-2004 01:40 PM Author Tarun Tyagi	0	36
DoCmd.TransferDatabase saveloginid flag working? I'm trying to copy some ODBC linked tables from one access2k mdb to another. This is an example of the code i'm using: DoCmd.TransferDatabase... astro	12-29-2004 12:14 PM astro	0	37
Setting a default equal to the last value entered I am trying to set a control to equal the last value entered for that control on the previous form. In other words: I have a control called... Glen Welsh via AccessMonster.com	12-29-2004 10:43 AM PC Datasheet	1	47
createdatabase method not accepting dbVersion40 I am using an Access2k/VBA60 setup. When I call the following I get an Access97 mdb - I want an Access2k mdb. Set mNewdb =... astro	12-29-2004 09:51 AM astro	0	54
Export records to text file? Hi, I'm trying to come up with a way of generating 'warning' e-mails based on specific criteria within an Access (2003) database. I've decided to... Pecanfan	12-29-2004 08:44 AM Pecanfan	2	46
Problem setting .OnClick event ( 1 2 ) Hi I have a form with 140 labels. Each label has got an OnClick event that is different for each of these labels. Now I want to use the form as... gg.WS@TerraTerra.ch	12-29-2004 06:12 AM Bas Cost Budde	12	82
Combining records I have a database table like the following: id\|name\|item_id\|sequence and the following instance... mike	12-29-2004 06:11 AM Bas Cost Budde	4	43
RE Query forms Olá Luisa ;-) If I understood correctly, you would like to display the results of a query in a form. No problem, just go to the "Create form by... Raposa Velha	12-29-2004 05:14 AM Luisa Lopes	1	52
Web-Based DB Application I have an Access 2000 mdb with a SQL Server 7 back end run on a WAN. The client is talking about converting it to a web-based application,... Neil Ginsberg	12-29-2004 04:52 AM Neil Ginsberg	6	40
ADP: subform auto-requeries in endless loop Hi All, This one has me stumped. I hope someone else has seen this behavior and knows what's going on. I'm using Access 2003 ADP on Windows XP,... Tom van Stiphout	12-29-2004 02:19 AM Steve Jorgensen	2	43
Using a string to call a function I have a load of function names stored in a table which I want to use to decide which function to run. I can select the function name but I cannot... Alex	12-29-2004 01:37 AM jimfortune@compumarc.com	5	46
Re: Table of U. S. counties & zip codes? http://www.ardice.com/Reference/Education/Colleges_and_Universities/North_America/Canada/British_Columbia/Okanagan_University_College/Admissions_and_F... mrrpkqpm@search26.com	12-29-2004 01:07 AM Tom Warren	3	67
Best way to find a record in a table with a large number of entries? It's a database keeping info about people and is expected to contain 20,000 to 25,000 people. I could put a GoToPerson Combo on the form, but the... Richard Sherratt	12-29-2004 01:03 AM Richard Sherratt	8	48
Remote database Dear Gurus, we have 3 branches in variuos locations say various city. they are linked as VPN, WAN...you can say internal LAN. we wanted to... salimshahzad@gmail.com	12-28-2004 11:44 PM salimshahzad@gmail.com	2	62
Forms with Calculated Fields not populating I have an Access program that displays Customer data into a form and OrderID data into a subform. The totals in the Subform are based on calculated... tconway	12-28-2004 09:10 PM Allen Browne	1	47
Picklist w/Snaking Columns? (Access 2k) I've got a situation where the user is expanding nodes in a TreeView and below a certain level, the child nodes become too numerous for them to deal... (Pete Cresswell)	12-28-2004 07:32 PM (Pete Cresswell)	6	45
LastXDay function Here's a function to return, e.g., the date of the last Saturday in a given month: Public Function LastXDay(dtD As Date, DayConst As Integer) As... jimfortune@compumarc.com	12-28-2004 05:54 PM jimfortune@compumarc.com	0	39
Using Wildcard with IIF() Statement I have an IIF statement in the criteria of a query. I would like to know how to use a wildcard with the varaibles inside it. For example IIF(, ,... Law.Win@gmail.com	12-28-2004 05:38 PM Wayne Morgan	1	46
Re: Finding a Record Hello... First, Using MS Access 2000 Now, the problem: I have a form called frmInvoice. Basically the form is used to Upload a flat invoice file... Fenix Bird	12-28-2004 05:25 PM Fenix Bird	0	43
Automatically get data in field when picking something in other field Hello, I have a database set-up with a form and two subforms in it. I have one of the subforms (replacement parts) set-up where you can pick... jballard@acecwi.com	12-28-2004 04:01 PM Bas Cost Budde	7	43

Page 509 of 820

509

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