Search results

just my opinion im assuming youve already installed replication control from office setup? theres a conflict viewer in there but it really boils down to poor planning to have lots of conflicts ive just done a big replication project myself, it wasnt fun! firstly, you need to work out who is...

i wrote the function I wrote the function already, it recognises it but just cant seem to pass the current form into the module, i have way too much form code and want to split it up into modules if i can any ideas ? :(

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...

anyone? :(

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...

yeh i tr ied all of the above, i still get the same results, im not sure if im averaging it in the right spot, do i need two queries one to calculate the sum and one to average it? its basically for a Point of sale system does anyone know of sites with sample access databases whom maybe i could...

Ill try that, but i still need all the sales, including the ones without duplicates too. its based on cost averaging the costprice so i still need to list all the sales but the sales that appear twice or more due to the duplicate costprice records in the other table need to be averaged out...

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...

thanks pat, that was perfect, so simple, thanks for both of the responses

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 ...

hey Pat yeh that would work! thanks for the response, as well as your response too in my other thread. Dean

Yeah I looked at DCOUNT, however it required a variable, and Count(*) isnt a variable its a function.... im probably wrong but i cant see it i just need to add all the 'Count(*)'s up in the report, i.e. each one that appears in the summary.

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

hey col THANKS it worked, the error came from somewhere else, but i redid the report and bingo... cheers dude

hey col, thanks for persisting yeah it is, i even changed it to just an E and that didnt work, tried using the builder to put the query name in front as well, just comes up with something about not having an automated event..

couldnt get that to work hey it just pops up a box asking for the value

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...