Sponsored Links

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

Page 47 of 820

Threads in Forum : comp.databases.ms-access

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
access97, sql server 2005, workspace transactions using a local table in access97, the debug.print's in this code will show null and PET039 in the debug window Sub wLocal() Dim wrk As... Roger	08-10-2009 03:48 PM Roger	0	47
Send Weekly And End Of Month Automatic Emails A user of one of my databases wants to send reminder emails on a weekly and end of month basis. I have the emailing sorted and am now thinking of... Wayne	08-10-2009 11:39 AM Wayne	3	57
Writing text w/ Lebans picturebox project I am using Stehen Leban's picturebox (http://www.lebans.com/ imageclass.htm) to draw images on an Access form (Stephen, if you read this - wonderful... wazdakka@twcny.rr.com	08-10-2009 11:12 AM hbinc	1	57
SetFocus / SelStart results in highlighting contents of destination I use the following code to jump top the end of a text box contents: Me.Solution.SetFocus Me.Solution.SelStart = Len(Me.Solution.Text) The problem... AA Arens	08-10-2009 08:31 AM hbinc	6	42
find the record with the closest value to [var] Hi, I have a table with various weight values, increasing in steps of 1000 grams. I'll be calculating the total weight of a customers shopping cart... hill79	08-10-2009 04:04 AM hill79	1	55
A2007 Runtime Switch Does opening an A2007 database using A2007 and the /runtime switch simulate the condition of opening the database using the runtime only? What I am... Wayne	08-09-2009 05:31 PM Tony Toews [MVP]	5	51
Sum of hh:mm:ss ( 1 2 ) Our call logger keeps track of the duration of each call in terms of hours:minutes:seconds. I import these rercords in to A2003. I want to arrive at... Vet Tech	08-09-2009 04:29 PM hbinc	10	136
Database corruption? Some users have created an Access 2003 database which has run into problems. At the moment I'm unable to open the db as it's giving the following... Mo	08-09-2009 02:21 PM Tony Toews [MVP]	3	92
Fixed Assets / Depriciation System I've been asked to develop a Fixed Assets System for my company which can maintain a history of all assets and automatically calculate... Prakash	08-09-2009 04:10 AM Phil Stanton	1	58
Cursor appears under field edge. I use the command to go to the bottom of a text field. Private Sub cmdGoDown_Click() Solution.SetFocus Solution.SelStart = Len(Solution.Value) End... AA Arens	08-09-2009 12:16 AM AA Arens	2	39
Macro to Link and Unlink Tables I would like to run a macro that will 1) Allow the user to select a database to link to 2) Link to all the tables in that database 3) Run some other... Craig	08-07-2009 09:35 PM Larry Linson	1	69
access97, form gotFocus event per the documentation, this event is triggered when the form gets focus... so if I start ms-access and open the form, the event triggers if I now... Roger	08-07-2009 03:25 PM Roger	8	81
Webpage in access Can I open a webpage like google.com within access. Then fill in the search text box and click on search? Can I have access VBA do all this for me?... Ken	08-07-2009 07:24 AM BobbyDazzler	6	86
Invoice due date and february... Hi everybody, I am building a database for a client and one the things I need to do is calculate some invoices due dates, ex.: Invoice date:... lupo666	08-07-2009 04:36 AM lupo666	8	36
Linking MS Access into Documentum I posted this in the Public google group, I meant to post here, so I'll do that too: Does anyone have any experience in linking into a Documentum... lukethegooner	08-06-2009 03:22 PM Salad	1	65
Access Query & VBA work together? I have a table that contains shipping information. I need to write a query that will return multiple identical rows for each line based on the and ... Terry Olsen	08-06-2009 11:25 AM Salad	1	59
Late binding issue with Excel Hi Everyone, I am having a problem with late binding and opening an Excel workbook. The code (posted below) works fine for workbooks that dont have... The Frog	08-06-2009 10:54 AM Mr.Frog.to.you@googlemail.com	9	87
Attach file to Email I have a bit of VB code that outputs an Access table to C:\Temp in the form of an Excel file called Export.xls. It then opens up a new email with... Vet Tech	08-06-2009 02:16 AM Phil Stanton	1	52
Code to Create a Dated Blank DB for Exporting I’m working on a project where we will be gathering data at a couple of locations. Unfortunately due to legal restraints we can’t use remote... Craig	08-06-2009 12:16 AM Salad	5	57
What's Happened To The Group History? Maybe I'm doing something dumb but: I access this group through the Google Group "comp.databases.ms-access". For some reason I am only seeing very... Wayne	08-06-2009 12:11 AM Wayne	7	54
How to display days and time difference between two values? On a form, how to display the difference in days and time between a date / time value stored in the table and the existing date / time. Bart AA Arens	08-05-2009 10:36 PM AA Arens	2	54
Question on Treeview There's an application I inherited that has a tabbed page form and a treeview. The tree view items are about 40 and the prior developer opens up all... Salad	08-05-2009 06:23 PM Rich P	7	84
table field in vba Hi All, In AccessXP I have a table and in that table I have several fields with names like FLPR-Q1 thru FLPR-Q10 when I write this in vba code to... bobh	08-05-2009 01:14 PM bobh	5	67
if then statement opposite of logical condition i have a fairly straight forward function that i am using to generate a starting point for my reports. here is the code: Function CurrentStart() As... bipin	08-05-2009 01:03 PM Larry Linson	6	46
using spell check Hi All, In AccessXP I have a form that as several textboxes on it and I wanted to check the spelling of one of them so I added this vba code in... bobh	08-05-2009 09:25 AM bobh	0	72
Can't get Enter Parameter Value boxes to disappear! I have a query that returns every fifth record after clicking a command button. The query returns the correct number of records, but an... zufie	08-05-2009 08:52 AM Krzysztof Naworyta	2	43
Dismissing form after opening another form, re-appearance afterquitting I tried to look around but could not find: A feature that dismisses the main form after a pushbutton click on that form that opens a second... AA Arens	08-05-2009 07:12 AM Krzysztof Naworyta	5	49
Help Needed - Printer Will Not Print In Color I've spent half the day on this and can't make it work. I'm using A2003. I have a report on the screen in print preview mode. Using a button on a... Wayne	08-05-2009 12:25 AM Wayne	0	28
"is not a valid name. Make sure... I just started getting the error message: "is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is... AndrewBerry	08-04-2009 10:44 PM Salad	3	68
Two comboboxes: make it possible to avoid two same values I am busy with a helpdesk database and the calls form has (beside several other fields) two comboboxes: 1st line and 2nd line support, both taking... AA Arens	08-04-2009 09:17 AM Wayne Gillespie	6	46
Search "Source Code" Is it possible to programmatically search the code behind the forms, reports and modules in Access? Thanks. Vincent Vincent	08-04-2009 08:53 AM Salad	1	61
Recording Multiple users, default authors and public variables I am looking at ways to record users logging into the database. Currently there is no log on requirement. I am looking at having User Id and password... Duncan	08-04-2009 08:38 AM Ron2006	2	58
Dcount in a query I am trying to get my Dcount Mod5 in my query to return every 5th record. Here is the: Field Name: Expr1: DCount("","IBCCP Referral"," <= " & ) Mod... zufie	08-04-2009 02:06 AM Phil Stanton	1	79
combine setting values in Update query statement Hi All, I am attempting to create an auto update feature within a current database. Its a database that logs training for registered... DeZZar	08-04-2009 12:56 AM DeZZar	3	25
How to calculate day/time difference between Record=New and frambutton was pushed down I do have three buttons within a Frame, one at a time can be active (push down). I do have a field that mention the date and time a new record was... AA Arens	08-03-2009 09:52 PM AA Arens	0	41
check if record exists before entering new record I have a table (tblCheckDates) with Date, Location and Name in it. I have a form for entering the Date, Location and Name. In the code I have... RCGUA	08-03-2009 08:58 PM RCGUA	2	38
renaming tables I have an Access 07 database with several tables that need to be renamed. When I rename them, all objects associated with the tables refuse to work... Ryker	08-03-2009 04:23 PM Ryker	0	59
VBA with an MS Chart in an Access report Hi All, I've got a report in Access that has an unbound OLE chart that is getting it's data from a query. The chart and information shows just fine,... kevinfbutt	08-03-2009 03:04 PM kevinfbutt	0	55
find start and end dates from group of consecutive dates Can anyone help with writing a query to find retrieve the start and end dates from a group of dates. For example a record in the table the data will... RCGUA	08-03-2009 09:50 AM RCGUA	2	48
Keep Together The detail section of a report consists of a subreport. The detail section subreport consists of a record and another inside subreport. No matter how... Steve	08-03-2009 04:29 AM Keith Wilby	1	80
How to reduce the response time Dear reader, I have an Access application which working with a Front-end and Back-end. In case Front-end (program) and Back-end (data) runs on a... Simon	08-02-2009 09:58 AM Salad	1	79
How to pre-set search dialog box settings? I have a form. How to add code so that a default find-record button upon activating directly: - set "Look In" to the right column of the table -... AA Arens	08-02-2009 03:14 AM AA Arens	0	48
Looking for feature to make report based on chosen combo box value I am looking for a description on how to make reports based on chosen values on a form. I know how to make a report and with a query to make a report... AA Arens	08-01-2009 09:55 AM AA Arens	4	23
Cannot make Textboxes gray (unabled) I can make Toggles and Command fields gray but it failed with text boxes. Why? This is a sample of my code: If Nz(Me!Combo154.Value, "") = ""... AA Arens	08-01-2009 09:46 AM AA Arens	4	41
Form button code that deletes value based on field that is focused I am looking for a way to delete the value from either a textbox or combo box by a button on a form and the action to delete applies to the textbox... AA Arens	08-01-2009 09:30 AM Salad	4	54
Help. Combo value change has no effect of depending 2nd combo I do have a three Comboboxes on my form. Two last are depend on the first. This is the code in the afterupdate of the first combo: cboRS1 = "... AA Arens	08-01-2009 02:01 AM AA Arens	0	54
Getting the First Record For A Particular Field To bring my question down to the simplest case - I have a table with two records and two fields. The field names are FirstName and City. If record 1... Sheldon	07-31-2009 12:09 PM Sheldon Potolsky	6	41
Create alert if text from combobox needs to be added in textbox, butcombobox value is not set I have a push button that adds the value from a combobox in a text box. How to get an alert (message) if the value in the combobox is not set... AA Arens	07-31-2009 06:58 AM paii, Ron	5	32
Access on a PDA ?? I've written a billing system for a restaurant in Access 2003 for which data entry is performed through the keyboard. The Restaurant Owner is now... Prakash	07-31-2009 12:23 AM Tony Toews [MVP]	3	65
expand form size and move controls into the expanded section Hi All, I am trying to create a button on a form that will increase the form hieght and then move a group of buttons into the newly expanded section... DeZZar	07-31-2009 12:18 AM Tony Toews [MVP]	5	42

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