Recent content by Spam

At the moment I'm using access to do reporting for my companies sales system - all the data is pulled from our sales sql database via odbc. Now I have a couple of reports which basically prints out sticky labels to use as price tags. I have this working fine for individual products, however...

Just remove the AND expressions from the query altogether. eg: SELECT dbo_tbl_sales_orders.sales_order_no FROM dbo_tbl_sales_orders WHERE ((dbo_tbl_sales_orders.sales_order_no)=[Enter Sales order 1]) OR ((dbo_tbl_sales_orders.sales_order_no)=[Enter Sales order 2]) OR...

I am currently doing something similar to print out a list of specific orders for a despatch report. Basically i have a select query with multiple OR statements for two fields (I have to match results from 2 linking tables). This is a cut down version of the sql: SELECT...

Aha! The extra set of brackets did the trick - thanks a lot - much appreciated :)

Nope, get an error - "The expression you entered has a function containing the wrong number of arguments." Likewise if i take the values of the margin field to another colum and try formatting it there - eg.. Margin2: Format([Margin],"#.##") it just bombs out and displays no results :| I can...

One way you can do this without prompting twice is to add another field to your query which prompts for the date, then use that value in your criteria for the other two fields. eg. add a field with the following: dateprompt: [Enter Date] then for " rec_date " Criteria is "...

No joy I'm afraid :( Nothing I type in the format option of the field properties dialogue seems to have any effect, and the dropdown list of common formats doesn't appear when the field is an expression.

I have a simple query to calcualte a profit margin on daily sales lines and I use a quick and dirty expression to calculate the margin in the query so I never need to drill it down further than that level (I don't want to go as far as putting the output into a report as it is only for use when...

I'm having problems with it setting the Reclock flag and saving now :( Run-Time error '2046': The command or action 'SaveRecord' isn't available now. It is basically not liking the DoCmd.RunCommand acCmdSaveRecord at all - doesn't work whether it is a seperate button or not - the only thing i...

Thanks Pat, thats just the trick. I included the command to set the record lock into the On Current Event If statement so that the record lock was set whenever the record changes without the user having to press a seperate "Lock" button. If Me.RecLock = True Then MsgBox "This record is in...

Still having this issue.

Hi there, I've created a database of our customers and the plan is to have a few of our members of staff working through it doing support calls - there's very little information to get written to the database - just a flag to show whether the customer has already been contacted or not. The...