Recent content by tjcinnamon

I am trying to hide and unhide to dramatically reduce the loading time of my app. I do want to have the users task bar occupied when the program is minimized (I want them to think the program is closed). Ideally I would get it to minimize to the tray but that is proving to be too difficult...

Thanks for the reply. I wasn't sure if a properly normalized database would require code behind the scenes to keep it normalized. I actually got it to work after posting this but its good to know im on the right path.

I have a PO DB that I'm trying to normalize. For the most part it is normalized but there are 2 fields that are not normalized because they repeat data. So I'm trying to restructure a bit and having some problems when it comes to data entry via forms. There is also a PO table above this one but...

When I open up a new record and set the focus to goto a specific record it changes my default find/replace behavior from general to specific because it's in a specific field. If I open the form and the first thing I do is a find and replace it will check all available fields on the form, but if...

So it is not possible to achieve something like this. http://www.access-programmers.co.uk/forums/showthread.php?t=125738

SELECT [Purchase Orders].[PO Number], [Purchase Orders].Date, [Vendor Details Table].Vendor, [Purchase Orders].[Invoice Number], [Purchase Orders].[Our Number], [Purchase Orders].[Okay to Pay], [PO Details Table].Item, [PO Details Table].Allocation, [PO Details Table].[Unit Price], [PO...

It only returns all the records with an Our Number not null, if the criteria is blank I want it to return all Our Numbers (equaling null, and not null)

Or is there a way to make a form horizontally continious just as you can already make it vertically continuous? I am basically in the market for a 2D form.

This is in Access 2000 I had to convert it for a friend. I deleted my previous 2k3 post to save server space. I have it controlled through a form. I have attached the DB, I inherited a good portion of it and it needs alot of Normalization, but I have the Queryswitchboard auto open. You can...

It's not interpreting the IIf statement as true or false because I just giving me jobs with out a FileNumber, It will not carry out the Then or the Else portion. in fact even if I manually type in the criteria where I know there is a FileNumber to be filtered by it still returns all blank...

I have a query that the user can customize. It has a number of condtions to sort by, Vendor, FileNumber, InvoiceNumber, Person, Allocation, ect... In the conditions of the query I use a like iif statement for all of the combo boxes: Like...

I have a complex problem (I think). I have a table of tblPurchases: ItemID, Item, Units, Price, FileNumber. (1 primary key and 1 foreign) I have a 2nd table of tblMeasures: MeasureID, Measure, FileNumber. (1 primary key and 1 foreign) My Main table is a Table consisting of FileNumbers. These...

I have a table that has about 5000 street addresses (ex. 1234 your st.). I want to get the all the characters until the first space. So for (1234 Your St.) I want to get 1234 for W1234 St I want W1234. Is this possible?

I have a group for PO but cannot get the page number to reset. How would I reset it?

I have a report of 24 records that are seperated by PO Numbers. If PO # 7 is 2 pages I want it to display in the page header 1/2 for the first page and 2/2 for the second page. Then if PO 8 is 1 page I want it to display 1/1. I have searched the internet and have tried to get code but I...