Search results

Hi all I have a table with 4 fields; id (PK), xdate, xdesc, country(integer), which has duplicate data, so far i have a query showing duplicate queries 01dupspdates which creates a combination of date and country which might be duplicates DELETE SpecialDates.xDate, SpecialDates.Country...

I have just realized i didn't have the correct addin on excel! i am a fool!!!!

Hi there, I run a vba excel macro every morning for about 4 files which produce cash reports from different banks back to a similar format. I then want to automate appending this information to a table. the code i have is as follows, however it has an error which is user defined on the line...

Thanks Markk I agree with what you said, I thought that too - I have adapted the script with your suggestion but still not working. the msg box comes up with the form loading, but it doesnt show on the screen and still askes for the form!prodtab.value btw i am opening the frm02purchaseorder...

Hi there, here is the database with the issue with on it. I dont really understand about setting the recordsource to zero, as it is coming directly from the query? regards Simon

Uncle Gizmo - obviously happy to post the DB on the website, however it is quite large do you have a suggestion to cut it down - ie just copy out the relevant data into a new DB? Thanks Arnel will give it a go! will feed back soon!

Hi there, I have a form, which has a subform which is tabbed The tabbed subform has the same query on each page, however filters is based on the tab number. (this was the easiest way of of showing lots of data) The query runs and the query changes for each tab, however on the form loading it...

Hi there, I have a form (purchaseorder) which holds order details. When pushing button i want to convert the temporary order into a confirmed order by an append query. This is done by moving the items in (tblorder1) (itemno) and (quantity) and the form order no which is a text box on the form...

[Forms]![purchaseorder].[Form]![summary order subform].[requery] thanks the above worked when put in as sql into the after update. brilliant!

Hi there I have a product order form (purchaseorder) which has a tabbed subform (prodtab) in which there is a query form (qrymanual2 subform1) this splits the products over 5 pages into categories for the use to select quantities. I also have another query which based on the same tables and is...

thank you! I had the default setting, just wondered why it wouldnt work!!! much appreciated - i can now sleep easily!

Hi there, I have a simple query, which filters a long list of data into criteria based on the tab label in the form. the sql is as follows: SELECT tblproductdb.PC_Code AS Code, tblproductdb.PC_Page AS Page, tblproductdb.PC_desc AS [Desc], tblproductdb.size AS [Size]...

Thanks, however what coding do i use? so for example qry = "SELECT data.transaction, data.Surname, data.Quantity, data.ID, price.Field1, [Quantity]*[Field1] AS Expr1" _ & "FROM price INNER JOIN data ON price.[ID] = data.[transaction]" _ & "WHERE (((data.transaction)=2));" This filters the...

Hi, I have a simple query where there are 6 products, I want to show all of the results on a tabbed form split by product. How do you do this via SQL so that you only use 1 query and change it for each tab? ie tab 1 shows the query filtered to product 1 tab 2 shows product 2 etc. next point -...

Hi Plog, what i want is for the query to show exactly what is in the table - ideal query. ie all the data in tblorderprodsdetail and blank 2 columns of purchasequantity and purchasedelivered. The user can then populate the query I can filter requested codes and add the data to a bigger order...

Hi all, sorry this is a really easy one, and i should know what to do but i cant! basically i have 2 tables - firstly tblproductsdb - a data store of all the products I sell... secondly is tblorderprods - this is a table used in conjunction with tblproductsdb (as a query) so that the customer...

thanks Jiri - how then would you suggest I managed to get the largest number of Pdid on the subform? (which is a set of filtered records? can be VBA or expression)

Hi I have a form - purchase, and a subform purchasedetailds they are linked with a field "puid" I need the dmax to give me the maximum auto number field "pdid" on the subform in a textbox on the mainform. I used the control source code...

Hi Isskint, and thanks for the message – no not affended with the language but am surprised how am loving my nerdy side coming out! Having just come back from watching age of ultron with the kids decided I need my own Jarvis to help!!! The allocation flow diagram is exactly what I have in my...

Right starting from basics I have tried the following code to take the fields off the purchse & purchase detail form /subform and copy it into stock table. it isnt working!!! Dim strSQL As String Dim pd As Date Dim puit As Integer Dim puq As Integer Dim pupr As Currency Dim sdate As Date Dim...