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

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

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.

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

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

I searched the forum and only found something kind of relating to what my issue is. I have a report which contains a list box there is a border around it, I have set the border style to transparent and it won't disappear. Is there any way I can just have the data displayed with no border...

I have a query that has an Item, ItemPrice, Allocation, and DatePurchased ordered by DatePurchased with only unique values. I'm using it for a PO Database, when entering items purchased, I have the Item field populated with a items previously purchased, when the item is selected the Unit...

I have some send keys F3 and F4 to move to next and previous record, what I'm trying to do is when on the first record I want to disable or not run the macro to goto previous record. The same goes for the last record, I want to disable goto the next record if I'm on the last. I tried making...

I have and Owner name and a tenant name in a report. Is there a way where if the tenant name is empty, I can rezise the owner field to encompass where the tenant field would have occupied, if it was not null? I can make a macro to make the tenant field invisible, but I do not know how to...

I have a DB that has a field homeowner name. The Owner name is <Last name>, <First Name>. Is there a way in my report to only display the last name, like an input (or output) mask? I tried to format it "*, " so it was wild card and then when it ran into the comma it would stop and only...

I have attached a database which is an example of our work in progress. What I am trying to accomplish is when I enter a job number in a text box, a corresponding Owner name and tenant name will be displayed in a text boxes. I have an example linked table in the database and will link it to...

I have an expenditure summary report based off of a query. The header is displayed once my problem is that the details section (which is just a bunch of totals or Sum()'s) is displayed twice. I have checked the query and all of the correct information is there. The totals match up. The only...

I have a report that shows you a sum of the expenses for all of our jobs =Sum([TotalReported]). On a form prior to opening this report we have totals that we have to report to the state =[Forms]![MonthlyFinancialQueriesForm]![Total Checker]. I then have a Variance text box [Total...

I have a form that asks what month you completed a file (04, is april ect.). From this form a report is opened, in my report, I have it read this number and I want to display the month for the number thats entered (if they enter 04 I want april displayed on the report). There is already a ton...