Rating Thread / Thread Starter	Last Post	Replies	Views
Incorrect Date posting Access 2000 SQL statement Running MS Access 2000 MS Windows XP Pro This has caused me a lot of hair loss in the last few days so would appreciate any help. I am running code... m_t_hill@hotmail.com	04-12-2005 04:23 AM Matt	5	75
Conditional formatting problem Has anyone figured out how to apply more than 3 conditional formats to a datasheet (or continuous) view, or in lieu of that how to apply more than... DFS	04-12-2005 03:46 AM Br@dley	3	66
Access report totals Hello- I just managed to get the total from my subreport to sum with my main report total. I am able to get the correct display if I do not have... Scott	04-12-2005 03:30 AM Scott	6	68
Newbie question: adding columns to an existing table table name: site_plots current column names: Mapeast and mapnorth new column names: xcoord and ycoord (of type: double) Access version:... Zoe	04-12-2005 02:28 AM Zoe Goodchild	5	59
SQL in VBA Im trying to run a query in vba and take the result of the query and set a text box on a form to that value..I try this code: eventholder... Jimbo	04-11-2005 10:31 PM Alan Webb	6	105
Pictures in Reports I have a report which has a jpeg picture yet when I email it it does not appear on the report. Any ideas? It prints OK - TIA Chesne	04-11-2005 10:17 PM Br@dley	1	62
Break Default VBA Reference Hi all, I have an Access 97 database that has as one of it's default references the VBA332.dll file. Our company has started upgrading users to... strvariant	04-11-2005 08:14 PM strvariant	2	76
Group Level Count I can't seem to find a straight answer for my specific issue. Any help would be appreciated. I would like to count the various items in a table... cefrancke@yahoo.com	04-11-2005 07:22 PM jimfortune@compumarc.com	2	60
Access 2003 Edition Hi, I just purchased Access 2003 and wondered how I can figure out what Edition I have - if it's standard or professional. I've been looking all... Lirva Smith via AccessMonster.com	04-11-2005 06:18 PM Douglas J. Steele	1	58
publishing a MS Access Database under one of the open licenses Dear All I am looking at publishing an MS Access Database under an open license. That means that I will make it freely available on my website, that... windandwaves	04-11-2005 04:50 PM windandwaves	3	60
Problem with disconnecting Hello, I have an application and BD.mdb (Access97) on the server (Windows2003 EE) with fifteen workstations (Win2k & WinXP), which run the... OliP	04-11-2005 03:03 PM MGFoster	1	69
Event Caller Question Hi to everybody, I have this problem I attach an event to a group of control from code: Set Frm = Fom_Test for ii = 1 to 100 Frm.Controls("Label" &... Luca Giannoni	04-11-2005 02:51 PM MGFoster	2	61
Syncronize two copies of a database I have an Access application that I wrote for a very specific business. They now want to put a copy on a laptop and retain the application on their... WØCBF	04-11-2005 02:43 PM MGFoster	2	60
One backend or two? I have a client that has two pretty distinct functions for which I'm developing databases. There are only a few staff in a small office. It looks... Jan	04-11-2005 02:10 PM dedejavu@hotmail.com	5	102
Modifying subform makes query vanish I have a database that displays the results of my queries in a subform within another form. As soon as I modify the query table and save the changes,... innocentchick@gmail.com	04-11-2005 01:56 PM innocentchick@gmail.com	0	56
Date() function problem Dear Access expert I am trying to use an mde application developed in Access2k with Access 2002. I get an Access error box: Function is not... Ian Davies	04-11-2005 01:33 PM ng	5	70
mousewheel events? is there an event for the mousewheel? I have turned off navigation buttons but the mousewheel still allows it. i have a form that allows new... Steve	04-11-2005 01:31 PM Kevin Nechodom	3	60
Combining data from separate databases I have several databases, identical in structure but with different data. Is there an esay way to combine all the data into one big database? There... Reidar Jorgensen	04-11-2005 11:32 AM Matthew Wells	1	39
Table relationships and join type I'm creating relationships between tables using VBA and ADOX. I can create one-to-one relationships with an inner join, but I can't figure out how... Gandalf	04-11-2005 11:25 AM Matthew Wells	1	52
Fill from Combo Box Selection - Speed Issue? Hello, I need some advice on which way to resolve the following. On a form, the user will make a selection from a combo box, after the selection... Tom G	04-11-2005 11:22 AM Matthew Wells	1	57
Calculate totals from nested forms Hi, I have 3 nested forms and want to calculate a total on the first subform (as the form loads)by adding 2 fields from that form + to a field on the... oncewaswillow@hotmail.com	04-11-2005 11:13 AM Phil Stanton	1	60
You have a piont...` You have a point. My terminology was wrong. I am uning ODBC. I already do have tables linked to AS400 by DSN. the problem is that every time... Matthew Wells	04-11-2005 10:36 AM Matthew Wells	3	92
Excluding Previously selected Combo Box record to current Combo Box I have a form for transfers, which has on it 2 combo boxes, each with the same list of locations in them. I want combo box 2 to include all... Will	04-11-2005 09:31 AM Rog	2	52
Timer events that must occur ( 1 2 ) I've recently been playing with some UI ideas that require the user of a timer to drive animation. The problem I'm having is that Access routinely... Steve Jorgensen	04-11-2005 08:47 AM Steve Jorgensen	11	110
Related Subform causing duplicates? I have 2 tables, one for production runs , one for errors created during a production run. For each record in the there could be multiple errors... njhildebrand@suscom.net	04-11-2005 07:13 AM njhildebrand@suscom.net	2	58
Help with... er... not sure how to describe this Hello all I'm not sure how to word this, which is one reason why I couldn't find anything on Google to help me, so please bear with me as I try... Will	04-11-2005 04:40 AM Will	4	56
Where IIf and Datediff Statement I'm pretty new at writing SQL on Access and I need some help writing a datediff query. Say I have a table called tb_Dates with the... edwin.villamayor@citigroup.com	04-11-2005 01:18 AM Mark	1	65
Sharing Access .mde file I have converted my Access database into .mde format. However, my colleague can’t seem to open the file. The message shows that another user has... jy	04-10-2005 10:19 PM Larry Linson	1	57
Subform calculated control Hi, I have 3 nested forms and wish to calculate a value on Subform 1 by adding 2 values on the same subform + to a value in a control on the footer... Bruce	04-10-2005 09:14 PM Larry Linson	2	65
Duplicate Records in a form I have created a table with Customer number as the key field and in another table the key field is a combination of two fields: Customer and System... MJ	04-10-2005 08:51 PM MJ	5	49
Internet access behind win xp sp2 ( 1 2 ) Hi I am using ms internet control in my app. It works fine form all machines except from a new one which has win xp sp2 installed. All machines are... John	04-10-2005 08:47 PM Br@dley	10	83
Accessing a non-primary key field from one table to another I am trying to grab the UnitPrice from Table 1 and store it in the UnitPrice field in Table 2 whereever there is a match ProductID wise. Table 1 -... MichaelJohnson168@hotmail.com	04-10-2005 08:43 PM pietlinden@hotmail.com	3	62
Update one tab from another I have subforms on multiple tabs. On one Subform I have a Personnel Roster. What I want is when I change the gender from Male to Female or... dmkeith2@hotmail.com	04-10-2005 08:33 PM pietlinden@hotmail.com	1	53
Automatic Links in PDfs created from Access I have a very large (by my standards) Access database that I use to produce a price list in PDF format. ie the reports are created in Access then... stevecox4444	04-10-2005 07:29 PM stevecox4444	0	56
gotorecord help please DoCmd.GoToRecord , , acLast can someone tell me how to modify this to go to a specific record, as far as i can tell, i can only tell it to go next,... Steve	04-10-2005 07:19 PM PC Datasheet	1	69
Help with DConcat - Please ( 1 2 ) I think I am so lost!! Please someone write out DCONCAT explanation. Is... kimberly.shaffer@gmail.com	04-10-2005 05:14 PM kimberly.shaffer@gmail.com	11	122
Scroll wheel on mouse Can this be fixed? I have a combo box which is filled with lots of choices on a certain form. I click on the combo box and want to scroll down... Otie	04-10-2005 03:41 PM Ken Snell	1	64
Counting Records I have a query which selects a number of names from a table, which abide with the criteria. I then want another query to select where the names... teddyparnell@hotmail.com	04-10-2005 03:07 PM PC Datasheet	1	68
Track Design Changes Hi all, I am searching for a way to track when a form/report/query is changed by users. For instance: 1) A user opens a form/report 2) The user... strvariant	04-10-2005 01:29 PM David Schofield	1	56
Multi-User Access Database Hi, At work there is an Access DB which sits on a common server and is accessed by multiple users (up to 9 concurrently). Sometimes this database... Dave Cabbage	04-10-2005 01:10 PM Dave Cabbage	2	69
Excel automation weirdness I trying to create an Excel workbook from Access and then do some formatting of the workbook. I did quite a bit of this with Access 97 a few years... Bill Stock	04-10-2005 01:07 PM RoyVidar	1	58
AllowEdits=false and OnKeyDown event I have created a form that has where the AllowEdits=false. When the users try to edit and of the fields on the form, I want a Beep... vidar	04-10-2005 11:54 AM vidar	3	62
How to call a function located in a form module (form open in form view) from an Access Basic global module? I would like to call a function stored in a form module in Access 2.0 from an Access 2.0 procedure in a global module. Function EmailTheOutletters... MLH	04-10-2005 11:40 AM MLH	2	71
Re: Help with Syntax on Webpage what happens if you do something like Response.Write s-sql do you have something like an apostrophe inside your text? If so, the database engine... pietlinden@hotmail.com	04-10-2005 11:37 AM pietlinden@hotmail.com	0	59
Updating a subform using a query I have a query that works, but then displays the results in a datasheet view. The query is reliant on the results of a combo box, and when i update... teddyparnell@hotmail.com	04-10-2005 10:41 AM pietlinden@hotmail.com	1	59
tabbing out of a subform without knowing about the parent There have been threads in this newsgroup explaining how to tab out of a subform to the parent form -- without having to use ctrl-tab (of which users... Michael Fay	04-10-2005 02:14 AM Michael Fay	4	75
SQL Problem - Auction Hello, Similar to my last post I have another SQL problem. If you are running an auction and you have the following... worldbadger	04-10-2005 01:04 AM worldbadger	6	55
A2003 Help Font Size I've somehow reduced the font size of my (pathetic, compared to A97) A2003 help to about a 4 point size, practically microscopic. Can someone please... Tim Marshall	04-09-2005 11:48 PM Tim Marshall	2	74
Creating relationships using VBA I'm creating relationships between tables using VBA and ADOX. I can create one-to-one relationships with an inner join, but I can't figure out how... Gandalf	04-09-2005 09:25 PM Alan Webb	2	58
record template Hello All I'm using Access 2K and Access 2003 with either Win2K or XP. A database for control plans exists. But one customer would like a button or... vmg	04-09-2005 07:04 PM pietlinden@hotmail.com	1	79

Page 453 of 820

453

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