Search results

OK ....I am sure this one is very simple but here we go I have a default date set up on a form as now() so each time a new record is entered it brings up todays date. Tt is set to short date xx/xx/xx with an input mask My problem is that elsewhere I am running a summary form which includes...

the penny's dropped Got it needed to put another table in the query - things always seem to get easier when you have shared it with someone

Still confused If I go into the query for the report - it show the tables which I am using - I have added the Customer Name field from the purchase order table to the query I then add this field to the report. But it does not show any data when running the report - just blank should I be...

I have a report prepared from a wizard from a form (and amended) The form (purchase order) has a combo box "ContractNo" picking up info from a SQL query (is this the right terminology) I have another field on the form "Customer Name" linked to the combo - [ContractNo].[Column](1). this works...

Thanks Pat although I entered the code and it accepted it, it did not seem to work - it did however get my train of thought going and I entered the criteria "active" in the combos rowsource query so it only picks up the active jobs and amended the message box on this. seems to do what I wanted...

I have my code on the "On Close" section of the form which when you close you want the main form refreshed..ie not the main form HTH

I think this is similar to a problem I had....the reply is somewhere on this forum under richio. The code is entered to look for all open forms and refresh...it worked fine for me. I will try and find the exact code if I can and get back to you

I am struggling getting the exact code for my If function, any help would be appreciated..... I have a purchase order form linked to a main customer table - so every order has to have an associated customer. The Customer No on the order is a combo box linked to the Customer table with a "Not...

Worked it out now I knew I would eventually richio

I have created a report using the wizard based on two tables - Purchase Order and Purchase Order Detail. The sections of the report are the normal headers / footers but also a PurchaseOrder_PurchaseOrderID header, which I assume is something to do with a subreport being set up. I want to add a...

I have one field in a from that I don't really want all users to see. Without going down the security / password route has anyone got any neat tricks on hiding the field and only displaying if you know how. Ie a hidden button or something. I did think of just putting it right at the bottom of...

thanks The trouble is I thought I was being clever by not using the wizards. I suppose they are there for a reason. You must be in the west of the UK......I did pity those people when looking on the weather map this morning.

why do I always attempt things on a Friday afternoon!!!! This is so easy I feel stupid....but the heat is getting to me. All I want is a purchase order report. The form for the entry of the order is done...... based on a purchase order table (main form) and purchase order detail table as the...

thanks for your comments, it can be done.....fantastic. I am not sure when I will get to start working on this ...so I may need a bit more help at some point. PS - Is there anything that can't be done in Access?

Before I get into my next project I was wondering if anyone could give me a few pointers. I don't need full details at this point, just to know if it can be done and a guide as to what functions to use. Here goes.... I have a "purchase order" prepared by another department. Typical set up...

Yes it was something to do with the query...I think "showing the totals" but not sure. One of those things, keep changing things until it works but then can't remember how you did it. At least the end result is that it now works..... Many thanks

Many thanks I have used the double click option before on other forms....so should be OK

Friday afternoon blues Two forms based on one table (one through a query to filter it down) The idea was that the second form only showed limited info from the table.....a kind of summary form. (in continuous forms view) I wanted to be able to still update info on the summary form for one...

When you close the main form and re open is the info in the subform then. If so it could be something to do with refresh / requery I think although I am no expert. I have a database where I enter the info into a subform by a "pop up" form which on closing / deactivate runs code to refresh the...

I think the question is probably more complicated than the answer so here goes...... I have a main form with a subform, based on a main table and linked table. I have made a query based on the main form to only select certain records and also made a form based on this query to show in...