Search results for query: *

Hi all, I think this should be easy but just think where to start! I have a VERY large file that includes a bunch of clients and the daily value of their account. So three columns: CLIENT, DATE, VALUE For various reasons, the extract isn't run each day so the dates will not be consecutive...

I do this all the time and it has never been a problem! BUT today, when trying to import tables, the field names aren't being brought in. This is despite them being shown in the import wizard. Has anyone come across this before. Have I accidently ticked something. Is it a bug? Is my db safe...

Hi all, I have a spreadsheet with several worksheets that each have a msquery to access various bits of info from an access database. I then needed to change the location of the access file and so programatically changed the sql in each query to access the correct file. However, I now need to...

Hi all, I like the look of DTPicker and want to use it on my form. All works well. What I want to do is gray out values which don't exist in the table ie only allow valid dates to be selected by the user. I can't find anywhere to set this property so am I hoping for too much? At the moment I...

Hi guys, I have been struggling with this and now giving in to the masters! I have a table in a database containing customer details that imported from our central system. Occassionally (and if I get this to work properly it could end up daily), I re-import this to ensure it is up to date...

Hi all, I have a report with several subreports in it. I want to have a button on a form that allows either the full report to be run or the report with the detail sections hidden (ie just summary data). I have used this line in a module to effect one of the subreports: Reports![Accounts...

Hi all, I have a number of reports that I have put onto a single master report as subreports so that they all run at the same time and I can PDF just one doc. They all sit on top of each other in the details section. However, I can't work out how to put a page break between them so that each...

Hi all, I have read through manuals but think I might need a pointer on this one. I have a report that has two subreports, a form and an embedded chart with a linked field. It takes AGES for the report to generate. Each of the subreports load instantaneously when I run them seperately so it...

Hi all, I have read about this somewhere but now i can't find it. I have created a chart directly onto a form. It draws its data from a query and works fine. However, the numbers in the data table are not formatted. If i go into the datasheet of the chart and change the format to 0,000 it...

I have a combox box with managers names in it. I then have a subform with various totals on it that works properly for each any every manager by using master/child fields. I thought that if I added "*" to the combo list values, I could select this and have a total for all managers. This doesn't...

Having a bit of a bad brain day! I am creating a form with a combo box at the top that refers to various managers in the firm. I will then have various text boxes showing data relevant to that manager taken from various tables. My first requirement where I am already falling over is to count...

Hi all, Last week I was playing with the security features and secured my db with the user-level security wizard. I have since been changing lots of things in it so I can't just go back to the back-up. However, I need to save an unsecured version to a different directory in order for a complex...

Hi All, If you have used the Form wizard to create a form and now don't want the, say, "Stone" background, where is the control flag for changing this? Thanks, GE

Morning all, I'm struggling with the syntax of something I thought would be very simple. I have a table that everyday is appended with new values for each client (from an external DB). The column headings are: Cust # Amount Date What I am trying to do is write a query that...

Unexpected behaviour going on here! I have the following macro that updates queries linked to an Access table and then saves the file using a distinct filename. However, even though I am using the BackgroundQuery = false, I am getting a prompt box saying the action (ie the saveas) will cancel a...

Hi All, I have set up a worbook that has 5 or 6 querytables in it. I created these using the wizard and not code (dumb in hindsight!) My question is this: I now want to recreate the exact same workbook but changing one of the criteria in the SQL statement. I know how to do the replacing bit...

Hi all, I've got my knickers in a bit of a twist over this one and now can't see the wood for the trees! I have a table that has three cols - name, value, date. I then have a combo box that allows you to enter two dates. I have a select query that takes the combo values and returns the...

Hi all, I have a query that takes one of the fields and using a rather complicated expression creates a new field that holds a number. I want to use this number to look up a value in another table so I get a phrase appearing in a third column. (I can then hide the second column and just show...

Hi all, I have created a small select query which does what I want it do! (Hooray :) ) It shows three columns with the last one being a count value. But what I would really like is a grand total at the bottom of the rows that adds up ALL the count values. I then want to turn it into a corsstab...

Hi all, Newboy to Access. I have a csv file that contains three rows at the top that I need to discard (the field names start in row4). Very comfortable as to how to strip these out in Excel but would prefer to keep it tidy and do it all in Access. Is it easily do-able or should I stick to...