Search results for query: *

Thanks for the tip, but even the first step of trying to import the tables one by one into a new mdb doesn't work. Any other suggestions?

Hi.. When trying to open most tables and/or reports in a database designed by someone else, I get the error 'file may be corrupted create back up and then compact and repair'. The problem is it won't even let me compact and repair. Also, when trying to open certain tables, the 'corruption...

I have a column in my table which contains a hyperlink to a product picutre. I would like for the picture to open in a report based on that hyperlink. How do I do this? I've done it before, but I can't remember how and don't have that database anymore to refer to. Thanks in advance for the help!

Is it possible to create boxes in a report with a colored background and then have some of your text boxes in there? When I tried to do this, you can never see the text...I was looking for a 'send to back' or 'send to front' feature, but couldn't find it. How can I get the text to appear over...

Thanks so much! That did it!

We have a shared database at work, where I used to be able to open/create reports - but recently I can't run them anymore. I can't even get into the design view. My colleagues are able to open and create reports - and the database is on a share drive. I've checked the security and everyone...

If I have a query, with let's say 4 tables (A,B,C,D). It's a one to many relationship from A to the others. I want to calculate different measures between fields pulled from all tables, however if table B doesn't have a value for a particular record - it leaves the field blank - so I can't...

My objective is to see if sales are declining or increasing over time. I already have the information plotted as you described...that's what I used the slope function with. So, I guess I'm on the right track, right? Thanks. Jennilein

Not sure if this is more an excel questions, or basic math - but here goes... I have several products and a 2-digit number that represents each sales month. I ran a cross tab in access to pull my total sales per month, per product and exported to excel. Now...my products are in column A, and...

Thank you all for your help. It finally works! However, isn't there a way to tie the list box selections into my query directly? If I nest other queries off that query, it doesn't recognize the selections being made in the list box on the form. It only works for that 1 query and only when I...

Okay, that worked. However, when I try to run it, I keep getting an "Enter Parameter Value" box? It's like it's not recognizing my selections.

For some reason, it's not opening my report in print preview anymore...it's trying to print each time. Is OpenReport the wrong command?

I have a query that runs off a table called 12 Month Table. The list box is sourced from a table SalesCode. I didn't set a relationship because I only wanted to use the list box to set the search criteria in my query. I fixed the naming issue, but it still doesn't work, in fact, I get...

Private Sub Command6_Click() MsgBox BuildWhere(Me) DoCmd.OpenReport "rpt_test", , , BuildWhere(Me) End Sub

A pop up box appears with (tb_salescodes.sales code IN('1P010','1P015')) then when I click OK - I get a run time error 3075 Syntax error (missing operator) in a query expression '(tb_salescodes.sales code IN('1P010','1P015'))' Any thoughts?

the query is used to run the report. i placed the code above the docmd.open report statement, but i'm still getting an error. what should the docmd.openreport statement look like - just the way you wrote it, or should there be more to it?

I'm sorry, but i can't seem to get this to work. I changed the query to match what you wrote - except the sales code is a string and not a number. I made the name of the code copied from the FAQ - buildwhere. I then changed the code for the button - to open the query - with the code above...

I appreciate all your help, however, it's still not working. I created a new module and pasted the entire FAQ. I went into the properties of my list box -under the other tab- and placed this under tag: Where=tb_salecodes.salescodedesc,string What do I put in my query? Right now I set my...

Do I copy all the code in the FAQ?

thank you all for your suggestions. i'm trying to nurse my way throught the FAQ181-5497 - i don't usually write vb code. the criteria should always be OR -never AND. to briefly describe what i would like to do...i have a table with sales data & sales codes. I also have a reference table...