Search results for query: *

Can anyone help me please? I have been running a report (company sick) for several months but have been manually changing the fields to suit the current month! I would like to set the report up ONCE and then have some code which will dynamically change the fields on the report. Eg. In...

I don't know how to explain this in simple terms - but I will try... I run a report monthly based on data received in Excel. There are several queries, all of which do the same thing every month, but I need to change a field to recognise the newest month. Is there any way, either in queries...

Hi. I am hoping someone will understand what I am looking for below. I have a linked table with GPS tracking data for vehicles. I need to produce a bar graph which shows the total time (calculated from last ignition off - first ignition on) divided into productive and non-productive time. I...

Hi. Wondered if anyone can help me. I have a feeling I need the "Do While..." To give the overall picture, I have a table which contains GPS tracking data. I need to be able to work out how long the vehicle was stopped at all the locations visited so I can create a bar graph showing...

(Access 97)I have a listbox for parts and would like to be able to open a report based on the selected part(s) and for the life of me cannot do it! I was hoping to have a command button which would open a report based on the selected items. I have tried looking at several pieces of code people...

We are trying to link a subreport to the main report by doing the following. Identify a character in a text string and link the subreport with everything to the right of that character. Example. Main report has field [location]. Value = V546 Subreport has field [job_account]. Value = 4 S >...

I currently have a sick report that reports on 13 months of data. The information is provided to me monthly in Excel, which I import into Access and append records to existing table. I then modify the report each month to drop oldest month, include newest month and re-total the total column...

I currently have 3 tables - one with week (WW) (1 - 5), one with month (MM)(Jan - Feb) and one with year (YY)(2003 - 2010). I dare say there is a better way... What I am trying to do is generate a unique code (and store in a table) which concatenates YYMMWW for every possibility. ie: Year...

I have an unbound form which the user selects criteria for a report output. If the user enters a 7 digit number in TXT_Parent (an unbound field), I want to be able to check if the first 4 digits match any of the records in a table (TBL_SelCon) which is used for a (hidden at the time) combo box...

Can anyone help please? To generate a Job Transaction report, the user is asked to select certain criteria. First they select the reporting period, which determines which Make Table query is used. Then they select the output option (Cost$, Sell$, Both$ or No$). The report has 2 subreports on...

My database has a front end (loaded on users PC) and a back end (loaded on server). To be able to update the user database with changes to objects I use the ReplaceObject function and list the items to update. When the update has finished, an email is sent to my mailbox so I can keep an eye on...

I can see how to make all tabs 'Bold', but would like all tabs to be normal font unless the focus is on it. Can this be done at all? NKA The answer's always easy - if you know it! ;-)

I think I am in deeper water than I should be here and am hoping some smart cookie can help! Without wanting to confuse anyone, I have tried to create a picture to show what I need to do: > Open Database (display switchboard) > Select A. or B. Both of these selections open the same form...

I don't really know where to start with this one guys and gals! I have an unbound field (txtjob) on an unbound selection form. I run a query based on the value entered in (txtjob). The criteria is as follows: >=UCase([txtjob]) and <=Ucase([txtjob]) & 'z' and works a treat. However, I would...

I am pulling my hair out over this one and am now waving the white flag! I have a combo box which is populated from a table. The combo box is for [Priority]. I would like to populate the [TargetDate] automatically based on the date the job was identified and the priority. ie; a High Priority...

I have a combo box which looks up values from a table. This combo box has 2 columns, the first being the bound column (and is based on autonumber). When opening the form, I would like the combo box to display the text &quot;Select&quot; or &quot;Choose&quot; - without having to add it to the...

I have a sick report which is provided monthly in the format of Excel. Names down the column and Months across the rows. However, the months roll over a 13 month period - a new one added to the beginning of the months and the last one dropped off the end. The data is imported into Access so a...

Apologies if this has been answered already - I have spent over an hour looking at several options, but cannot find the one I need! I have an unbound combo box on a form. The rowsource is data from a table. I am displaying &quot;choose...&quot; when the form is first opened (variable). I...

Can anyone help? Our hard drive fried last week, so have bought a new one. Have installed Windows XP - so far so good... The PC's original configuration included a DVD ROM (we later installed a CD-RW). When XP boots it doesn't recognise the DVD - but is displayed in a list of...

Scenario: Several users have a db which which sits on their C: drive. There are linked tables in this db which link to an Oracle db. Any db updates are carried out on the 'development' db (networked drive) and objects to be updated are entered into a module. The user can at any time, select...