Search results

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...

Well, Thank you very much this worked perfectly.

Ok, I have made a small price checking program that uses 1 form and subform and a few queries to move information from an inventory table to a History table when a user clicks an Add Me control button. The history table can be viewed in the subform. The Inventory table is in the main form. The...

Hello, Here is my situation, currently I have a text box bound to a field where users can scan a barcode and bring up the information if the barcode finds a match. My problem is, if the barcode is not in the database then after users hit ok to the not found message box it leaves the number in...