Search results

Thanks for the reply I used the code and the text box is blank? No errors just blank [G-T-H edited - I inadvertently edited this, when intending to reply - this text has not been changed]

Hope someone can help. I have a form with a few general stats from my table "AuctionSales" I can summarize todays and yesterdays sales ok but I am having trouble summing up this weeks sales and last week sales I have this so far but I am missing the point somewhere...

The unique number is assigned before the auction starts as each product has to have this attached due to some products even with the same manufacturers code or model number are slightly damaged and this makes them unique plus we have to make specific notes on each product so each one has this...

Thanks you for your replies. Each one of the numbers 1002, 1003 etc are the short serial number of products at an auction so the products are sold in lot sequence not serial number sequence. Each product sold has a manufacturing model number which can be the same as in 2 pieces of furniture...

Hope you can help I have a combo box on a form based on a field (serialnumber) in a table as below. All numbers are unique and once chosen will never be used again. How can i hide the numbers in the combo box that have been used before? i. e. when the code 1001 has been used all you see the...

Yes the reason for showing inside access is that we have 100's to check and to keep going outside access is too time consuming. When the page loads with the new product code it is instantly checked in the browser inside access and the results are immediatly visable.

Oh yes the link is fine out of access but as I said when in access 2010 it goes down to the product info and then jumps right back to the top.

Thanks very much, I will try and figure out whats causing that and let you know.

That seems to work fine but...the page loads, then jumps down to the product info and then straight back to the top!

Thanks for the replies. The url I have embedded in the form is ="http://www.argos.co.uk/webapp/wcs/stores/servlet/Search?storeId=10001&catalogId=1500002701&langId=-1&searchTerms=" & [Argos Number] I have another table with all of the numbers I need to check i.e...

http://www.argos.co.uk/webapp/wcs/stores/servlet/StoreCatalogDisplay?storeId=10001&GiftMode=Reset&jspStoreDir=argos&action=StoreCatalogDisplay%3FlangId%3D-1&langId=-1&ddkey=ArgosGSGiftModeExitCmd Thats the url, we use it for checking products within access but we would like to reduce it in...

I am using Access 2010 and have a question about the web browser control. I have inserted the control on a form and it navigates to a site and searches for the information I require. The issue is that the response i need is always in the same place about 1/2 way down the page. Is it possible to...

Can someone help me with grouping. I would like to be able to run a report for certain days of the week this year against last year. In other words I would like to see lets say sales just for Saturdays in 2010 (not grouped together but individually so I can plot a graph) and then see how they...

Thankyou for a fast reply

Hi I am trying to display last month by name in a field. I can display this month with =Format(Now(),"mmmm") but I can't seem to get it to show last month even with -1 Any ideas Thanks Kim

Thank you James that worked fine with suppressing the fields but I am now left with a gap where the fields are. The fields underneath did not move up, any ideas? Thanks again

Hopefully someone can guide me in the right direction. On my forms I have the customers info and the products they have purchased along with Sub-total Delivery Discount VAT Total When my invoice prints it has all of the above fields. What I would like to be able to do is to suppress any field...

Thank you for your speedy reply. Works great Kim

I am trying to pull records from today to the end of the week, when I try the code below I get everything from this week, can anyone advise me. DatePart("ww", [ApptDate]) = DatePart("ww", Now()) and Year( [ApptDate]) = Year(Date()) Thanks Kim

Thank you for your help I have tried this and it appears to work fine for me. Private Sub CashSale_Click() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[CustomerID] = " & (5855) Me.Bookmark = rs.Bookmark End Sub...