Sponsored Links

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

Page 79 of 820

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Custom Autonumber I posted this a month or two back but am still looking for a good solution...tia I need to know if the following is possible. I have a vague idea... turtle	09-03-2008 09:06 PM Tom van Stiphout	3	15
Force user to save form data Hi I'm trying to make a form that makes it optional for the user to save the inputted data. If the user does not tap the save button before leaving... Cron	09-03-2008 01:44 PM Cron	2	13
A97 replace question? I have memo field containing imported data. In it are numerous Chr(13) & Chr(13) & Chr$(10) occurrences. How do I rid my table of all occurrences of... MLH	09-02-2008 09:26 PM MLH	5	13
How to bring window to top How do I bring a window (in this case a report) within Access to the top using code? i.e. make the report viewable (this is after it has... Gord	09-01-2008 08:19 PM CDMAPoster@fortunejames.com	9	15
Help! Combo Box I must be missing something obvious, but I can't get my combo box to work properly as I understand that it should. I've got a multiple column drop... Gord	09-01-2008 04:43 PM Gord	2	15
Quick Question on Dynamically adding controls to a form Hi all, It's been a long while since I've posted or used access and one of the things that had me stop was the realisation I couldn't dynamically... Mat	08-31-2008 10:15 PM tina	3	15
Comparing Difference (in Years) Between Two Dates & Totalling -Troubleshooting Hi, I've setup a query that compares the difference (in years) between two date fields (Joining Date & Date Cancelled) and then totals how... sharsy	08-31-2008 06:19 PM sharsy	2	62
SQL 2008 Express Studio Management Recently I installed SQL 2008 Express with the Tools option, which included the Managment Studio. Doing so was a giant pain, but as it's free, I... lyle fairfield	08-31-2008 05:29 PM lyle fairfield	0	64
Report Detail_Format Event Hi All, I have a report with an accumulating value control. I use the Detail_Format event to periodically change the backcolor of the control. The... Fred Zuckerman	08-30-2008 01:07 PM Marshall Barton	1	69
Cause Of Data File Corruption? ( 1 2 ) I have an Access 2003 data file that has now corrupted twice in a week. The database is extremely simple with one main data table and a few lookup... Wayne	08-29-2008 10:14 PM Tony Toews [MVP]	16	106
Forcing users to save exported reports to a specific folder I have an Access application on a terminal server. Sometimes my users need to export reports to pdf, rtf or xls files and save them to their own... evenlater	08-29-2008 05:44 PM Phil Stanton	3	71
Access Report to ADO recordset.. Is there any way at all in Access 2003 to bind a report to an ADO recordset? The closest I've come so far is to use a pass through query that gets... Matthew Wells	08-29-2008 04:31 PM rkc	5	64
VBA code! I am trying to fix the following VBA code from an MS Access database I inherited. I conclude with an example of one of the symptoms resulting from... zufie	08-29-2008 02:22 PM zufie	3	86
Cannot compact on server using Access 2003 I have a number of Access 2000 format databases on a Windows 2003 server. For some reason I can no longer compact these databases directly on the... Bruce	08-29-2008 10:14 AM Bruce	3	65
can't import tables from table in "unexpected state" I have a client who that was using an mdb file, and they appear to have accidentally attempted to compact/repair or convert it, and then tried to... Gwindor	08-29-2008 10:03 AM Bruce	1	60
access 2007 will not print report ( 1 2 ) I have a DB that I developed on access XP (2002) and deployed over a year ago. No one has had problems printing any of the reports within the DB... Snoopy33	08-29-2008 09:37 AM Allen Browne	10	103
criteria on combo box hi all, I have a form in which there is combobox which has empnames listed and a textbox which has empIDs. textbox value is loaded from the table,... Farhaad Faaique	08-29-2008 09:21 AM Fred Zuckerman	2	75
Help Needed With Sending Email Addresses To Outlook I'm using the following code to send email addresses from a query to Outlook: Dim db As Database, rs As Recordset, sql As String, emailTo As... Wayne	08-29-2008 04:32 AM Wayne	2	62
How to make the right corner closing cross invisible ( 1 2 ) Dear reader, By opening an application I get always the main Access window with the closing cross in the above right corner. Is there a... Simon van Beek	08-29-2008 01:05 AM CDMAPoster@fortunejames.com	13	96
SQL Query to transpose data from rows into columns Hi all, I have a table with two columns, labeled Year and Loss. In the Year field, I have the numbers 1 to 10,000, each which can or cannot repeat.... Haas C	08-28-2008 10:56 PM Arch	4	80
Sending email with CDO from Access I'm trying to send an email from an Access procedure using CDO. I've been able to do it successfully with three different sending email addresses,... evenlater	08-28-2008 07:02 PM Tony Toews [MVP]	6	74
Make Table Query to external ODBC SQL Server database ( 1 2 ) Hi All, Is it possible to create a Make Table query in access (2.0 and 2003) that creates the table into a SQL Server database? Following the... Mourad	08-28-2008 03:22 PM Rich P	10	106
Query returns incorrect results I have two drop down boxes, for the fields "County" and "Category" on a form which when selected for the respective County and Category will return... zufie	08-28-2008 08:57 AM zufie	3	68
Problem after loading form First of all, thanks everyone here for their posts. They're very helpful. Second, i have the same problem as Mihai B., as the code seems to... Trandafir Marius	08-27-2008 05:53 PM Trandafir Marius	0	68
Toolbar keeps going away, force it up? I built a little MS-Access inventory application. For some reason when some users open the application, the standard tool-bar is missing for them. I... topmind	08-27-2008 03:58 PM topmind	2	77
Re: Jobs, Interview Questions, Certification Newsgroup spam complaint filed with ISP and news server. This post is in violation of USENET newsgroup rules and the charter... Larry Linson	08-27-2008 12:33 PM Larry Linson	0	60
Access 2007 Runtime Question Will the latest Access 2007 runtime run a database that has been written using A2007 SP1 without having to install the SP on the target machine? I... Wayne	08-27-2008 12:29 PM Chris O'C via AccessMonster.com	3	75
Using VBA to toggle from MS Word to MS Access? Access 2003, Windows XP SP2 I have an application that generates a word document populated with a variety of fields from Access tables. The word... Kelii	08-26-2008 08:16 PM Kelii	4	74
Access crash caused by large sql I have a report SQL which have been working for a few weeks. Its large and the target database is large. It has 59 join, and I dont think there is... Harel	08-26-2008 02:11 PM rumkus@hotmail.com	9	71
Access 2003 to 2007 Should I expect any issues from upgrading Access applications built on 2003? I've built a few that are deployed into a Citrix environment, but... lukethegooner	08-26-2008 12:15 PM lukethegooner	7	71
Make-table (?Materialized views?) of complicated cross tabs,calculated field Hi All, I need to know the best way to set up a datawarehouse/materialized view for doing statistics/graphs in Access. My crosstabs and unions are... jonceramic	08-26-2008 12:08 PM Rich P	3	66
Controlling query criteria from an unbound form field Hi all, Unfortunately I am quite a novice with Access!! I've created a number of data bases for my work however becuase my skills are limited... DeZZar	08-26-2008 10:56 AM jonceramic	7	72
anish add www.hollywoodphotos4u.blogspot.com anish	08-25-2008 11:40 PM anish	0	83
Find or Search for a date on startup. I have a table that contains a field called RDATE (reminder date). Dates are optionally entered to remind a user of an upcoming event. I have a... Greg (codepug@gmail.com)	08-25-2008 09:21 PM Greg (codepug@gmail.com)	5	57
Evaluating a group of combo boxes I want to look at the values of six combo boxes. If any of the boxes are not null, I want to change the value of a separate text box. How can I look... troy_lee@comcast.net	08-25-2008 08:03 PM Bob Quintal	8	73
Report runs on one pc but not another Hi, It's an Access 2003 report. The underlying query runs fast on my PC but I have to hit Ctrl-Break to stop the report as it is stuck... PW	08-25-2008 06:40 PM PW	2	79
Print "&" Symbol in Report How do I print the "&" symbol in an Access 2007 report? The help system says I should use the ASCI character 38 while holding the Alt key. This... Winks	08-25-2008 12:41 PM Winks	4	76
Open the report conditionally Hi All, I am trying to open the report conditionally from the dialogue box form. In the form there are three... Naushad	08-25-2008 08:22 AM Allen Browne	3	65
DROP TABLE vs DoCmd.DeleteObject acTable ( 1 2 ) My client has a db I am working that uses temp tables. During an update procedure, I had the code If fTableExists(tempTblName) = True Then... Dean	08-25-2008 12:15 AM CDMAPoster@fortunejames.com	10	100
DAO RecordSet question I have an increasingly-complicated query string that sends results to an Excel file; I've broken the query somehow. Currently using Access 2007, DAO... Jeff	08-24-2008 08:45 PM Tony Toews [MVP]	2	79
Write to and store data in a listbox I have a form that screens the database. I build a dynamic WHERE clause into a string and apply it to the form's filter. I want to allow the user to... troy_lee@comcast.net	08-24-2008 02:40 PM troy_lee@comcast.net	2	59
Run procedure in a different database Is there a way to run a procedure in a different open database? Karl	08-24-2008 01:40 AM lyle fairfield	7	67
Save item from Microsoft Office Outlook View Control in access table Hi, I am using Access 2003 and have a form with the Outlook View Control. I want user to be able to drag an item from the view control to a bound... christian@w29.com	08-23-2008 03:43 PM christian@w29.com	0	71
List box column,row as control source Is it possible to use the row (index) of a list box as control source Property for a text box? Example: Text1.ControlSource Property is set to "=... Lou O	08-23-2008 02:08 PM Lou O	4	69
report back future date Dear Friends i am trying to get a future date as follows, data:1) date of proceeding to leave = D 2) number of days leave sanctioned =N 3) date of... drrajnishpatel via AccessMonster.com	08-23-2008 05:21 AM drrajnishpatel via AccessMonster.com	4	77
Hiding the Properties Box How do I suppress the properties box on database startup? Thanks. troy_lee@comcast.net	08-22-2008 11:04 PM Allen Browne	3	83
Access 2007 form question I have a Access 2000 database that I am opening with Access 2007. When I open the datbase in Access 2000 or Access 2003, the database runs as... Icarus	08-22-2008 08:49 PM Linq Adams via AccessMonster.com	7	70
Free FX Signal Free FX Signal for major pairs http://chadstown.com/forum/default.aspx?g=topics&f=57 Chad	08-22-2008 08:31 PM Chad	0	70
Requiring user to re-login periodically I'm using the Access User-Level Security features with various users set up. I have a form/timer all set up to trigger an event after a period... RussCRM	08-22-2008 03:11 PM RussCRM	7	60
Locking/Unlocking Fields on an ACCESS 2003 Form I would really like to have the form come up locked, and then the user unlock it for changes, and then lock it again. I'm using Access 2003. I have... haroonahmad@att.net	08-22-2008 11:23 AM Allen Browne	1	70

Page 79 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