Search results

As the form will load the button and sub-form at the same time. You should add it to the "After Update" event I imagine. You can access this via the Property Sheet - > Event -> After Update section, select the ellipsis and choose code (or choose Event Procedure from the drop down and then...

I would suggest a text box to be used as a search box (unbound) on the main form. Then a user can enter the search criteria and if you have a button (or use after_update event on the text box) you can refresh/run a query which populates the sub-form. The sub-form query will need something...

Hi, I am trying to subtract 4 fields from each. These are "totals" within a sub-form. On the main form want to take 1 of those fields and subtract the other three. For some reason I keep getting the #!type error after I include more than one text box. Any help would be appreciated:The...

Hi, Every time I re-open Access 2010 it pops up stating the following with a blank text box: "[Forms]![Frm_system]![sub_frm_invoices].[form]![invoice_id" I hit ok and the usual invoice_id param text box message box appears again. Once that is over, I gain access. I can browse to the form...

apologies, the forms aren't actually using dashes, they all use underscores

Hi, I have a Dashboard (sort of), a home page with a couple of sub-forms to display data to users easily. One of these dashboards is a list of incomplete invoices, I would like the user to be able to click a button on each of the sub-form (continuous form) rows. This button will then take the...

I have managed to get what I need using two sub-forms. One as the invoice details, the user selects the lot and a second displaying the lot information based on the sub-forms control value for invoice_id. It does what I hoped when the user exists the first sub-form and i requery the second...

Thanks but as the actual bidding is completed outside the access database (i will just update with final bid to create invoices for some customers) some of it is unnecessary. It is interesting to note that they seperated bidders/sellers but I guess the column names are different so they are...

Ok see re-attached for my redesign. I have already corrected the database for most of the changes..however I do have a further query. The lot table contains the listing_fee, reserve_fee and the reserve_price and hammer_price. I basically want the invoice_detail to contain the following from...

Sounds like what I had...ok thanks...I will re-do the work and see if i can get it to work this evening. I am now struggling to reference a control from a sub-form (using tab pages with a sub-form on each one - referencing one of those controls to produce a report...grrr). Thanks again - will...

The auction one makes sense, I will change that immediately. The spider web aspect is because I seperated the two types of auction and they use the same lookups (employee and whatever it is)... Basically the two types of invoices do have certain differences, for example sellers will have a...

Hi, I am creating a sample app to mimic an Auction House. It is basically an invoicing application with some product(lot) tracking included. I am happy with the customer/lot section having split buyers from sellers to make things a bit more simpler. I now need two sections - seller_invoices...

Got it working... As long as your query returns only one value this is fine...otherwise ask for more help... -> Add query, in my case I require a few counts/totals of other tables.. -> Add text box to form... -> Amend control source of textbox to =Dlookup("[query result column...

Consider splitting the database: http://office.microsoft.com/en-gb/access-help/split-an-access-database-HA010342026.aspx It creates two parts to the database, the front (forms etc) and the back (tables). That way you can link each "Front End" copy of the database seperately - pointing it to...

Hi, I am currently developing a database to provide a friend with an auction tracking and ordering system. I will have a number of questions the first is related to the Home Page/Dashboard/Summary form I am creating. I basically have a few sections, one of which is a combo box offering the...

thanks that works - useful to know.

No you're right - I never considered that -of course it does...apologies assuming the form is open of course it will grab the right ID as a parameter. I will remove the query commands from the sub completely. EDIT - feel like a right numpty - I am fairly comfortable with access but I use it...

how would I refersh the query with new data. I tried using other commands but the only way I could get it to work was by actually opening it (I read somewhere it is a limitation as I chose to use a select query rather than a temporary table).

The query simply selects the data from the form (using a form field as a parameter). It only selects 1 record as the parameter is the ID which is created when the user saves the record. This query is then used by a report (like a mail merge) to produce a document and output it to PDF.

Thanks, I tried switching the echo on and off and it didn't work. I have had a further look at a few different methods and I don't think it is easily possible so I may not worry about it. I am using 2 commands, 1 to open the query and a second to close it - it doesn't display on my screen but...