Rating Thread / Thread Starter	Last Post	Replies	Views
Looking for an Access Programmer I'm in search of an Access Programmer that is located in the Dallas / Fort Worth area to help modify an access database. Please send me an email if... jkraemer@logixsales.com	08-30-2004 02:57 PM Tony Toews	6	61
a2k - validating excel file before importing If I need my Excel file to contain only 3 columns before I import it into Excel using VBA, how could I check that this is so? Also another check... Deano	08-30-2004 12:52 PM Pieter Linden	1	55
How to eliminate nt integrated security option hi, wanna know how to prevent any user on access projects when they wanna create new project from using nt intgrated security so they wouldn't use it... Joe Saliba	08-30-2004 11:42 AM Joe Saliba	0	48
saving a record before a Close action -- "Me.Dirty = False" OR "RunCommand acCmdSaveRecord" If I want to explicitly save the record before executing a Close action. Which of the following should I use? Or does it depend on whether it is... RC	08-30-2004 11:25 AM Allen Browne	1	49
problem with autonumber-field in Access I have a problem with a database of concerts, where I recently tried to change the existing database with some new rows/categories and some new names... Knut B.	08-30-2004 11:23 AM Allen Browne	1	54
Re: The Coming Retirement of David and Larry "Anonymous Sender" <anonymous (AT) remailer (DOT) metacolo.com> wrote How kind of Resident Troll and Disruptive Poster Don to try to save... Larry Linson	08-30-2004 08:58 AM Michael \(michka\) Kaplan [MS]	2	46
Error 3251 Operation is not supported for this type of object I have an A97 application that I am modifying. I have created an unbound form, "zfrmTestEnterPlacements", with a subform, "zsfrmSelectPlacement". ... Alex Wisnoski	08-30-2004 07:53 AM Alex Wisnoski	2	50
bind a standalone recordset to a form Hello All, I am looking to whip a recordset out of thin air through a series of database record manipulation (so there is no physical equivalence... Henry Su	08-30-2004 06:47 AM Dimitri Furman	5	61
Hoiw to store text to the Windows Clipboard using vba Hi all, Could anybody give me the syntax for writing the contents of a textcontrol to the Windows clipboard . (i.e. on the afterupdate event) Any... Ronny Sigo	08-30-2004 06:06 AM Ronny Sigo	2	54
Access Linked Tables and IIS/ASP I have a few FrontPAGE 2002 Webs running on Windows 2003 Servers and IIS. My webs use ASP (classic) pages that display data pulled from the Access... Stu	08-30-2004 04:38 AM Stu	0	55
multiple records open with forms Hello, Is it possible to have more than one record from the same table open on the screen using forms? If you have an contact list for example and... Hp	08-30-2004 01:01 AM Hp	3	60
Database Design Hi. I was wondering if there was anyone that could take a look at the specs for this database and help me through... Sam DeRT	08-29-2004 09:22 PM Pieter Linden	3	56
Queries with field names defined by a control in a form I want to create a select query where I can define which field is used by a control in a form. For instance if I have a table tServices, in which... Gwin	08-29-2004 08:46 PM Allen Browne	3	46
How do I remove references to non-existent menubars in an Access 2.0 report? I am working with Access 2.0. I have imported a report from an old application for use in a new database being build in Access 2.0. The... MLH	08-29-2004 08:01 PM MLH	2	52
better VBA editor? Does anyone know of a better VBA editor for Access? It would be nice to have an editor or "source safe" that tracks changes and shows relationships between things like "If" and "End If". Anyone know... RC	08-29-2004 02:43 PM Albert D. Kallal	1	54
queries and sql Iif I wanted a count of client "encounter" dates, from a table that stored all services delivered to clients. A client may receive more than one... Gwin	08-29-2004 10:37 AM Gwin	2	62
Credit card authentication from Access I'm using a standalone Access database to record customer payments and we have a separate credit card authentication box. Is there any easy... DLN	08-29-2004 10:06 AM PC Datasheet	2	54
Connect to filebased accessdatabase on other computer? Hi! I have a Windows 2000 computer (let's call it Comp1) that is used as a web server and i have an other computer (Comp2) that has a... Mats	08-29-2004 08:49 AM Mats	0	49
Filter Combo Box Using A Checkbox I have a form that contains the following: 2 radio buttons (Name and Number) 1 check box (for Inactive Members) 1 combo box (list of Member names or... Mark	08-29-2004 06:56 AM Mark	3	52
Access with SQL Server I'm aware that Access is best used for small to medium size enterprizes. What I'm interested in is the use of Access as a backend when it's... Big Time	08-29-2004 04:32 AM Rich P	3	60
how to know which is the current user logged on access project hi, hope somebody could help me with this, have some users created on an sql 2000, and am trying to know which user opened the adp , so everytime i... Joe Saliba	08-28-2004 05:18 PM John Winterbottom	2	65
Linked SQL Tables I have an Access frontend for an SQL backend. I'm simply using ODBC to connect. On my copy of this Access database, I have four linked tables... Enzo's Dad	08-28-2004 01:45 PM Douglas J. Steele	3	58
Query on a calculated date field I am setting up a database for a friend who's an Optician, using MS Access 2002. All seems to be working well, but I have hit a snag. There's a... Norbert Lieckfeldt	08-28-2004 01:41 PM Douglas J. Steele	2	47
How to terminate process with VBA? I use the default windows phone dialer to make calls from an Access form. I close the phone dialer after the call is made using the below function. ... deko	08-28-2004 01:38 PM deko	4	77
Calendar of Events Does anyone know of a sample database that contains a form with a calendar where events can be entered and sisplayed on any day? Thanks! Jessica Jessica	08-28-2004 01:32 PM Douglas J. Steele	1	74
SQL Problem I have to (2) tables, Events and Errors. Events ------------- RecordNumber EventDate EventType EventProblem EventSolution PW	08-28-2004 10:55 AM PC Datasheet	2	63
Telephone Hi! I'm using the wizard in ms access 2000 to do the following: Private Sub cmdTelephon_Click() On Error GoTo Err_cmdTelephon_Click Dim stDialStr... Geir Baardsen	08-28-2004 10:00 AM Geir Baardsen	0	75
Reporting Problem ! Here is a code snippet in my Report: Snippet starts here ********************** Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount... Prakash Wadhwani	08-28-2004 04:12 AM Prakash Wadhwani	3	62
Opening an external Access form to add record (not-in-list event) My form contains a combo box and the "not in list" event is triggerred when the user enters a value that is not among the values listed in the... Todd	08-28-2004 03:29 AM Reggie	1	57
ByRef question Hello all, Here's my scenario. I have an Access app that needs to grab data from an Excel worksheet. What I've done is create a function in... Bodi	08-28-2004 12:05 AM Bodi	0	54
ByRef question Hello all, Here's my scenario. I have an Access app that needs to grab data from an Excel worksheet. What I've done is create a function in... Bodi	08-28-2004 12:05 AM Bodi	0	56
Access 2003 with a 2000 database Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions... Jeff	08-27-2004 11:04 PM Jeff	2	53
Check for Backup file before deleting I have a database that does an auto backup of some data before closing. I also have it set up to delete all backup files older than 5 days. I can't... ShyGuy	08-27-2004 10:17 PM ShyGuy	5	54
Re: Converting Access to MySQL and other important matters "Anonymous Sender" <anonymous (AT) remailer (DOT) metacolo.com> wrote Just hate to see you have to caution against yourself, Don. Thus, all... Larry Linson	08-27-2004 10:13 PM Larry Linson	0	45
How to trigger a tab key press programmatically? Hi, All I try to trigger tab key press when enter a string in "customer ID" if its length is six, but I cannot find command to simulate TAB KEY... kai	08-27-2004 09:58 PM kai	3	53
MS Access on PocketPC? Is there any program (MS Access or another one that can emulate it) that I can use on my Pocket PC to run my databases? Including all codes, etc Rated R1	08-27-2004 07:04 PM (Pete Cresswell)	2	54
ZOrder or SetChildIndex in Access Hello all, I am curious as to whether there is a way to use ZOrder or SetChildIndex in MS Access (VBA) to place one control at the top of the Z... Angus B. Atkins-Trimnell	08-27-2004 07:04 PM Dimitri Furman	1	57
Access Parameter Query to Word Merge Access/Word 2000 I am trying to merge a word document with an access query that has a parameter attached to it. Could someone please suggest how to... Lynn A.	08-27-2004 05:04 PM Pieter Linden	3	57
going beyond blanket upper case conversion Is there a function that will take a name from a table and convert it to title case? ie the first character of the name in upper and the rest... Peter Bailey	08-27-2004 04:34 PM Pieter Linden	3	59
Changing form properties with a button Hello, I currently have a subform that displays four fields from a query. I have the subform's properties set as follows, so that the end users can... Tim Graichen	08-27-2004 03:25 PM PC Datasheet	1	57
Can I call a SQL Server 2000 User-Defined Function from Access 2003? Does anyone know if this can be done? Steve D	08-27-2004 03:13 PM Steve DeBettignies	4	56
What is the largest "auto number" that can exist in an Access database? How to reset autonumber to start at 1? ( 1 2 ) Hi: I know this is a strange question, but I have inherited a system where files are copied and records re auto numbered (as an index field)... John Baker	08-27-2004 03:01 PM MGFoster	16	115
How to suppress pop up box. I am updating a table with an SQL statement in a VBA module when you click a command button on a form that closes the form after doing some... John Michael	08-27-2004 01:41 PM Pieter Linden	3	52
Different users, different access using encrypted data My database have 20 tables and many users. I wish to store encrypted data in 3 tables and have only 3 users have access to them, walking into tables... Nico	08-27-2004 12:48 PM Nico	5	49
Comparing quarterly sales data to previous quarter and previous year. I have created a query that examines qarterly sales for 5 regions in the country. The query contains data for the past 6 quarters for each region... Terencetrent	08-27-2004 12:30 PM PC Datasheet	1	47
running sum yes the week commencing column is the unique column date * Sent via Developersdex http://www.developersdex.com * Don't just participate in... peter bailey	08-27-2004 11:46 AM Peter Bailey	1	59
Declaring variables Hi guys. I have a question about declaring variables. I do a lot of re-querying of controls in my database and I use the Set statement with a... ColinWard	08-27-2004 10:56 AM Allen Browne	1	52
VIEW Relationships Using VBA Hi, I'd like to have a couple of buttons on my form so I can quickly access some Access (97) features: A) The relationships window; B) Tools -... LoopyNZ	08-27-2004 10:52 AM '69 Camaro	3	62
Listbox max lenght valuelist Dear All, What is the max lenght of the valuelist-string as rowsource in a listbox ? I use a listbox to show all the files in a folder. Filip Filips Benoit	08-27-2004 10:36 AM Terry Kreft	2	53
MAX with JOINS This undoubtedly is very simple, but for the life of me I can't get the query to work. I tried a search of the archives, but didn't come up with... Cliff	08-27-2004 09:32 AM LoopyNZ	1	103

Page 570 of 820

570

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