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     
I want to select all records that fall between certain dates (12/1-2/29-winter),(3/1-5/15-spring),(5/16-8/31-summer)and(9/1-11/30-fall) regardless of...
09-25-2012 04:14 PM
Bob Quintal Go to last post
18 19
Hi, I have an Access query that I want to make a pass thru query of and after doing so and trying to run it, it errors with; incorrect syntax near...
09-25-2012 12:03 PM
bobh Go to last post
2 7
Further to my post of 17 Sept (Expression on click you entered...), I've decided that I need to amend my application by moving function calls in...
Bob Darlington
09-22-2012 07:34 PM
Bob Darlington Go to last post
4 6
What is wrong with the statement? Nz(DCount("", "", " = '" & !! & "' and = '" & !! & "'")) I've tried both with and without the Nz and neither...
09-17-2012 04:05 PM
Douglas J Steele Go to last post
7 82
Bob Quintal wrote: I didn't interpret it that way but if you're right, then Frog already had the correct design.
Bob Barrows
09-17-2012 06:14 AM
The Frog Go to last post
7 8
Sorry to post this here, but I can't find any active Mappoint groups! I need to use MapPoint with an Access db that I am developing. Specifically, I...
Paul H
09-15-2012 09:16 AM
Patrick Finucane Go to last post
2 4
Hi all, I am trying to accomplish what seems to be a simple task but I am having trouble getting the logic down. Basically to explain, consider a...
09-14-2012 06:18 PM
David Hare-Scott Go to last post
1 5
Hi, I hoping some can re-write this Access query for me, please. I don't know t-sql at all and I'm at a complete loss. UPDATE tblStBMthlyWorking...
09-12-2012 12:49 PM
Albert D. Kallal Go to last post
5 7
Hi We're in the process of changing from office 2003 to office 2010 and having a few problems with several MSAccess databases. The following piece...
Carl Barrett
09-12-2012 01:35 AM
Carl Barrett Go to last post
2 5
Hi All, Is there a third party product or access add-in or a sqlserver software product/add-in that would have a query like grid and works like an...
09-11-2012 09:54 PM
Albert D. Kallal Go to last post
1 6
I have a form based on a query that if the query returns a value opens another form to perform a function then returns to the original form to test...
Jim Baird
09-11-2012 03:11 PM
Jim Baird Go to last post
3 9
I have an application that derives data from an Excel spreadsheet. All of the data is imported as text and the columns are converted into other...
Jim Baird
09-10-2012 06:01 PM
Jim Baird Go to last post
5 9
Where I work at our workstations use a standard graphics setting. Recently, after I developed an app my team decided to demo it to the managers. ...
Patrick Finucane
09-09-2012 01:07 PM
JŁrgen Meyer Go to last post
5 85
A client got a warning message: The Microsoft Access Database Engine could not find the object 'MSysDb'. Make sure the object exists and that you...
09-08-2012 01:32 PM
Patrick Finucane Go to last post
2 20
We have a 2007 database on a server that each user has linked tables to and from their personal reporting database to the server database. The user...
09-08-2012 08:56 AM
Douglas J Steele Go to last post
5 36
Hello all- I have a series of queries dependant on network source tables that normallyupdate between 4 and 5 AM. Occasionally, there will be an...
09-06-2012 12:20 PM
RobBrouil Go to last post
4 77
Hi, In the BeforeUpdate event, I am requiring a field to be completed and issuing a message "Activity is Required" if activity is null. I get the...
09-06-2012 11:58 AM
Douglas J Steele Go to last post
6 73
Hi, I want to place a button on my form to take the information in specific cells and add them to another table in the data base, but Iím not sure...
09-05-2012 01:22 PM
bsn Go to last post
1 65
Haven't tried this but I'm about to hit the same problem. Can the rich text be moved into the memo field via the clipboard? Using API's perhaps? How...
The Frog
09-04-2012 10:32 PM
Gene Wirchenko Go to last post
3 68
More from me, sorry! This is really two issues; the first is that everytime I click on an http hyperlink on a form Access 2010 prompts me - please...
09-04-2012 02:50 PM
fearless55 Go to last post
2 67
Hi All, I am working on a database that stores servicing information for industrialequipment - it enables users to log the actions and work...
09-04-2012 12:36 PM
oli.paris@gmail.com Go to last post
2 62
I'm tryng to replicate the box in object that can filter the visualized data while I digitize searching in every field of the table. I have realized...
09-03-2012 07:50 AM
Patrick Finucane Go to last post
8 61
I am going mad with 3 graphs on a form! I can't stop them updating. When I change it to Manual Access resets it back to Automatic (Update Options)....
09-03-2012 06:28 AM
Patrick Finucane Go to last post
2 59
I'm stumped. Where do I set the default font for new tables when viewed as datasheets. Every new table I create uses 'Tw Cen MT (Detail)'. I can...
Paul H
09-02-2012 01:50 AM
Albert D. Kallal Go to last post
3 77
I have three tables in a database that will be eventually migrated to SharePoint: tblProjects: ProjectID, ProjectName, etc... tblOrgs: OrgID,...
Paul H
08-31-2012 10:36 AM
Bob Barrows Go to last post
1 65
Got a data entry form with many fields on it. Suddenly all fields have become non-editable. The form's .RecordSource is editable. All I can think...
08-30-2012 12:45 PM
(PeteCresswell) Go to last post
1 61
Hi All, I'm wanting to put some Access tables on SQLServer, I was given a Server to use which has SQL Enterprise Manager v8 installed. Since I know...
08-30-2012 07:15 AM
bobh Go to last post
2 68
Sorry - We have a client that is being a PITA about our application not being installed into the Program Files folder (the usual know-it-all local...
08-29-2012 11:28 PM
PW Go to last post
9 75
08-29-2012 05:07 PM
Douglas J Steele Go to last post
1 60
I am really struggling with this. I have looked all the examples on various tech sites and have tried numerous alternatives. Why doesn't this...
08-28-2012 04:41 AM
Phil Go to last post
3 96
Hello, I have a table in access 2007 that stores vehicle Trip date, Vehicle ID, Start and End Mileage. I have created a form to enter the data. I...
Kissi Asiedu
08-26-2012 03:49 AM
Phil Go to last post
1 78
I've got an Access 2003 app that's running just fine on everybody's PC except for one. On that PC, Node objects become unavailable but...
08-26-2012 03:33 AM
Phil Go to last post
6 74
Hello, Do I still have to use the .mdw file to run security for the accdb? I can't find how, but my old mdb will still prompt for a user/password...
08-25-2012 06:32 PM
Access Developer Go to last post
7 80
Anyone familiar with VB.Net? I have some code I need to convert from VB.net to VB or VBA (I will be using it in Access 2010). The code is to upload a...
08-25-2012 11:03 AM
Neil Go to last post
3 61
In a strict sense this is not a question about Access. However the problem has arisen from my own VBA code within an Access program and readers of...
08-24-2012 12:07 PM
fearless55 Go to last post
2 63
Hi everyone, I'm a bit and want to make sure that the percentage calculation result the same between Excel and Access 2007. I notice that Excel get...
08-24-2012 11:10 AM
Gene Wirchenko Go to last post
2 60
If I write a statement lie If 1 = 2 then Debug.Print "Fail" Endif Access will magically split EndIf into two words; End If. Not so with EndWith or...
Patrick Finucane
08-24-2012 09:49 AM
Keith Go to last post
2 79
This is puzzling me. I have imported an old mdb into an accdb and the customised menu came with it. I can now no longer find a way to remove this. ...
08-24-2012 08:40 AM
fearless55 Go to last post
1 74
Are there any function in Access like VLookup in Excel that solve intervalproblems? If I have a tabel with lots of numbers and want to lookup...
08-24-2012 04:39 AM
David Hare-Scott Go to last post
1 70
Got a little subform that lists account balances by Trading Account. It's just a form with .RecordSource = Each "Trading Account" has a...
08-22-2012 08:05 AM
(PeteCresswell) Go to last post
3 75
I'm trying to create a query that will pull the highest exam score for a given exam. My fields are StudentID (unique), Exam name, Exam date,...
08-17-2012 09:10 AM
Sheldon Go to last post
4 83
Sorry for the long post, I get the basics of SQL but when it get to joins, adding, summing etc I getvery lost very quickly, I just canít get my head...
Brian .
08-16-2012 01:14 PM
Brian . Go to last post
6 103
Normally I know this is stupid and BAD database design but its a lot of linked tables they are not in the database. There are 14 linked tables that...
08-16-2012 07:40 AM
The Frog Go to last post
4 72
I have tables linked to an archive. I have a query built with parameters that prompt the user for input. I receive the following error after input...
08-16-2012 06:13 AM
bsn Go to last post
1 78
I have done a fair bit of testing, but I am still getting to grips with theAccess/SharePoint combination. I understand that I can create two basic...
Paul H
08-15-2012 03:36 PM
Albert D. Kallal Go to last post
1 70
In the course of this year 2012 some Windows update was installed (it couldbe a 2011 update as well, because I was several months late with...
Martin Nagy
08-13-2012 04:54 PM
martin.nagy.sk@gmail.com Go to last post
1 116
A client using Access 2007 called this morning to report that when the database opened, a message came up warning that the form "Opening Screen" was...
08-12-2012 10:04 AM
Patrick Finucane Go to last post
1 72
Access 2003 Got a form that I am using as a sort of modal dialog. Only Form Header is shown to the user viz: http://tinyurl.com/8h5tq9b Problem is...
08-11-2012 04:54 AM
Rob Parker Go to last post
1 94
On Tue, 7 Aug 2012 04:36:22 -0700 (PDT), michaelnoshea (AT) gmail (DOT) com wrote: Which font is that? We do not see what font you typed in. I...
Gene Wirchenko
08-09-2012 04:21 PM
Phil Go to last post
1 56
Hi, I have a form that has an image control on it. I set it's control source to a field in a table (which contains it's location i.e....
08-09-2012 04:21 PM
Phil Go to last post
9 95
Post New Thread

Display Options
Showing threads 451 to 500 of 35051
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.