Search results for query: *

Hi all Point me in the right direction? I have a multi-page invoice report. The totals are populated by the On Format event of the page footer. I want to omit (or make invisible) the totals on all pages except the last one. I don't want to use the Report Footer section since it seems to...

Hi All I know it's easy enough to make a combox invisible, but what I want it to be invisible (o disabled) as soon as I've used it to select and display a record. I tried this in the After Update event of the combo box: Me!Combo92.Visible = False but it didn't work. Any ideas: So the...

Hi all I have an Orders Form and an Order Items sub form. I have "Add" command buttons in both so that the user can add a new order, or add a new item to an existing order. On the sub form I can obviously put code in the On Click event of the button to set the focus to a particular field, to...

Hi What's the best approach to deal with this? I have a orders form, with an order-items subform, in a one to many relationship. The user clicks a command button to add an new order, fills in some fields and then, may or may not add order items at that stage. The order is automatically saved...

Hi all Just when you think you've got Access sus'd, something happens to confound you! I've read from other posts that I can enter, say, start date and end date parameters for a report into controls on an unbound form, and then, for example, show the start date and end date by entering the...

Hi all Is there an easy way to do this: I need to enter records into a form, several at a time. To save repetitive typing I want some of the fields to automatically be populated with values from the last record I entered, in that particular batch. Once the batch is finished, or say when...

Hi all There is probably a better way of doing this but... I have a macro running 4 append queries, one after the other. Of course Access display alert balloons to warn that data will be changed, and because there are 4 queries it does this 4 times - it's a pain for the user. Is there a way...

Hi all This must be a common problem. I set the margins on a report and when I come back to it the settings have reverted to the original (24.9mm). What's the solution to this? Terry

Hi I'm having another go at this in the hope that someone can suggest a better method than the one I'm using. All I want to do is calculate the totals of a field in a transaction table ("child" or "many") and store the result in a field in another linked table ("parent" or "one"). Having read...

Hi all - Help please. I am simply trying to store totals of transactions held in a table as child records, in the header records of another table which is essentially the parent. The UPDATE query I've made seems to work fine for some of the header records but not all and I don't know why it...

Hi I'm trying to do something that I guess should be simple. I want the user to type information into a few fields, on an unbound form, and then click on a "POST" command button which adds 2 new records to a table automatically, using the data entered (One new record will do for now). I don't...

Hi everyone It's been a while but found myself doing some Access work again. Can anyone help? I just want to import a CSV file which contains a date field. The program the data is coming from needs to export dates as text in the format "20070201" (1st Feb 2007). When I import into an...

Hi Can anyone suggest a simple way of determining a week number in the year (between 1-52) from an inputted date? This is for an accounts application so I would like the year start date, and thus week 1 start date, to be variable. So for example, if the year start date was 1 August 2006, any...

I don't seem to have much success importingobjects into Access. I thought I would be able to design new tables, forms and reports in a copy of an Access database, say on my own C: drive, and then import the new objects into the "live" version on the network. However, when I do this the...

Hi all This isn't desperately important, or even a problem, but more a topic of interest for me. I was looking around Access 2000 and noticed I can have Calendar Controls in my forms. They look interesting but I've no idea what you do with them or how they can be used. Can anyone offer...

Can anyone tell me the simplest way to disallow edits on just some of the records displayed in a form. For example, I wish to allow users to continue to enter and edit transactions in a form which records employees start times and end times, amoung other things. The process is operated by...

I have an Access 2000 DB working fine in every respect on my own PC with XP professional. On one of the switchboards, I have 4 report options and a text box [weekno]. The idea is the user selects the week no for the report (eg 43) and then the desired report from the four available (eg Invoice...