Search results

Yup, I can PM or post the DB if you want to take a peek.

This is really driving me nuts. Effectively I want to reverse the column and rows, relative to a standard access table. Instead of the report being a table all fancied up where records run horizontally I want them to run vertically. So instead of: ItemID ItemName ItemDesc 1...

This worked well for Print Preview mode, but is there anyway to carry this over the Report View? It's odd to me that Access would do this, when I view in print preview the columns are there, though when I switch to report view it goes back to a single column. Bah!

Thanks gemmy you always know exactly what I'm looking for.

So I have a question about the layout of reports. I understand that a typical report runs horizontally, 1 row for each record. I suppose as such: 1111111111111111111111111111111 2222222222222222222222222222222 3333333333333333333333333333333 4444444444444444444444444444444...

This is really good. I can definately get this to work well. Thank you very much

Hello, Here's the dilemma: On a form designated for data entry, FrmDataEntry, I would like the user to be able to select an image from a folder within the DBs directory. I've been looking at the mvps write up on it, I snagged that link from a post here I found through searching, but I really...

Is access hosted on a server, or network computer? Is your computer set up to Sync with that computer ? Goto your IT department and pull the IT guy away from quake for minute and beat the answer out of him =)

Well, I'm really not too familiar with 2003 other than some basics. I'm pretty new to the community myself.

I am not sure which version of access you are using but it might be that you need to set up the location of your DB as a trusted location. For a while I had DBs packaged that always gave this message. As I understand for packaging on 2007 you have to manually edit the registry as the run time...

I'm going to try to show how I would do this. TblTimeClock PunchRecord TimeIn TimeOut autonumber date/time date/time on the report I would have an ubound text box whose source would be the DSum of (TimeIn - TimeOut)*Wage, I don't remember the specifics of DSums...

Hello Daily Post, I suppose, Here is what I've got: On one form resides a list box that get's it's results based on a customers sales history. The form contains all the customers prudent information, otherwise. What I'm attempting is such: Onclick for the listbox is DoCmd.OpenReport...

Ok, I always post at the end of the day because by now I've fried my brain thinking and I have simple problems that I can't wrap my mind around. I need some light shed on this for me, 2 Tables Table1: ItemID NumberSold Table2: ItemID InventoryAmt I have a Select query, I have a relationship...

Hey, I've got to make a query that displays all records whose Date/Time field appear after another tables Date/Time field. I suppose I could say this is for use in an "Item scanned into inventory, Item Scanned out of Inventory" fashion. To purpose is to use the total items returned after the...

Alright, I'll try to explain this since I don't have a DB to upload as an example. I'm trying to implement a new DB that allows the user at the front end to use a drop down control to select which back end Data.mdb file they wish to use. This is brought about as we have two seperate locations...

I've been fine with using access so far but I guess I'm hitting a point where I need to start using straight VBA instead of Macros and expressions. I think what I need is a little dot connecting at this point. I understand that I can look at my queries in SQL view, and I believe somewhere I...

Go figure, simple restart fixed it. Funny how after hours you don't think of the simple things til you just go smoke a cigarette.

Not to be rude but I'm really just interested in why I'm getting that error when I try to add a command button. I'll tell you all about it in PMs if you're really interested, it's not my design I'm just stuck working with it. I just tried it on a blank database, I get the same error so is this...

I did a quick search and really didn't find anything related to this. Though, I'm sure it's pry happened before. I have started work on a new front end and have several linked tables to our back end. As well as copies of them for the purpose of the front end. On load the backend tables update...

Let me preface with this: I dislike Macs. I really dislike macs. Unfortunately my boss uses one, though the rest of the business uses PC's. I need to get a small access program onto his mac. I don't think it can be done, easily if at all. Is it possible that developer tools exist for Office...