Hi there, Had a chance to explore the problem a bit now and my conclusion is that your fastest way to move your processes to a relational...

noodnutt

Yesterday 01:20 PM
noodnutt

Hi Guys I almost have this working to my liking, Almost! I have the following statement: If Me.snfStatus.Value = 2 Then Set objOutlook =...

noodnutt

Yesterday 12:41 PM
noodnutt

I'm confused.... I though this web stuff was supposed to be getting easier,but there is absolutely nothing out there on how to "consume" a web...

grant@technologyworks.co.nz

05-16-2013 07:15 PM
grant@technologyworks.co.nz

I would like to have a running sum by month (perhaps in a crosstab) Jan Feb Mar Apr... 5 8 15 21 If Febs result of hours...

kolsby

05-16-2013 12:03 PM
kolsby

Hi, hope someone can help. Struggling with this. I have designed in MsAccess 2007 a Reports to print Labels 3 across. Each label will have a...

harrissteinman@gmail.com

05-15-2013 04:20 PM
Harris Steinman

Hi Everyone, I am working on retrieving some data from webpages to use in my applicationand this is done by stripping the required contents from the...

The Frog

05-15-2013 07:16 AM
The Frog

miaojpm (AT) gmail (DOT) com wrote: Any relational database can handle this. Whether 'R' qualifies I cannot say knowing nothing about it. Keep in...

David Hare-Scott

05-14-2013 04:38 PM
Aikistan

Clients want to use my access database on a MAC or IPAD. Some have been told that it's now possible. Does anyone know whether there's an...

Nance

05-13-2013 10:49 AM
Access Developer

Here is an example: The following URL creates a file name...

Jürgen Meyer

05-13-2013 10:48 AM
Jürgen Meyer

Hi Everyone, I am working on another wonderful chunk of code that strives to age me wellbefore my time. In short what I am trying to do is to create...

The Frog

05-13-2013 04:39 AM
The Frog

Hi everyone. I am having a problem that seems to resist logic. I am using the html document parser from ms which is being passed an html document...

The Frog

05-13-2013 03:25 AM
Phil

Porting a form from 2003 to 2007, it has started throwing "Enter Parameter Value '###.000'" when opened. I've searched the form and it's underlying...

(PeteCresswell)

05-12-2013 09:49 AM
Phil

I have a sendemail data macro which works in a local file (backend database) but will not work in the front end database. I have tried both named...

Mjbjer333

05-10-2013 02:40 PM
Mjbjer333

I have a table (ID, NewValue) I would like to merge all records with the same ID in to another field.....is this possible

rwpearson@clear.net.nz

05-10-2013 10:36 AM
Joan Wild

I'm finally forced to migrate my first production app from 2003 to 2007. All my apps use the /INI parameter on the command line that...

(PeteCresswell)

05-10-2013 09:19 AM
(PeteCresswell)

I have notice Microsoft provide 2 verions of guildline to customize Access Ribbon, one for version 2007, other for...

jasper2virtual@gmail.com

05-10-2013 04:36 AM
jasper2virtual@gmail.com

Seems like a no-brainer on the surface: one less source of potential problems. Will I regret it later? -- Pete Cresswell

(PeteCresswell)

05-09-2013 05:31 PM
(PeteCresswell)

Anyone know of any free or reasonably priced Access POS/Inventory with full source code? Have a nonprofit client in need of such. Found some nice...

BobAlston

05-09-2013 07:55 AM
BobAlston

I think my version of mscomctl.ocx has been corrupted. Can't find a download site for a version for windows XP and Access 2010. My Treeview doesn't...

Phil

05-09-2013 02:59 AM
Phil

Hey there guys Using Excel/Access 2003: I am using the following code to import data from a spreadsheet. One particular column of data is formatted...

noodnutt

05-08-2013 10:39 AM
noodnutt

I has a headache, my question is not pure programming question, I don't know is it belong to the Stackoverflow question. Or it belong to somewhere...

jasper2virtual@gmail.com

05-07-2013 01:57 PM
Patrick Finucane

I'm posting this with an uneasy feeling that I'm missing something very obvious, but here goes anyway. In the following code, vChildCostOff and...

Bob Darlington

05-06-2013 11:39 PM
Bob Darlington

As a workaround for the limited capability of Access' built-in charts, I am trying to use Excel.Chart.8 - which I am comfortable with from...

(PeteCresswell)

05-06-2013 10:25 AM
bsn

I am creating a very, very simple database for the receptionist to record the times when each employee has started working (and stopped working). It...

greg30043@gmail.com

05-06-2013 08:02 AM
Ron Paii

Hi all I have the following snippet that filters my form without a hitch, that is until I dump this form into another. The form name I have it on...

noodnutt

05-06-2013 04:10 AM
noodnutt

I have a form "frmCustomers" on which there is a button which opens second form in to which I insert data. I then open a report based on the data...

rwpearson@clear.net.nz

05-06-2013 02:32 AM
Phil

Hi, I have asked this a couple times but thought I would try one more time because I just lost a sale because my software doesn't interface...

PW

05-02-2013 10:41 PM
PW

Hi All, This is the correct Access2003 syntax for coping the ARWorkFiles folder and all the subfolders and files in those subfolder in ??? This...

bobh

05-02-2013 04:28 PM
Phil

Hi there I'm using Access 2007 and converting my reports to .pdf and emailing. Using the sendobject, sendreport, pdf achieves what I am after,...

rwpearson@clear.net.nz

05-01-2013 12:38 AM
rwpearson@clear.net.nz

I am working on a function to check the type of network connections a workstation is using. I can then warn or even disable an FE/BE...

Ron Paii

04-30-2013 01:57 PM
Ron Paii

Phil, I checked out the website, and wanted to submit an enquiry via the on line support page (no email address given). When I tried to submit the...

Bob Darlington

04-30-2013 02:12 AM
Bob Darlington

How do I set or change a public folders permissions using VBA? Can I do this in MAPI of which I have some experience? Or do I need to use CDO, of...

Paul H

04-29-2013 09:42 AM
Paul H

I'm trying to get multiple pie charts on a single page. I can resize the chart object, no problem: just drag the borders. But I need to...

(PeteCresswell)

04-26-2013 09:33 PM
Rob Parker

Hi: I am being asked to export table data to an XML file. There is a specific format I am being asked to use. The format is an XSD file from...

Patrick Finucane

04-26-2013 07:45 PM
Rob Parker

Hi Everyone, Cant seem to find a straight answer on this and my experimentation is going around in circles. Maybe someone here is able to answer...

The Frog

04-26-2013 09:16 AM
The Frog

I have a zoom box via "DoCmd.RunCommand acCmdZoomBox" How do I increase its default size? Peter

Peter Jason

04-24-2013 10:52 PM
Peter Jason

My ledger has a memo field "Comments" and is displayed in a datasheet, itself in a subform. A text box on the main form displays the content of this...

Peter Jason

04-24-2013 10:40 PM
Peter Jason

I have created a simple Navigation Form with two buttons each pointing to the same form (frmSales). I'd like one button to open the subform in...

KRyano

04-24-2013 10:19 AM
ryanjmohr@gmail.com

My client and I were vexed by speed issues on a database that behaved well on my laptop, but was terribly slow on their network. Also puzzling was...

pemigh

04-23-2013 07:37 PM
pemigh

I have database A (production DB) which has had some schema changes and is now called database B (test environment). I would like to update database...

Barry

04-20-2013 05:59 PM
David Hare-Scott

The problem is a query that is supposed to tell me if there any activity for a specific Jobno/Partno combination. If a both the fields equal the...

BrianDP

04-20-2013 09:32 AM
The Frog

My client and I were vexed by speed issues on a database that behaved well on my laptop, but was terribly slow on their network. Also puzzling was...

pemigh

04-20-2013 06:55 AM
pemigh

Hi Everyone, In the past I have used Ken Getz registry class (Win32Registry) to retrieveregistry keys when I needed them. I am working now on an...

The Frog

04-20-2013 03:10 AM
The Frog

Hi All, In Access2003 I have a bound continuous form, one of the controls is a checkbox. When a user opens the form I want to set the checkbox...

bobh

04-19-2013 09:45 PM
Douglas J Steele

Oh my Gosh, this is so over my head! But I love learning new things. I was thinking all I want or need to do is have the user press a button to...

PW

04-17-2013 05:01 PM
PW

Good afternoon We have an Access database with the Fe & Be on computer 1 and Fe on computer 2 Connected by 80 metres cat5 cable This worked...

David B

04-17-2013 04:42 PM
PW

A client using Access 2007 called to say that she was unable to enter data in a section of the program. I logged on to her computer. When you open...

Nance

04-16-2013 06:21 PM
David Hare-Scott

A client complained that only two people can log on to the database simultaneously. Where is that limitation set? I didn't (knowingly!) set it in...

Nance

04-13-2013 06:57 PM
David Hare-Scott

Hi Guy's I am trying to import a Tab Delimited file, there is around 13 columns of data and have made provisions for the 1st column to be blank so...

Living the Dream

04-13-2013 05:36 AM
Living the Dream

Hi Everyone, Been a while since I posed a Q in here so I thought I'd make it a doozy. I am working with a remote BE (MySQL Server, also MSSQL) and...

The Frog

04-12-2013 10:40 PM
Albert D. Kallal