Recent content by jennilein

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?