Search results

I think its better to base your form on a query rather than the table, you would then stand a chance of linking the two tables together to display the data you want.

Sorry must have missed this bit, what is jb-2001? I though you where looking at ProductList & PriceList tables. Rich made the commment about adding the field to query and checking your joins. How are these two joined? Build your query based on these two tables (providing they are the correct...

Sound like the value being stored from the lookup (bound column) in table design is putting the pricelistcode in when the column is called product. That is probably by design so you may not get away with changing it. The knock on could be bad for other parts of the database.

CUST_REF is a field on your report, what is the control source of that control?

To start add a field to you table that will hold the full path to the image you want in your report including the file extension e.g. c:\test.jpg Add this field to your query. Open/design the report and add the image control (add any image for now), keep this control unbound. Add some VB...

A Dlookup on a Dlookup will work. Can you put the first of the Dlookups (the one you didn't know about) into the reports query as Expr1 and then run your second Dlookup in a control on the report using the criteria = '" & [Reports]![Mask_order_book]![Expr1] & "'"

Take a step back and work through eveytyhing again. Check the link and knock each one off the list. http://office.microsoft.com/en-us/access/HA011814481033.aspx

I think you need to do some googling or search access help files. Look for queries and and how they work, for you to search the tables of data you will need them. When you have created a query you can then create a form that is based upon one of your queries, this will display the result in a...

sorry, I was being stupid on this, it needed two queries to group the data from the seperate tables and then a third query to bring those two queries together.

I am trying to produce a report that totals and averages but I am having some problems figuring out how to show one of the totals. For example, orders of fruit, I can get all of the many sided data such as Boxes, Weights etc (the individual order details) but can not get the total orders as...

Is there a way of changing the link connection string when you have linked tables from an sql server so that they don't use a DSN? The problem I have is when you allow access to upsize the db to sql it creates the connection as DRIVER=SQL Server;SERVER=......... and so on... all I can do them...

Any idea how I might locate/update/amend/improve the mythical file?

I have small queries running on the database, they run fine. Just the initial running of this one????

I have a query based on several other queries that fetches data from a SQL server. When I first run the query it can take a minute to fetch the data however once it has ran once and I change the criteria it fetches the new data in seconds. Does anybody know why this is? Please

How can I remove the pound and the millions from £2.5m to leave me with 2.5 Can't see how its done with, what I know of left, right, mid they woudln't acheive it as they are not always in the same position for example the £2.5m could be £2m or £10.5m.

I Didn't find the actual reason why but managed to get around this by copying and pasting all my database objects into a new blank database. Might help if anyone has a similar problem. feel like I am talking to myself at times:(

It might be something like this on a command button's click event, say a button on the form that says save (here the button is called Command14) the part you are interested in is the if to end if. The rest is the code that saves and handles any errors. It is basically looking for a field on the...

Not usre how you are displaying you results but i would put an IIF expr in the query. Or buy a different soup (like tomato)

Anybody come accross this issue and have any idea how to fix it. I have parameter in a query forms!frm_whatever!txtwhatever When I run the query its fine, I close the db when it opens again it pops the parameter box up as though the name of the field is not recognised. If I change the name...

Thanks, I tried this but nothing. Perhaps its not published to the web correctly?? Not had much experience on setting up web sites. They are simply in a folder that i have set as a virtual dirctory. When you look at IIS you see some with little cog icon, should the folder be like that or the...