Rating Thread / Thread Starter	Last Post	Replies	Views
Strange Permissions problem (I think) Access 2003. Normal front-end, back-end, network, MDW, UserGroups set-up. The front-end Startup opens frmSplash which runs an Autoexec() function... Richard Sherratt	05-15-2006 01:55 AM Richard Sherratt	0	65
GOTO Indexed Record in Code I'm happy with the SQL, however I need to BookMark 1-Record and I can't seem to make it happen. I want to use Allen & Bob's suggestions (ie... ApexData (AT) gmail (DOT) com	05-14-2006 08:57 PM ApexData (AT) gmail (DOT) com	9	82
Rename tables from external program Hi all, I simply like to write a small program to rename tables in an Access database. I created VBA modules inside Access but I don't want to... pgabrian	05-14-2006 08:55 PM AT	6	72
How to refer to a form control programmatically If I have several text boxes on a form, ie. txtBox1, txtBox2, txtBox3, etc., how can I refer to each in a loop. I want to do something similar to... Vincent	05-14-2006 05:57 PM Rick Brandt	3	68
Inputmask using date - Edit the date after input a cause error I have used an inputmask in a textbox for a date. The first time I put in the date everything is working properly but if I need to change the date... Helge's	05-14-2006 03:39 PM Helge's	2	157
Have SQL syntax for create table/data, how run it in Access2003 ? Have an SQL create/import script. Running this on SQL would make it create a table with some values. Can Access2003 somehow use such and SQL... Jan	05-14-2006 05:20 AM Bob Quintal	4	115
File->Export from a report shows "registry error" in installed app only I built my application with Access 2003 and made a distribution using the Microsoft Office Access 2003 Developer Extensions. (I also install Jet 8 as... Michael Fay in SB	05-14-2006 02:36 AM Michael Fay in SB	0	84
DB developing ( 1 2 3 ) Larry Linson wrote: Like this? Private Sub This() With DBEngine With .Workspaces With .Item(0) With .Databases Louly	05-14-2006 12:22 AM Larry Linson	20	247
Mysterious errors with Event Procedure on one form Every thing worked fine until all of a sudden, I get the following error whenever I try to do anything on one of my forms that calls an... Robert	05-13-2006 08:52 PM Robert	1	76
how to get rid of warnings from required fields? Hi, I made a form based on one table that has several required fields. If in the form, I leave some of them blank and close the form using 'X', I get... swingingming	05-13-2006 07:41 PM fredg	1	67
Constants in queries Hi I have defined global constants in a module. How can I access these constants in a query? Thanks Regards John	05-13-2006 06:47 PM Tom van Stiphout	1	69
building multiuser database I need to develop a multiuser database application to be used by four people(The number of users are not likely to increase). It is for storing... AT	05-13-2006 04:25 PM AT	0	64
prevent importation of tables Dear All, your discussions are really interesting. I work with Ms Access but as many efforts I make to protect the DB as same results I obtain. I... AT	05-13-2006 10:20 AM Chirag Shukla	1	70
runtime error 438 after importing project Me Again, I just imported a working project from an SQL server based setup to an Access based setup, and now this code is giving me a 'runtime error... serviceman via AccessMonster.com	05-13-2006 08:56 AM serviceman via AccessMonster.com	2	78
Combo Box Help I think this is easy for a guru but I've been bashing my head for hours. I have a drop down box in a form that looks up details from a table. There... John Taylor	05-13-2006 02:06 AM salad	1	85
Disabling part of a form on startup and setting the focus I borrowed one of the forms from the MS Access Solutions database and altered it to fit my needs. The form was the 'EditProducts' form where... Robert	05-12-2006 10:42 PM Allen Browne	1	81
Reading Material Hi all, This is my first time here so treat me gently.....I have dabbled with Access now for a number of years and find I can create what... Budd	05-12-2006 09:18 PM Chirag Shukla	3	81
Saving text fields from Word templates into Access DB? We have an access DB that 2 input people use to tracking incoming patients. There is a form for them to do this but they find it confusing to use... rick m	05-12-2006 09:11 PM Chirag Shukla	1	78
Any way to flip a Vertical Alignment label? I have label that I need to be vertical. The problem is that when I select "Vertical=yes" the label reads from top to bottom rather than bottom to... Rico	05-12-2006 06:48 PM Stephen Lebans	5	88
Resizing image control with jpg image Using A2K I have an image control on a report and use code to set the image.picture to the required jpg. 3 of the jpgs resize properly but 2 do... Brian	05-12-2006 06:45 PM Stephen Lebans	1	73
Form that enters data into multiple tables I have a database with multiple tables that are all linked by a "site id" field. For any given record the site id field is identical within all the... rlish	05-12-2006 06:36 PM Bob Quintal	2	75
Debug window: How to change keys that open it "David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote in news:Xns97C15BC0C2FD0f99a49ed1d0c49c5bbb2 (AT) 127 (DOT) 0.0.1: David, the... Yannick Turgeon	05-12-2006 05:26 PM Bob Quintal	9	79
Re: Create a column populated with numbers sequentially that look like 1, 1, 2, 2, 3, 3 ? shiranaomi (AT) yahoo (DOT) com wrote: qryStratify: SELECT X, ((SELECT Count(A.TimeStamp) FROM tblData AS A WHERE A.TimeStamp <... AT	05-12-2006 04:16 PM AT	1	70
How to add a drop-down to a toolbar? (Rich Text) Working with MS Rich Text control, we built our own toolbar, but are stumped as to how to add a drop-down with fonts like you find on the standard... AT	05-12-2006 02:02 PM AT	0	67
Check for Duplicate Data I have a temp table that has data I am inserting into a SQL DB table. There is a column in both tables called PAT_ID. I need to check the SQL table... Mike Charney	05-12-2006 02:01 PM Mike Charney	2	80
Re: Create a column populated with numbers sequentially that looklike 1, 1, 2, 2, 3, 3 ? shiranaomi (AT) yahoo (DOT) com wrote: This routine is a demonstration of how you can get the sequence numbers you desire. It will display the... salad	05-12-2006 01:49 PM salad	0	85
Toolbars not working Good Afternoon, i have a weird situation: my toolbars at the top are not working. i see the regular (Design) bar, but there is another bar that is... Krzysztof via AccessMonster.com	05-12-2006 12:46 PM Krzysztof via AccessMonster.com	0	65
Specify Pages to Print Hello all. I am opening a multi-page Access report via VBA code and was wondering if there is a way to specify the pages I want printed. For... Vincent	05-12-2006 12:25 PM fredg	1	69
Compact and repair Back End From Front End at Runtime Hi Everybody For Microsoft Access 2000 and above Windows XP I am trying to mimic the action of this command that at the moment runs from the... bobdydd	05-12-2006 12:03 PM bobdydd	2	80
Problem with opening form by timer event ( 1 2 ) Hi, In my database (access 2000) everything is done within the main form ("OpenForm"). It has a timer which triggers the code below. It first closes... insomniux	05-12-2006 11:47 AM insomniux	12	153
forcing a page break in a report using code? Hello, I'm looking for a way to force a pagebreak in code. I'm having a tough time, the first page formats properly until the condition is met and... Rico	05-12-2006 10:16 AM fredg	4	132
Need to add multiple blank records in one table based on a parameterized query Hi All, I'm having a problem with some VBA code in one of my Access 2003 databases. I'm getting the following error when running code behind... kenshiro	05-12-2006 08:40 AM kenshiro	6	149
Update form when list selection changes I have a form that has a textbox used to search records in a table. On the form I have a listbox which shows each record in the table. When you click... Brian	05-12-2006 06:20 AM Rick Brandt	3	74
Automating MS Outlook Agenda Hi all, I need to get at specific (shared) agenda-data from MS outlook 2003. I need every day to get the scheduled 'appointments' for some rooms to... Arno R	05-12-2006 05:04 AM Arno R	5	133
Help needed again Hi, i need your help again. I know my problems are v. easy for you, but i'm beginner in access and need a solution. I have a table like this (there... Lebowski	05-12-2006 03:18 AM DFS	1	63
Sending E-mails to adresses in a table Hi everybody I have a table containing a list of E-mail adresses. Is it possible to send an E-mail (one by one) to all the adresses? Is it also... Dirk Goossens	05-12-2006 02:38 AM DFS	1	67
consolidating tables I've used Access pretty basically for the last couple of years, and I'm slowly trying to get a bit more advanced. I'm attempting to consolidate... Monkey Boy	05-12-2006 02:12 AM DFS	1	75
Cannot close Access I'm developing a large project in Access with 3rd party control and custom dlls and sometimes I'm unable to close Access- clicking on the close... AT	05-12-2006 12:46 AM AT	0	61
Access 2003 Beginner - Requery from Combo Box Help Hi. I have created an unbound combo box in a form whose purpose is to pass parameters to a query and then requery the requery. The unbound combo... jay	05-11-2006 10:54 PM jay	2	71
help needed ( 1 2 ) Problem i have records like these: name quantity quality A 5 2.5 B 4 1 B 3 2 C 1 ... Lebowski	05-11-2006 07:28 PM AT	10	161
Help with subreport referencing Hmmm, I'm not too good with the syntax of referencing a subreport. I have frmInvoice which has the invoice details (e.g. ProductCode, ProductCost... Alan	05-11-2006 06:13 PM Larry Linson	9	81
Use Access to POST and read from website? Is it possible to send a POST request to a website on the intranet and then retrieve the information from the site? I'm guessing yes with the help of... AT	05-11-2006 06:03 PM Rick Brandt	1	70
Combine Tables Sorry for the vague subject, not sure how to properly sum up what I need to do. I have 2 tables Tbl1 is single field: CODE 2115-GOR AT	05-11-2006 05:52 PM Bob Quintal	2	80
Pulling Multiple Columns from a Combo Box I have a form with several combo boxes in it. The combo boxes have columns titled: BulletID, BulletPoint, Rating When a user selects the... Jourdan	05-11-2006 05:23 PM Bob Quintal	2	62
Importing Hyperlinks from Excel to Access When I import an Excel file containing hyperlinks into Access, the hyperlinks turn into text and no longer hold their links. I am using the... AT	05-11-2006 05:16 PM AT	4	77
using boolean as criteria in SQL In my SQL I have a column that returns a boolean value (-1 or 0), no problem. I need to be able to only see the records that return a 0 (False).... Daron	05-11-2006 04:54 PM Bob Quintal	7	69
Wrestling Match - Need Access 2002 SP3 POST hotfix ? Greetings, Been wrestling an A97 development into A2002. Am having occassions where you just get kicked straight out of the program. There does... AT	05-11-2006 04:42 PM AT	0	58
Move buttons by user ? Hello, is it possible to let the user move buttons on a screen ? I have multiple buttons on a screen and the user can decide where to put the... etsoft	05-11-2006 04:09 PM Jeremy Wallace	3	71
Crazy email button Hello , I am writing in order to get your valuable help . I have been working on a job which involves sending emails thorough Access. I created a... AT	05-11-2006 04:08 PM AT	0	65
Update Query Help Hello all, I have project form and an hours form and related tables for each. The project table has a status flag to determine if the project is... jofo	05-11-2006 12:37 PM jofo	4	67

Page 286 of 820

286

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