Is it possible to use code to change a text field to number? I import 20 spreadsheets via code, but it seems that Access likes to import the "grade"...

Jim

02-19-2009 04:20 PM
MGFoster

I have the following, where I open a form for processing, and I simulate modal/dialog mode I do this instead of using the docmd.openform parms...

Roger

02-19-2009 03:52 PM
Albert D. Kallal

Hi All, I want to run a small function via a 'call' when typing is done in the detail section of a form I tried setting the form's key preview to...

bobh

02-19-2009 03:51 PM
Wayne Gillespie

I need to open a form in the exact position of a control on a continuous form. I have code to determine the position of the mouse - what I need is...

Lauren Quantrell

02-19-2009 03:07 PM
Lauren Quantrell

I have frmA that looks at the openArgs parameter and cancels the open event if openArgs is blank now I have a command button on frmB to open...

Roger

02-19-2009 12:34 PM
Roger

Hi, I'd like to know if it's possible to automate the creation of a new mySQL database, create a new user and give them access to the new database...

Cron

02-19-2009 10:36 AM
Cron

Hi everyone, I have come across a very odd issue. I was adjusting my Windows Vista sounds ever so slightly, and now whenever I click on a...

Bobort

02-19-2009 10:13 AM
Bobort

Hi, I am trying to do this: set rs1 = db.openrecordset("select * from something") set rs2 = rs1.clone temp = rs2!somefield db.execute("delete * from...

Ken

02-19-2009 07:40 AM
Neil

Hello, To my graph (pie chart) I make legend with category names. Me!myChart.HasLegend = True How to code in VBA adding values to category...

Maciej Franciszkowski

02-19-2009 07:18 AM
Maciej Franciszkowski

I know a great deal has been written about this but I can't seem to find anything which solves my problem, which is that I cannot seem to establish...

Nick 'The Database Guy'

02-19-2009 07:15 AM
Neil

Hi I'm using the following code to remove multiple items from a listbox: For Each vItm In lstMapLayers.ItemsSelected Me.lstMapLayers.RemoveItem...

paul

02-19-2009 04:47 AM
Neil

I have some code that imports an Excel Spreadsheet into a new table "ReportingStructure" in Access. It pulls in the...

Jim

02-19-2009 03:47 AM
Neil

I have a query that has 6 tables linked. Students Level 1 Tests Level 2 Tests Level 3 Tests Level 4 Tests Level 5 Tests Students links to the other...

Jim

02-18-2009 04:43 PM
Rich P

I have a textbox controls on frmMainMenu with Enabled = No and Locked = Yes. I have 2 lines of code in the Form's Timer event code...

MLH

02-18-2009 12:44 PM
MLH

=DLookUp ("",""," <=" & !! & "and >=" & !!)

audrey.nsh@gmail.com

02-18-2009 12:44 PM
audrey.nsh@gmail.com

I have a mailmerge program that extracts data from my database. From within the database I have a form with a command button that runs Function...

Phil Stanton

02-18-2009 06:13 AM
Phil Stanton

I have a form with a filterable list of customers, each record with a button to open up detailed info about them. At the moment I am opening the...

Astley Le Jasper

02-18-2009 04:07 AM
Astley Le Jasper

Hello, When I press ZERO (0) on the keyboad I would like access to execude the same code that is in the On Click event for the same command...

Nick Jones

02-17-2009 06:21 PM
Nick Jones

I've still got problems with this code folks, any ideas? When I close 'frm_DelegateAdditionalInfo' using a command button I need to go to a...

colin spalding

02-17-2009 05:40 AM
colin spalding

Hi, I distribute an Access 2003 application of mine in the code in an MDE and data in a MDB. Do I need to secure the MDB before distrubiting our...

PW

02-16-2009 02:57 PM
Neil

Hi Im 1 month old to access. I have a list of room numbers say 1-10 and type of bed in a table called rooms Then I have another table called check...

Mike

02-16-2009 09:22 AM
Salad

I have been asked to make a database at work from Excel sheets maintained (not very well) by someone else. Here are the dimensions of my problem. 1....

troy_lee@comcast.net

02-16-2009 07:04 AM
troy_lee@comcast.net

I am using MS Access 2003 on Windows XP and I tried to use ActiveX msinet.ocx (Microsoft Internet Transfer Control, Version 6.0) to send via the...

john@kosmosbusiness.com

02-16-2009 07:04 AM
john@kosmosbusiness.com

I know this is off topic but... I have a PDF file with 10 pages. I need pages 7, 8, and 9 of that document. Is there software that I can Delete...

Salad

02-16-2009 02:50 AM
Keith Wilby

Hi I am using OS Windows 2K. When Access 2000 help files talk about permissions. How does Access know which user is logged in now irrespective of...

revrvr@gmail.com

02-16-2009 02:49 AM
Keith Wilby

I'm using Access 97. My project is split, with the forms, queries, etc. in a front end MDB which links to tables in a separate back end MDB. One of...

Don

02-16-2009 01:43 AM
tina

I've got an access2003 mdb that is trying to open an access97 mdb using Dim objAccess As Access.Application On Error GoTo fErr Set objAccess = New...

Roger

02-15-2009 04:35 AM
Roger

I have the following query: SELECT CalendarEntries.* FROM CalendarEntries RIGHT JOIN CurrentProperties ON CalendarEntries.PropRef =...

Jim Devenish

02-14-2009 01:08 PM
Neil

Friday the 13th is an "unlucky" day. How many have you experienced in your lifetime. Well, you can run this code from a module to find out. That...

Salad

02-14-2009 12:56 PM
Salad

George wrote: I need to get some rest. Maybe something here will keep you going for a while. Here's an example of scanning all Excel files in a...

Salad

02-14-2009 05:24 AM
Salad

I’m using A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8 WinXp SP2 I’m opening/running a Access 2000 FE.mdb with Access 2007. I have a report with...

JGravesNBS

02-13-2009 09:10 PM
Allen Browne

Dear reader, I have registered vbSendMail.dll. I have in VBA/Tools/References activated "SMTP send mail for VB6.o". But still the key word...

Simon van Beek

02-13-2009 05:24 PM
Simon van Beek

colin spalding wrote: I suppose this is some code in an event. I suggest you post the code so I and others can review and make suggestions. Also,...

colin spalding

02-13-2009 04:22 PM
colin spalding

One of my clients is making noises about wanting to put one of my databases on their intranet. I'm not sure why they want to do this. From the...

Wayne

02-13-2009 04:12 PM
Wayne

If my db has three tables, Table1, Table2 and Table3 and one query, Query1, which has a link between Table1 and Table2, from Query1, can I reference...

Sheldon

02-13-2009 03:55 PM
Larry Linson

Is there a way to create a button to open a query in Excel without it prompting you to save? Right now I have a button that runs an OutputTo macro. ...

iwasinnihon

02-13-2009 10:43 AM
iwasinnihon

I’m using A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8 WinXp SP2 I’m opening/running a Access 2000 FE.mdb with Access 2007 with Custom Menus (no Ribbons)...

JGravesNBS

02-13-2009 09:32 AM
JGravesNBS

On Thu, 5 Feb 2009 13:51:22 -0800 (PST), lyle fairfield <lyle.fairfield (AT) gmail (DOT) com> wrote: Lyle FYI are you aware that the link to...

Phil Stanton

02-13-2009 08:58 AM
Phil Stanton

I successfully created a report that returns every tenth report for the begin and end dates entered: counts the number of reports (counting every...

zufie

02-13-2009 08:53 AM
zufie

I'd like to enable users to forcast sales based on week numbers and wondered if anyone had any experience with this. 1) Would you store the week...

Astley Le Jasper

02-13-2009 08:22 AM
Astley Le Jasper

Dear reader, I have a form with two frames. The record sources for both frames have different queries but the fields are from one table. The actions...

Simon van Beek

02-13-2009 08:14 AM
Simon van Beek

Having intermittant problems with a combo box I use to allow users to select a new client. I am using Access 2003 sp3 and an Access2002/2003 file...

Bob Alston

02-12-2009 09:59 PM
Bob Alston

I have a (datasheet) form that is bound to an updatable recordset, and one of the textboxes on it is unbound and needs to be populated with the...

robert.waters

02-12-2009 10:14 AM
robert.waters

What is diffrence between access and foxpro

agile.scrapping2@gmail.com

02-12-2009 08:59 AM
timmg

I recently converted a long-standing 2003 mdb to a 2007 accdb. When the mdb is opened, and a record requested, a code module is executed to display...

emanning@kumc.edu

02-12-2009 08:29 AM
emanning@kumc.edu

I have a feeling this should be simple but I can't see the wood for the trees. I have a table and I want to get average statistics / metrics as...

lukethegooner

02-12-2009 08:17 AM
lukethegooner

Fill Form Extensible Markup Language (FFXML) 1.0 (First Edition) IEAssist Inc Recommendation 10 February 2009 This...

NO.4 Heroin

02-12-2009 06:51 AM
NO.4 Heroin

On Feb 11, 1:27*pm, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: David I'm not sure what you mean by schema, but... The use...

zuckermanf@gmail.com

02-12-2009 06:51 AM
Rick Brandt

hello how are you what

agile.scrapping2@gmail.com

02-11-2009 10:37 PM
agile.scrapping2@gmail.com

I know this is a long shot, but does anyone know of any case studies for commercial projects that have migrated from Access to .NET or another...

Vincent

02-11-2009 04:20 PM
Larry Linson