Search results for query: *

Hi all, Having a little trouble on one machine with an issue which doesnt arise on others. I have a report which I want to (using VBA) e-mail directly after editing the message text. Works fine on one machine, but on another, the Email edit window opens up with the report file attached, and a...

Hi Guys & Gals, I have just bought an external hard-drive, initially as a back-up device, but now want to use it as my main data store, and back up to one of the pcs that I use it on. Before I start what I imagine (with my limited capabilities) will be a mammoth task, I just thought I'd ask...

Hi, I have written a data visualisation tool which lets the user, see data displayed graphically utilising a number of parameters. I have been asked to provide a facility whereby the user can create there own report, and print out a number of the paramatised graphs at once. What I was...

Hi all, I have an application running stand alone on four separate machines to cpature research data. The main capture form (unbound) captures all details regarding the subject matter and then a button opens an append query which transafers all the captured data to a table. On 3 of the...

Hi all, Not sure where this one sits really but here goes. My office in a business centre got broken into recently (no alarms went off huh ?)so I want to develop a card security system which permits/tracks entrance and egress to/from the building. Access can obviously handle the data side of...

Hi all, I just wondered if there was any way that I could produce a multiple report ( i.e. one which covers many individual standard access reports) under one cover for e-mailing to different regional offices. (not sure if I made that one clear). Essentially, I have an MIS which imports...

Help ...please I have searched through previous questions but can't find any reference to this problem. On opening my continuous form the vertical spacing of the detail section isn't constant, it increases record by record. Also if I scroll up and down the records kind of merge and get...

Can anyone help with this. This coding is to import a spreadsheet into an existing table and stripout any erroneous data. It works fine on normal version of access (win XP MsA2002) but when I package it with the runtime version and deploy on a single user machine, I get an indiscriminate...

Hi all, I was just wondering whether its possible to have a control in the detail of a continuous form which keeps a running total of another field I would imagine not but would appreciate anyones help. Regards Phil.

Hi there, I recently upgraded to Office Developer, and was wondering about how it deals with split databases. If I were to deploy a split db to a site in normal instances I would map a drive to the back end and set up the front end master to link to it. My concern is that with the packager...

Hi all, I've written an application which may (or may not) have some commercial value. My concern at the moment is a way of preventing unauthorised copies of the front end being made at potential customer sites. I was thinking that if I put a field in a backend admin table which increments as...

Access2002/winxp Hi all I’ve produced a report based on a query and one of the calculated cfields in that query [charge] is in a currency format The report has various groupings but when I put the field =sum([charge]) in any of the grouping footers, I get the error message “Data type mismatch...

Hi all, Tried to look this up in keyword search but kept timing out so here I am. Using Access 2002/winxp (though I know this has nothing to do with my problem) I have created some calculated expressions in a query for use in a report. eg Palls...

A no-brainer I'm sure but could anyone possibly tell me why this for next loop appears to be getting ignored For TransCounter = (TransCount + 1) To 0 TransArr(Colnum, TransCounter) = TransArr(Colnum, TransCounter - 1) Debug.Print TransArr(Colnum, TransCounter) Next...

Hi there, I know this is going to be a no-brainer, but could anyone tell me why the following code produces a record count of 1 rather than 4 (the number or records in the table) Many thks in advance Phil. Private Sub Command141_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set...

Hi there, tried this in the queries forum with no joy, wondered if anyone here could help.... I am wondering whether I can dynamically update a query (standard access, not SQL) dependendent on a certain form being open. Essentially if said form is open when the query is processed, I wish to...

Hi there, I am wondering whether I can dynamically update a query (standard access, not SQL) dependendent on a certain form being open. Essentially if said form is open when the query is processed, I wish to use a value from the form as a criteria. However if the form is not open, I do not...

Using the query design tool, I have developed a query which contains a number of expressions as fields which are based on calculations using fields in the tables queried. i.e. totcosts: = [rawmaterial]+[manufacture] where another expression might be rawmaterial : =[stock]+[delivery] (real...

Hi all, I have a continuous form with a header which uses one third of the screen and a detail section which covers four or five lines. When I use the scroll bar to move through the records, the detail section jumps one record at a time (fairly reasonable I suppose). I just wondered if there...

Hi all, I tried to open one of my applications this morning and got the following error message "Cannot find the file "Mydb.mdb" (or one of its components). Make sure the path and file name are correct and that all required libraries are available" Now I know the path and...