Search results

hi i need to pass a form as a parameter to a VBA module but not sure how to do it i tried this : ClearHideAll(Me) Then something like this in the vba module : Sub ClearHideAll(sForm As Form) sForm![L1].Visible = False: sForm![txt1].Visible = False sForm![L2].Visible = False...

Hey guys, i really need some help with replication, everywhere i search it is very brief in help. Everything works except when I want to do a stock transfer (its a POS system, with databases in 3 shops, the warehouse and the managers computer) As the shop is making sales, i cant let the...

Ok i have a tricky one, i have a query, i.e. Time Value ---------------- Mon 5 Mon 3 Tue 53 Tue 34 Tue 85 Now for the query i need the value items separated as they are, but i also need the number of days i.e. 2 (for just monday and tuesday) Do i need two...

to Jon moderator sorry i acceidentally posted this in the sql server section as well) hi guys first of all thanks for taking the time to read my query : I had a quick question regarding the replication issue. I have managed to create the design master, and replicas, and replication works...

Hi there, this problem should have a simple solution, i just cant think of it .. got two tables, tblSales and tblInvoiceItems, invoice items has a costprice in there - product cost price tblsales works fine when theres only one occurance of this costprice but when we create another invoice and...

Hi there, within my DB i have a table called tbloptions, and a variable called store, which determines the store which the prog is run in ie. 1 2 or 3 now instead of the query asking the user for the store id with a parameter i want to pull the value out of this table automatically i tried ...

is it possible? as Count(*) gives me the records in the detail sections but i need an overall total too thanks for helping us out, this place is great for beginners like me

Hi, i need to create a temporary variable in a report to calculate a line total (quantity*unit price) but then i need to do a sum on this variable to get a grand total, any ideas? im not sure how to create a variable, only use the existing ones thanks

hi im using the old 'Between [Enter Start Date] and [Enter End date]' but i need to get these values to display on the report, as im summarising the records retrieved between these dates but the report doesnt give any indication of the timeframe.. the query doesnt appear to save these...

Hi, ive hidden queries as i complete them (they are being driven from a VB frontend) and i need to unhide them to change one, i cant seem to find an option....... any ideas??

hi, i need to have a parameter that allows someone to type in a month, say 'April' and then to list all the records. my question is can you do it this way? im trying to avoid using start date and end date, as they would have to type in twice. im not sure how to set the criteria up for this one...