Search results

All, I have a table that contains balances for certain accounts by date. At certain intervals, a new record is added for each account. I am trying to measure the intervals for each record (basically, the number of days since the last balance). The data looks like this: BalanceID AccountID...

Hello All, I have a script that I use to copy an updated front end from a server to the user's local PC. The script runs when the old front end is opened and detects a new version on the server. The front end closes and calls the script. All works well UNLESS the front end compacts on close...

I do not like the look of combo boxes on continuous forms. I think that they really take away from an aesthetic I am trying to create. However, I really like their functionality. What I would like to do is have a text box for the field when the control does not have focus, but switch it to a...

Hello, I am looking for a query to select the second highest value (in this case a date) from a table. For example, if I had the following dates: 9/1/06 9/2/06 9/3/06 9/4/06 I would want the results of my query to be 9/3/06. My table is called tblEquityFunds and the field I'm looking to...

Hello, I have a problem. I have a Pass Through query that I have saved (qryPassThrough) and I am using some VBA code to update the SQL statement in the query, like such: Dim qdf as QueryDef set qdf = CurrentDb.Querydefs("qryPassThrough") qdf.SQL = "Insert SQL here..." The error occurs on the...

Hello all, I don't like the look of Combo boxes on forms, especially on Continuous forms made to look like a spreadsheet. I think the arrow is distracting, and since you cannot change its color frequently looks bad. My plan was to use two controls - a text box, and a combo box. I would have the...

Hello, I have an unbound combo box in the header of a continuous form. The box is set to value list, and when you select a value, the recordsource of the form is changed. This works fine. However, if I there are no records in the underlying form, the combo box is blank. If I check the value in...

Hello, I have a form that I use for navigation in my database. It consists of links to the left to swith between forms, and a subform in the middle. When a link to the left is clicked, I run code to switch the source fo the subform: me.subfrmFrame.SourceObject = "frmSubCustodian" I want the...

Hello, I was wondering if someone could point me in the direction of how to have a form open to the record it was on when it was closed. I know I've seen how to do this before, but I've spent some time searching and I can't seem to find it again. Thanks, Eric

Hello, I have a continuous form. On that form, I have a link (label) that a user can click to bring up a new form containing more info on the current record. The problem is that when the form opens, the first record is selected. If the user scrolls down to another record, and clicks the link...

I'm blanking on the proper syntax... If I have an IF statement in which I want to check multiple criteria, what's the best way to do it? Here's how I have it set up now: IF me.lstbox.itemdata(i) = "Condition 1" or me.lstbox.itemdata(i) = "Condition 2" or me.lstbox.itemdata(i) = "Condition...

Hello, I need to disable certain contols on a form. I am looking for a cleaner way to do it than I am. I do not want to disable all controls. Below is what I have now. What I'm wondering is if there is some way maybe to assign each of the controls to an array, and then loop through the array...

Hello, I have a database with a Listview control. When I start typing, I'd like to open a form that adds a new record, and have the letter I typed appear in a certain control, and then continue typing the word. I tried using the keyup event to open my form, and pass the value of the key...

Hello all, I'm working on a new database, and I'm not sure what the syntax is to select an item in ListView. Basically, I double click an item to open a form to edit the item. When I close the item, I have the ListView refresh (by rebuilding it). Of course, the first item is then selected, and...

Hello all, I'm looking for some table structure advice. I'm making a database that will track several To Do's. I want to have different List names (Projects, Next Actions, Waiting For, ect.). I then want to click on one of my lists to display the items in the list, which can have sub items on...

Hello all, I finally got TreeView to work, by downloading the example database from this thread. I haven't had as much luck with ListView, though. Does anyone have a database they could post that has a working listview? I'd greatly appreciate it!! Thanks, Eric

Hello all, I'm having a problem running a delete query. The query is designed to remove any previously existing relationships in a many-to-many table when you import an account that already exists. I have 3 tables in the query: 1) tblTmpImport - this is a table of data I'm trying to import...

Hello, I'd like an easy way for my users to be able to transfer data from Excel to Access. Basically, I'd like them to manually create a new parent record, and paste into an empty text box new child records. Then, when they clicked finish, I'd grab the info in the text box and put it in the...

Hello, I'm hoping y'all can help. I have two tables. The first table, lets call it tblData, contains a certain price of an item. The second table, tblRanges, contains ranges of an item to be used based on the price. For example, take Item A. If the price is between 0 and 5.99, apply a...

Hello, I have a subform that is based on a SQL statement that sums by Dollar Amount and groups by Account. I have it set up so the user can double-click on an account, which opens an unbound form. I then have the form execute a SQL INSERT INTO statement, which works beautifully. The form opens...