Search results

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

I want to sort my query results by VendorNumber (which is an AutoNumber won't be sequential due to deletions). I want to sort the query by what vendor number the current form is on. So if my vendor numbers are 1, 2, 14, 16, 17 and the vendor number on the form is 14, I want the query to be...

I'm using ADO, Access 2003

yes, I want to be able to disable my next record function if I am at the last record, and the previous record function if I am at the first record. I'm not sure what ADO or DAO are.

How do I get the value for my current record position in VBA? Also how would I get the value for the total number of records in VBA? your time is appreciated, JOe K.

I have a DB where after I close out a month of sales I no longer want to be able to view records in my SalesEntryForm. I have a little check box that is the ClosedOut Check box. When I close out Febuary, I want to change all of the ClosedOut Check boxs to yes if the invoice was made in...