Search results

What about making a shortcut to a report on the desktop? I tried dragging it to the desktop but that opens it in print preview.

Not sure. I've uploaded a more complete version, the 2 of the report in the middle of "daily" will be blank, since there are no sales for today, but the bottom one should still be incorrect. The zip file is complete, the .accdb I had to delete several tables, but it still gives me the same...

No change. If I move it higher up it works though. It SEEMS like any report past a certain point (vertically) does weird things.

It's alright, I am using 2013 also. F9 updates the report, but it is still incorrect when I close it and open it again. Is there a better way to combine reports? All my graphs use the same query, just different fields, criteria, & filters. As I said I tried combining them in a form instead but...

I am in the US, Eastern Time Zone. I am attaching some screenshots. It shows normally the day before (so today, its showing Sun instead of Mon). And when I move the daily sales graph to the bottom, the numbers are totally wrong and the dates are not even correct. At first when I tried, it...

I am trying to combine multiple graphs (about 4) together into one blank report. I have just dragged and dropped a couple of reports into it, it seems to work ok at first, but the last graph is showing up with incorrect data, almost as if I just need to refresh. I've tried closing, reopening...

I figured it made more sense to build on what I already have no? I think I should be able to do it with an update query, but is it possible to bypass the alert box asking if I am sure I want to update x records? I already have my own alert boxes.

I am trying to do a loop that alters records as it goes. My tables are setup as Orders->OrderDetails. I have a currency field named ProfitPrice within OrderDetails. Currently I have this working code using macros: pass parameter prmOrderID SetLocalVar varOrderSubTotal = 0 For Each Record IN...

any thoughts?

Hello, I am trying to alter a form (OrderDetail) from the Northwind Traders Database. Basically I have made a Detailed Category field and would like to "drill-down" the list of products based on this detailed category So the user would select a Detailed Category, then select a product with that...

Any ideas/suggestions?

I copy and paste the data from turbolister, a program for ebay listings. It easily pastes into an access table. No idea how to use a staging table. Any how to articles or anything you know of?

I'm making a comparison to find any entries not on the new table that are on the old table. I then store the differences in a new table and eventually use that data. I think that is the only query that involves both tables. If there is a better way to do that I'm all for it. I find myself...

Basically what I'd like to do is delete my "old" table, copy my "new" table and rename it "old", then copy "blank new" and rename it to "new". Basically a big switcheroo, so I can enter new data into the blank table and compare with the most recent data. So from what I've read I need to create...

Thanks a lot, I ended up changing it to number like you suggested. Even though it is currency, works good enough for me :)

It is currency. Should I round the temp value instead? I'd rather not round if I could avoid it.

I'm using a modified northwind inventory database I have an order, with order detail line items eg. Order1->product1 $10 ->product2 $20 Using an after update event, I use setProperty to set ProfitPrice equal to ProfitPriceTemp. Most of the time it works, but when the temp value=0.38915...

Any ideas? I feel like something weird is happening because everybody keeps offering solutions that SHOULD work but don't.

I appreciate all the help guys. @ nanscombe I tried your code, and I get this error. Run-time error '3159': Not a valid bookmark @pat hartman I removed the send keys code and tried just using the keyboard buttons (would have been an acceptable temporary solution) but even those don't work in...

@rainlover I was confused by what you said. Now that I'm typing this I realize you meant the physical pgdn button not the command button. I just tried it now and it doesn't work using the dialog window @nanscombe I was thinking setfocus might work, I am not very familiar with vba so I wasn't...