Recent content by davewhite04

Hey Bob, I have managed to sort it. The problem was that a user in the new mdw file the wizard creates was also in the Access default mdw file. What is confusing is that once I login from the shortcut successfully Access still tells me it's using the default security file, this however...

Thanks Bob. I decided to give the wizard a blast this is what happens. It seems to use the new mdw file that is created but when I look at what the current mdw in use is (after I've logged on) it says it's the default Access one... strange. Also if I access the database objects from a new...

Hi Bob, I've tried this but Access continues to use the system.mdw rather than the one specified in the shortcut... I'm using Access 2002, not sure if that might cause a problem... Thanks for your speedy response!

Hey all, I was wondering if any of you guys know how to specify a custom workgroup file in a shortcut to my database. This is what I've got in my shortcut: C:\TEST\TEST.mdb /w "C:\TEST\SECURITYFILE.MDW" Basically I want access's system.mdw to remain the default mdw for access but want my mdb...

Hello all, Here is some sample data to show the type of records and data I'm dealing with: NUMBER DESCRIPTION 5 TEST 5 TEST2 3 TEST3 3 TEST4 I need a query that will return two rows from the above data and present it like this: NUMBER...

You're welcome, don't forget you can simply highlight your report on the form and right click, click copy and create a new report and simply paste your graph in the report. Have fun.

Well for simple charting that you have just done, then make sure that there is no aggregate functions(avg,sum,count etc.) used in the select statement of the row source of your chart, also make sure there is no group by. This seems to mess up the chart. Also, if you are selecting data from a...

The query that is the rowsource of the chart (qry_ChartingData) does not return the fields you have used in the select statement for the rowsource of the chart, therefore you are just getting default information. I had to convert you DB so not sure if this will work, but try it... Clear the...

I'm messing about with this at the miniute also... What I've found is that removing the GROUP BY and whatever aggregate functions that are in the select statement (avg,sum etc...) that is the row source of the Graph actually gives you what you want. Hope this helps.

Double post. Delete post does not work.

The date data in the table must be stored as dd/mm/yyyy for the search to work. I have changed the format of saledate on my app to text and the search still works fine so there must be an issue with the data in your table.

Sure, instead of what you posted just type this: Private Sub TOTSITES_AfterUpdate() Me!PPS = Nz(Me!Price, 0) / Nz(Me!TOTSITES, 0) Me!GPS = Nz(Me!Gross, 0) / Nz(Me!TOTSITES, 0) End Sub

So in the lookup table, change the value N to T for the saledate, this might work.

If the saledate is not a date/time type field change it's type in the tlLookup table to T. See how that goes.

Hey OK, attached to this message is a zipped up copy of a little search app I knocked up. I've added a little error handling this time, but feel free to modify it further. You may need to add the DAO 3.6 reference(I use this alot for speed). It is an Access 2002 file so it should work fine...