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     
No current record. (Error 3021) This error occurs after the unsuccessful application of one of the Find methods or the Seek method, when the...
08-25-2009 02:28 PM
Steve Go to last post
3 48
Hi All, I am attempting to run an event after each key stroke within a text box. The end result would be a text box that a user enters a...
08-24-2009 09:36 PM
DeZZar Go to last post
8 47
I know that there has to be an easier way to set this up than to create an individual query for each timekeeper, but my trial and error has had...
08-24-2009 06:14 PM
MGFoster Go to last post
3 53
hello, please humor my lack of knowledge as I am very new to access. basically: i want to build a database that appends data to the end of certain...
08-24-2009 04:21 PM
Rich P Go to last post
3 43
I cannot add or edit to my form, nor select from the combo boxes on my form. Here is the code behind my command button that brings up my form via...
08-21-2009 04:21 PM
Larry Linson Go to last post
2 51
Hi. I'm trying to combine two spreadsheets. One is a list of company names. The other is a list of revenue from those companies, with the district...
08-21-2009 04:16 PM
Larry Linson Go to last post
3 66
I have a report menu that only the manager should be able to see, I have a main menu for all the other staff, then I report menu that the manager is...
08-21-2009 01:53 PM
bobh Go to last post
2 72
I have a Form with a Subform placed on a Tab Control. The Tab Control has a button on it that brings up a dialog box that I use to enter a new...
08-21-2009 01:42 PM
Salad Go to last post
1 66
Some time ago there was a thread on Best match for names. I would like to read the discussions again, but I can not find it any more. Can anyone...
08-20-2009 04:31 PM
hbinc Go to last post
5 55
I have a manufactured date field and I want to extract the year and month from this date and put them into 2 other fields I have...
08-20-2009 06:03 AM
Bob Quintal Go to last post
3 101
Hello Access brethren.... I've searched far and wide for a VBA routine/module that can extract text from a specified web page into my dbase (just...
08-19-2009 10:22 AM
Rich P Go to last post
3 69
I'd like to find out if a record was entered within the last 3 seconds, thought, the query would be like select col1 from tblA where 1=1 and...
08-18-2009 09:08 PM
Don84 Go to last post
12 88
We use an Access database to issue purchase orders. I split the tables into a separate database that is on a shared network drive as well as...
08-18-2009 07:33 PM
Larry Linson Go to last post
7 252
Hi, The given field is of memo type, and it's Access 2000. running an update query generates this error, data are less than 500 characters but with...
08-18-2009 04:48 PM
Don84 Go to last post
2 70
Using A2003. I've got a query where I want to pull a range of people's last names. So if I want last names that start between "ma" and "mi", my...
08-18-2009 11:11 AM
JustBoo Go to last post
3 79
This question should be an easy one to answer. I have a form (frmReports) that includes a list box (ListBoxRpt), a filter selection combo box and a...
08-18-2009 06:15 AM
Rolan Go to last post
4 58
this is not an Access specific question but i've participated in discussions on and off in this forum throughout the years and now there are lots of...
Ted Theo
08-17-2009 10:38 PM
Larry Linson Go to last post
2 67
I'm getting this error: 'Run-time error -2147217913 (80040e07) The conversion of char data type to smalldatetime data type resulted in an...
08-17-2009 09:29 PM
Tony Toews [MVP] Go to last post
4 73
Hi, I'm trying to deploy an Access DB that sync's with our SharePoint server - all is fine with the full version, however Access 2007 runtime doesn't...
08-17-2009 12:36 PM
Simon Go to last post
2 62
I have a (primary) form, continuous, similar to a log that presents some records. I can then filter this list to a smaller set. That works...
08-16-2009 08:41 PM
Salad Go to last post
7 92
I am working on a report that has a subreport in the page footer. The subreport adds blank lines at the bottom of each page.The...
08-16-2009 01:10 PM
Larry Linson Go to last post
2 73
I'm a Newbie having a bit of a problem with some code I'm doing. I'm trying to convert numbers into base 10, but the code is throwing up some...
08-16-2009 12:55 PM
Larry Linson Go to last post
16 120
Hi All, I've done a fair bit of searching but haven't found anything that can help with this specifically. I want to extract a persons First name...
08-16-2009 12:12 PM
Larry Linson Go to last post
3 74
Hi, Say I'm using Access 2000. I create a data source for a web app for db connection between the db and web app via a web server. Would this web...
08-16-2009 11:52 AM
Don84 Go to last post
2 86
OK getting the user to confirm changes to a form is easy: Private Sub Form_BeforeUpdate(Cancel As Integer) Select Case MsgBox("Do you want to save...
Paul H
08-16-2009 11:45 AM
Larry Linson Go to last post
3 50
Is the storage space requirement of a text field determined by the field size that has been set or by the actual amount of text stored in the field?
08-15-2009 09:01 AM
Allen Browne Go to last post
3 79
Hi all, MS-Access keeps changing my original sql if I switch to Query Design View mode. Is there any way to prevent this? It is combining...
08-14-2009 09:01 PM
Bob Quintal Go to last post
3 52
I have a document (.doc) inside the same folder as my DB. I have a table that stores the file path to this document. This DB is accessed by other...
08-14-2009 03:04 PM
Bull Go to last post
2 79
I have a OLEBound10 box. I am trying to put an event procedure in the double-click event to automatically insert a blank Courier fonted WordPad...
08-14-2009 01:33 PM
Bull Go to last post
2 70
Hi All, I inherited an AccessXP database that is not 100% normalized and I can not do anything about that. For a report that I am adding to this db...
08-14-2009 09:19 AM
bobh Go to last post
5 76
I am trying to extract 6 lots of information about fonts for subsequent formatting of different areas of a report. I need such things as the Font...
Phil Stanton
08-14-2009 04:20 AM
Phil Stanton Go to last post
1 58
Stuck with this one! Have a form which the user enters the first x number of characters for a stock code and presses search, this opens frmstockheld...
08-14-2009 03:15 AM
BobbyDazzler Go to last post
9 96
Can I make a copy of an access database so that I can do bug fixes while the original database is still being used, and later merge the fixes to the...
08-14-2009 03:10 AM
Dewey Go to last post
2 72
I'm trying to compact a database backend using the A2007 runtime. I'm doing this by closing the frontend then automatically opening the backend. ...
08-14-2009 03:04 AM
Tony Toews [MVP] Go to last post
5 56
ACCESS 2003 FE / ACCESS 2003 BE My clients are worried that their data may be corrupt. They have noticed that two of their records share the same...
08-13-2009 05:55 PM
Edward Go to last post
4 58
i am trying to use the .FindFirst method in a recordset. however i keep getting a 3020 error? in my code below; i open a recordset with the...
08-13-2009 03:11 PM
bipin Go to last post
10 155
I have a data table of approximately 10000 records that was originally an amalgamation of data from several similar tables from separate databases. ...
08-13-2009 01:28 PM
Wayne Go to last post
4 90
Apologies but my post a few moments ago omitted the code I have so far. Here goes:- Dim strMsg As String Dim StrBody As String DoCmd.OutputTo...
Vet Tech
08-13-2009 04:59 AM
Mr.Frog.to.you@googlemail.com Go to last post
6 58
Hello, I'm trying to if the period is "Monthly" I want the field Price Amount to be multiplied by 12 and if the filed is Annual to just enter...
08-13-2009 03:00 AM
DeZZar Go to last post
7 81
I am trying to do a crosstab report. Can create a report that shows the correct number of columns to suit the underlying query. The underlying...
Phil Stanton
08-13-2009 02:58 AM
Phil Stanton Go to last post
4 69
I've been away from Access programming for a while now, but I have a client who wants a little bespoke contact management system set up. I propose...
08-12-2009 10:47 PM
kate Go to last post
7 118
hi Bob, bobdydd wrote: MsgBox ExtractValue("Item name", Me!) Public Function ExtractValue(ATag As String, _ ASource As String _ ) As Variant
Stefan Hoffmann
08-12-2009 10:45 PM
kate Go to last post
4 212
My boss wants me to pull the user's Usernames from their login screens and when a user adds or edits a record that the user's Username will be pulled...
08-12-2009 05:53 PM
Bob Quintal Go to last post
6 47
1)How do I get my field, Date Last Updated, (Date/Time data type) to update automatically on my form header, after a record has been added or...
08-12-2009 09:17 AM
zufie Go to last post
4 64
Environment: Acess 2003 with security via MDW file. A person would like their app to be run via the scheduler in the nighttime. This seems fairly...
08-12-2009 02:10 AM
Salad Go to last post
9 86
I link to my PC at the client site using MS's Remote Desktop Connection and do some Access development work. If I am connected to the remte PC, I...
08-12-2009 12:53 AM
Tony Toews [MVP] Go to last post
13 113
This seems like it should be easy, but I'm not finding an answer, so I'm hoping you Access Gurus can help me out. Running Access 97 Need to...
08-11-2009 11:57 PM
fredg Go to last post
2 76
I'm not sure I follow. The code I posted is a function and that's what I'm using and that's throwing the error. I must be missing something....
08-11-2009 02:56 PM
Roger Go to last post
1 57
Using A2007. I've developed a report where the user can choose 1 or more study types from a listbox. The report will then print data for just those...
08-11-2009 12:22 PM
emanning Go to last post
4 37
I have a database that initally load business information. There are a number of other related forms loaded when a button is pressed. When I load the...
08-10-2009 06:10 PM
Duncan Go to last post
1 79
Post New Thread

Display Options
Showing threads 2451 to 2500 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.