dbTalk Databases Forums  

Sponsored Links

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

Discuss in the comp.databases.ms-access forum.

Post New Thread
Threads in Forum : comp.databases.ms-access Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi Guys, I would like to ask your advice on approaching a problem before I attempt to build anything. The scenario is that every month we have a...
The Frog
03-05-2009 01:32 PM
Tony Toews [MVP] Go to last post
5 90
My clients have Office 2007 Enterprise Edition. When they try to open an ACCDE copy of my Access 2007 database, they often get a message saying "this...
03-05-2009 02:16 AM
Allen Browne Go to last post
9 109
HI all, I have solved a problem using a join between a query and a table, however i need to use the sql, so must convert the qlery in to sql. Heres...
03-05-2009 02:08 AM
Allen Browne Go to last post
1 83
I have programmatically added some new fields to a table, but one of the fields I added needs to be the first column because the table is exported...
03-04-2009 04:18 PM
lyle fairfield Go to last post
2 55
Hello, I am using this code that I got from the forum on an 'UNDO' button on a form which contains text boxes, combo boxes and three subforms. ...
franc sutherland
03-04-2009 10:44 AM
Robert Schott Go to last post
6 80
In Datasheet view the mouse pointer automatically changes to down arrows and adjustable column pointers when moving over header controls. But these...
Lauren Quantrell
03-04-2009 10:18 AM
Lauren Quantrell Go to last post
7 52
David, The connection work fine and many thanks for your input. I now have another problem which most likely relates to Code Pages. In my...
03-04-2009 06:28 AM
john@kosmosbusiness.com Go to last post
7 111
My dentist application (www.VisualDentist.com) supports Greek and recently we bowed to demands from dentists and have included an SMS sending...
03-04-2009 06:24 AM
john@kosmosbusiness.com Go to last post
1 92
Hi, I have a report that is sourced by a complicated dynamically generated search query. Everything works as planned, however now I would like to...
03-04-2009 04:07 AM
Kinch Go to last post
6 89
If I have a form with a tab control containing 5 tabs, and subforms in each of these tabs. The subforms are controlled by child/master links. When...
Astley Le Jasper
03-04-2009 03:32 AM
Astley Le Jasper Go to last post
6 76
Can anyone help? We have been using a database for several years (MS Access 2003). The tables are set up in a database on our server, and we have...
03-04-2009 03:01 AM
Phil Stanton Go to last post
7 110
Hi I have just started using Access 2007. The database window is gone and the navigation pane is interfering with my form layout. Preliminary...
03-03-2009 04:53 PM
Wayne Go to last post
5 106
When I click on the delete button....it deletes the record but does not clear the unbound fields.
03-03-2009 03:02 PM
Salad Go to last post
4 51
I have a field that I want to update every time a record is updated. I have a continuous form, so I can't use the dirty form method. I want to be...
03-03-2009 01:55 PM
troy_lee@comcast.net Go to last post
3 75
I seem to recall that VBA has a variable that I can use at any time in my code to check the return code of the most recent action. Does anyone...
03-03-2009 09:04 AM
Sheldon Potolsky Go to last post
2 81
I have the following code on all of my forms: Private Sub Form_Activate() DoCmd.ShowToolbar "Form View", acToolbarNo DoCmd.ShowToolbar "Menu Bar",...
03-03-2009 03:47 AM
Phil Stanton Go to last post
1 62
I have an app where I download a lot of data from a sTATS system and make it available for read-only reference. The only process that ever updates...
Bob Alston
03-02-2009 10:16 PM
Salad Go to last post
2 77
On Mar 2, 5:14*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: That explains everything.
03-02-2009 10:02 PM
lyle fairfield Go to last post
19 155
Hi, I have a main form and a sub form. The main form is where the user enters the total amount of an invoice and the subform is where the user puts...
03-02-2009 07:38 PM
audrey.nsh@gmail.com Go to last post
2 76
Is Access capable of optimizing the following query? I simply want to return an empty recordset that spans multiple tables: "SELECT Info1A, Info2B,...
03-02-2009 04:22 PM
Vincent Go to last post
6 94
How to I get a report to skip printing a page if the condition I've put in is true, eg If IsNull(Me.txtField) Then don't print this page but keep...
03-01-2009 10:18 AM
anthony Go to last post
4 100
Dear reader, How to stop a VBA procedure after a form is set open with: DoCmd.OpenForm ("FormName"). After this instruction the VBA procedure is...
Simon van Beek
02-28-2009 12:31 PM
lyle fairfield Go to last post
8 82
The Access 2003 / SQL Server 2008 Express app I've created performs well over a VPN, except for the main form which has uses tabs, with multiple...
Astley Le Jasper
02-28-2009 09:53 AM
Astley Le Jasper Go to last post
2 80
The form Chooser has worked without problems for about a year. It suddenly stopped working in November. It was written for Access2003, but I don't...
02-28-2009 09:13 AM
thelma@uwm.edu Go to last post
2 84
Okay, one more for you guys. How could I go about checking a check box based on a value chosen in a combo box on the same form? For example, if the...
02-28-2009 01:58 AM
Allen Browne Go to last post
1 57
I've used the following code which I'm fairly sure I found on this newsgroup to save as text and then import: Option Compare Database Option Base...
02-27-2009 08:37 PM
Larry Linson Go to last post
9 68
Forms, Reports, Combo Boxes, List Boxes Is it better to use a saved query as the RecordSource / RowSource or an SQL statement Discuss ( as the...
Phil Stanton
02-27-2009 07:20 PM
Allen Browne Go to last post
4 105
I have a linked table, the file it is linked to is a .csv file. I want to browse to a location and then link to the selected file (another .csv), I...
Nick 'The Database Guy'
02-27-2009 01:26 PM
lyle fairfield Go to last post
19 160
Hi. I have a database that handles score records for dogs that compete in Obedience. There are 3 different classes that a dog may compete...
Susan Bricker
02-27-2009 09:48 AM
Allen Browne Go to last post
1 53
Something I don't understand about the literature and discussion about ACCESS. It appears as if 80-90% of the work done with this software is done...
Phil Ardussi
02-27-2009 08:26 AM
Phil Ardussi Go to last post
2 50
"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote in news:Xns9BBFB5ACC931f99a49ed1d0c49c5bbb2 (AT) 74 (DOT) 209.136.93: I'm very...
Astley Le Jasper
02-27-2009 06:43 AM
lyle fairfield Go to last post
7 57
I've got 2 tables and a report I could use a hand with. Table 1 contains a number and a name associated with that number. Talbe 2 contains the same...
02-27-2009 03:07 AM
Allen Browne Go to last post
1 84
I want to put a condition like: IIF(Condition1=True,>0,0) But apparently, we can not use >0 inside a if statement? How to get around with...
02-26-2009 07:49 PM
John von Colditz Go to last post
4 93
I am looking for a way to "call" or "parse" whatever the value of any of the text boxes in a continuous form. Meaning that when a user clicks a...
02-26-2009 07:18 PM
lyle fairfield Go to last post
1 60
I dont know what version of Access you are using or how difficult it would be to build a new version of your application in Base 3.0, I can only...
02-26-2009 06:39 AM
Mr.Frog.to.you@googlemail.com Go to last post
7 55
I have a form that includes fields for three different tables. When I click on submit I want it to add the information in the fields in...
02-25-2009 09:25 PM
Tom van Stiphout Go to last post
1 85
I have a dilemma. I have a table that has the following columns Student, Score1, Score2, Score3, Score4, Score5, ScoreTotal Score1 thru Score5...
02-25-2009 08:05 PM
lyle fairfield Go to last post
8 85
Hi I'm using the following code to attempt to change the format of a cell (in excel) dependant on whether it query returns a record from an Access...
02-25-2009 01:12 PM
hans.updyke@gmail.com Go to last post
3 94
Any one can help me?? How to create report inside a form? like a subform maybe...but contain report. So, we can access a report and it appears...
02-25-2009 07:34 AM
Tom van Stiphout Go to last post
3 66
I am trying to lookup a date from a table using dlookup and nothing is returned, but there is a date entered into the table. What is wrong with my...
02-24-2009 09:54 PM
Tom van Stiphout Go to last post
1 113
HI I'm trying to run a count on certain records in a report. How can I set up an variable that I can use to count certain records in the...
02-24-2009 05:51 PM
cron Go to last post
7 49
I have a form that has fields for two tables, Audit and Audit_Comments. A person can enter the audit information and a comment at the same time and...
02-24-2009 03:28 PM
lyle fairfield Go to last post
1 74
I wish to import XML into my Access 2003 Database. Here is the issue. I am downloading from a REST API an XML and I wish to have this data in Access...
02-24-2009 01:32 PM
Guillermo_Lopez Go to last post
4 125
I was wondering how to capture error generated by running the following line ... If Forms!frmMainMenu.CurrentView = 1 Then OKFormsCount = 1 .......
02-24-2009 07:47 AM
paii, Ron Go to last post
2 84
I've been using the Auto FE Updater for a long time and have found it to be an excellent utility. Many thanks to Tony. My question is: On a Vista...
02-23-2009 10:46 PM
Tony Toews [MVP] Go to last post
4 96
Mail Merge (Multi-page thread 1 2 )
I have an MDE database where I allow the user to "Customise" a query by adding criteria, This gets saves as "TempNewQuery" I then want to use this...
Phil Stanton
02-23-2009 06:50 PM
Wayne Gillespie Go to last post
13 173
Iím working on a sick leave management application. TableEmployee: Contains a profile for each individual. TableSickLeave: Contains a history of...
Greg (codepug@gmail.com)
02-23-2009 06:07 PM
CDMAPoster@FortuneJames.com Go to last post
3 66
ALl, Thanks to information I've found here, I was able to build a function and use it in the Criteria row of a query. This works fine now for...
02-23-2009 03:51 PM
Patrick A Go to last post
2 66
Is there any way to zoom in on a report in design view? I'm working with some very small lines on a legal size report and it would be handy to be...
02-23-2009 12:58 PM
Salad Go to last post
1 103
I have a report that prints a memo for each department in the DB with various information they need taken from the DB. I would like to be able to...
02-23-2009 11:44 AM
iwasinnihon Go to last post
10 151
Post New Thread

Display Options
Showing threads 3151 to 3200 of 35153
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.