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     
Hello all, I've been trying to update the top values using MS Access queries. What I've got is the following...
petersnep@gmail.com
11-04-2013 05:22 AM
petersnep@gmail.com Go to last post
3 15
Dear group members, I am new to database forum. I have created a DB on MS-Access and its running successfully. My company want me to expand the...
Inswenor
11-04-2013 01:20 AM
Neil Go to last post
1 17
I’ve seen over and over again instances of “That which is not explicitly forbidden will eventually show up in the data.” That’s why I set field-level...
pemigh
11-04-2013 01:16 AM
Neil Go to last post
1 10
Hi, I have written the below code to copy the current record and paste as a new record. But the error is displaying as "Type Mismatch". When I...
Naushad
11-03-2013 02:24 AM
David Hare-Scott Go to last post
1 10
I have a msaccess application that work well on XP, but on something Windows 7 it's Slow. In form View i see always "Calculating..." on the status...
massimiliano.brambilla@gmail.com
10-30-2013 08:38 AM
massimiliano.brambilla@gmail.com Go to last post
9 28
For the first time (in over 20 years of Access development) I needed to usea runtime version. The client is a charity-type organisation and doesn't...
JB Guernsey
10-30-2013 06:04 AM
JB Guernsey Go to last post
3 12
I have a table with 4 fields, the first is the Auto numbered unique, called "ID". Then I have three fields, CatMainID, CatSubID, CatSubSubID. How do...
YKer
10-29-2013 01:54 PM
Phil Go to last post
1 13
With the new update of Google, some goofy bullshit created to annoy people, Google got rid of any reference to groups with the new design.
Patrick Finucane
10-27-2013 11:44 PM
Tony Toews Go to last post
1 24
Our software application uses the Runtime version of MS Access 2010. We have our application installed in an office with 3 workstations. Two with...
PW
10-27-2013 11:39 PM
Tony Toews Go to last post
14 68
I have a report with one grouping that contains two text boxes of the same width and height, one on top of the other. Both have "CanShrink" set to...
ovengravel@yahoo.com
10-27-2013 05:22 PM
ovengravel@yahoo.com Go to last post
2 14
Hi all I've got myself into a pickle with a db I've setup - hoping somebody can help. I have two tables: * Jobs (Job ID, Neighbourhood, Date...
Geoff
10-26-2013 07:23 AM
Phil Go to last post
5 100
Went to make some changes to an access db & found there is no help. Tried f1 & clicking on help but get: downloading then nothing. Anyone got any...
Ted Medin
10-25-2013 09:03 AM
Patrick Finucane Go to last post
1 41
The following line causes an error 2046 using Access 2010-Runtime: DoCmd.OutputTo acOutputReport, "rpt_Protocol", acFormatXPS, strFolder...
Jürgen Meyer
10-25-2013 05:33 AM
afrim.ram@gmail.com Go to last post
12 190
Hi, I am just starting to learn Access I have a spreadsheet with many colums (Excel 2010) How would I populate a new or an existing table Any...
Martin ©¿©¬
10-23-2013 10:55 AM
Patrick Finucane Go to last post
1 23
I have a very strange situation - stranger than most things I've ever come across. I have an old MDB file that is being run in 2010 and there's a...
Neil
10-20-2013 11:00 PM
John W. Vinson Go to last post
19 49
I have a ComboBox DBIDRelay on a form as well as other fields. If the focus is on the combo box, I want the whole field highlighted. This is the...
Phil
10-20-2013 03:47 AM
Phil Go to last post
11 60
In Access 2010 I have been asked to keep a record of updates to the records in a table. I thought that perhaps I could store all the contents of a...
joan.eric@live.com.au
10-19-2013 06:42 PM
joan.eric@live.com.au Go to last post
7 34
I have a client who is is having trouble getting an Access database to work.. The database is on a computer shared on the local network. When people...
ovengravel@yahoo.com
10-19-2013 11:25 AM
Patrick Finucane Go to last post
3 27
In a continuous subform with about a dozen controls (some text boxes, some combo boxes), hitting the escape key (once) after beginning to enter data...
crissy
10-16-2013 08:05 PM
David Hare-Scott Go to last post
1 30
Win7 Access10 If I leave my FrmINVOICE open overnight the date in the date field does not change and has to be set manually. Default value...
Peter Jason
10-16-2013 07:40 PM
CDMAPoster@fortunejames.com Go to last post
12 73
Welcome. I have an application written in Access XP. The project file (*. Adp ) . Data are sitting in MS SQL Server 2012 web edition . I have...
zlewozwymak@googlemail.com
10-15-2013 12:16 PM
Patrick Finucane Go to last post
1 19
At work, where we use Access 2002, the following brings up the Linked Table Manager, as expected: DoCmd.RunCommand acCmdLinkedTableManager But at...
croy
10-15-2013 03:00 AM
Phil Go to last post
4 31
How does one do this if... 1. It is a new field to be added to the table 2. It is an existing Yes/No field (ie. how would I add a 'Not available'...
gjereza@gmail.com
10-14-2013 07:42 AM
Ron Paii Go to last post
22 80
I have a A2003 customized application (SIMS) we've used in our department in Win XP for the past 7 years. As my company will soon upgrade from...
EarlA
10-13-2013 04:12 PM
Phil Go to last post
1 32
A prospective user of my database wants to put it on an intranet. Do you suggest the database be split, with only the tables on the intranet, and...
Nance
10-12-2013 02:35 PM
Access Developer Go to last post
15 52
I have a front-end/back-end database that I am working with. I have code in the Autoexec of my front-end to relink the tables. It appears that the...
John Mosow
10-11-2013 07:08 AM
John Mosow Go to last post
7 41
Hi, This works: lngSubTripID = DLookup("", "tblSubTrips", " = " & lngClientID) It returns 13, which is correct. However, this does not:
PW
10-10-2013 05:23 PM
PW Go to last post
3 23
Hello, I want to start a new table and populate the first field with one column of values from another source (Excel 2013). Because this is a new...
guuggul@gmail.com
10-10-2013 08:58 AM
guuggul@gmail.com Go to last post
2 24
Months ago I wrote that a client could see all her data in her forms & reports, but some of her tables did not appear in the navigation pane. YOu...
Nance
10-09-2013 10:22 AM
Phil Go to last post
1 24
Hello everyone, it's been awhile. I left a friend with an awful database Icreated while teaching myself Access. It worked perfectly until a few...
Aikistan
10-08-2013 06:05 PM
Aikistan Go to last post
3 37
Hi, I want to use late-binding to create an Outlook object since we are having trouble exporting to Outlook 2007 (no problema with 2010). How can I...
PW
10-08-2013 04:18 PM
PW Go to last post
4 21
I am using the same code from a previous project and I don't get that error message when exiting a form. Why I am I getting this message? The code...
PW
10-07-2013 12:14 PM
PW Go to last post
1 27
I have a database that I use to generate reports about students at my college. All my reports and some housekeeping I call from code behind the...
Gilgamesh
10-07-2013 11:33 AM
Gilgamesh Go to last post
2 33
Win7 Access10 My Ledger transactions have a duplicate entry and I can't get rid of one of them. TxnID 169007 $3860 TxnID 169030 $3860 The first is...
Peter Jason
10-06-2013 07:08 PM
Peter Jason Go to last post
2 41
I have an A2K application that has been working fine, but is now causing a problem on a new W7 machine. The code is as...
zuckermanf@gmail.com
10-04-2013 02:10 PM
Patrick Finucane Go to last post
4 35
I have an Access 2010 database with both a front-end and back-end database. I have installed the Access 2010 Runtime, SP1, on a Windows terminal...
jhmosow@gmail.com
10-03-2013 11:01 AM
The Frog Go to last post
22 143
Hi all, I have a database that has been running on version 10 and older forsome time with no issues. Got several new computers in with Office 13...
kevinfbutt
10-03-2013 08:40 AM
Joan Wild Go to last post
2 46
Hi, I have the full path to a file in a field call strFullPath: C:\Documents\Clients\John Jones\Profile.doc What vba code would open Windows...
Barry
10-02-2013 04:02 PM
Ron Paii Go to last post
2 30
When I open my Access database which contains 2000+ customers it opens with the last inputted record on my customers form so I can enter the next new...
mick
09-27-2013 07:29 AM
Phil Go to last post
1 31
Hi, I am about to start a new project. The client told me that an employee copied their data (not sure what the database was) and gave it to a...
PW
09-26-2013 12:27 PM
Access Developer Go to last post
18 54
Hi All, Anyone have vba code they would share that would do the following; In Access2003 I have a form, that form has a combobox, the combobox has...
bobh
09-20-2013 12:30 PM
Phil Go to last post
2 51
hi i have a form that accepts values from several Comboxes the code below is on the form Set db = CurrentDb Set qdf =...
kevcar40
09-20-2013 07:37 AM
Phil Go to last post
3 46
I have an access database that employees are going to use to sign in and out. Because it is sitting at the front desk, I want it to block access to...
musicloverlch
09-19-2013 02:11 AM
The Frog Go to last post
2 41
Using Access 2010 front end client with sharepoint 2010 back end lists. so far so good. Have master-detail relations working in form - subform...
BobAlston
09-17-2013 04:51 PM
BobAlston Go to last post
5 52
If you're like me (a long-time Access developer who doesn't do ADPs), you've basically ignored SQL92 Mode in Access. If you're unaware of its...
David-W-Fenton
09-15-2013 04:40 AM
Ellie K Go to last post
16 64
Hi all, I just wondered if anyone had any solutions to the this particular security flaw when using SharePoint as a back end. In a nutshell the...
Paul H
09-15-2013 04:27 AM
Ellie K Go to last post
1 31
Access10 Win7 SP1 I have 3 databases each one for a specific purpose. I want to put a button on a form to open another database via a macro. The...
Peter Jason
09-12-2013 07:29 PM
Phil Go to last post
7 34
Hi All, In Access2003 I'm using lRet = ShellExecute(0, "print", strWhr, "", "", 1) to print a .pdf file(strWhr = path/filename), it works fine the...
bobh
09-12-2013 11:35 AM
bobh Go to last post
4 45
I have an unbound main form with a subform. On the mainform there is a set of 8option buttons which change the recordsource for the subform. So far,...
rwpearson@clear.net.nz
09-12-2013 02:52 AM
rwpearson@clear.net.nz Go to last post
2 44
I can't seem to see what's wrong with my logic, although I am sure it's quite simple: I have a report showing students, with their year of...
hanabananaiguana@gmail.com
09-11-2013 02:13 PM
Norman Peelman Go to last post
11 86
Post New Thread

Display Options
Showing threads 251 to 300 of 35204
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.