Search results

To start each Page has a Page Reference in the QueryString in this OG so we test for LESS THAN 0: If Request.QueryString("OG") < 0 Then intPage = 1 Else intPage = Request.QueryString("OG") End If We will later test for Page GREATER THAN PageCount Then declare...

I sussed it out. Datagrids only present old-fashioned Tables, TRs and TDs. All very well for inert lists but what about including images and data sensitive links? I don't think so. I will start a separate thread on Paging. http://www.access-programmers.co.uk/forums/showthread.php?t=267121...

Hi Gina My mistake Simon

Gina. Yes please. I will try to look at it over the weekend however I'm doing Safety Duty for the Three Piers Race so god knows were I will end up - I just need to take a lot of fuel. If you don't here from me I maybe somewhere off the Essex Coast. Simon

I can't read what you have done I will have a look at the old version over the weekend. An Access 2007 version would be helpful. Simon

Let me have a go at it it maybe a day or two. I was just tinkering to understand the project. I will do it thoroughly. Don't worry about the Protective clothing issue everything is included just some are deal with in Bulk. How do you know what to spray and when (allowing for mother nature)...

I would add that these three Applications don't need Face / Mask Protection? Chlorantraniliprole Fenbuconazole Propiconazole Simon

Believe of not it is quite easy. Beleive or not you know exactly what to do but not howto. I will leave the Batch / Lot out of the equation for a moment. I assuming you receive an order. You input The Order (if this is Unique it can also can become the BOL reference). The Order included the...

There are a few things The tblReEntryPHI I don't think works. I would have: Applications Applications Ingredient Applications Purpose In the Applications Ingredient I would have the protective information and Re-Entry info. Take Sniper and Guthion Solupak both have the Active Ingredient...

OK go it. do not next to track the Batches so that tracked back. If that id that case you would probably need an Order and Product Details the later has Batch Details and would allow Product from different Batches to be allocated to an Order. Simon

So if you were to fulfil an Order would use the Lot Number or the Product code. Only the BOLShipped mentions LOT, if the LOT is going to used there is no other table it relates to. Simon

Not quite. What is the Lot Number? Does this equal the Order being Fulfilled? Simon

OK. You have a Billing of Lading as Separate Unique Entity. Then you have the contents of the BOL (multiple values) of Products. You end up with a One to Many relationship between the BOL and its contents. You don't repeat the BOL information on the table with the contents just the BOL_ID...

I know that there are issues with ADODB as you are supposed to use ADO.NET. Can you let see the script to the objConnection.Open. Simon

Are you running at intranet using IIS? Simon

You need to Add a BOLSippedDetail File with: BOLShipped Product Etc On your BOLShipped SubForm you should put Product Description and two columns the first ProductCode Len = 0,1.5in 0r 3.25cm for the Product Description that way the Product Description is displayed rather than the Product...

Some of the Pesticides are Nutrients here are some I recognise: Agri-Grow (calcium in suspension) Citric Acid Copper (Spray) Hydrophos M/P/K Urea It would seem that you need to cross-reference: FarmBlock With FarmID FarmBlock With Crop Pesticide / Treatment With (Active) Ingredients...

This is what I use either into ASP or ASP.Net, the varability is the Exhibition, OE is ised for paging. Function Web_ExhibitionsOriginals() With CodeContextObject Dim WebLink As String WebLink = GetWebPath & "Originals_Exhibitions.aspx?Exhibition=" & .[Exhibition] & "&OE=1" &...

Exactly! In the OnChange Property: Function PageNo() With CodeContextObject .[Page No] = .[TabCtl0] End With End Function Simon

Sorry I was called away unexpectedly. Is this the type of think you are trying to acheive. Simon