Search results

I have been given a procedure from the development team that calls a price from a secure database. I pass three variable to the sub (forcast, settlement date and period number for a given half-hour). I need to loop through each record in the data and print out the results to a new worksheet...

Search the forum for "cascading combo boxes" imo

As an addendum, you will generally want to stick the code in the AfterUpdate event of the initial combo box (or check boxes/whatever) as to whether I want the next controls to be enabled or not. If I want cmbNumberTwo to be disabled when cmbNumberOne contains a certain value I'd generally do...

Are the file names stored in your db (in a table) or are you referencing actual physical files in a location?

Test them in a similar manner but use the .enable property for the desired control!

It's kinda the opposite to preventing error! Anyway. If you really insist on it just delete that in design view, create a text box and in your query change "Combo4" to the name of your new text box. Then, in the click event of your button to open the query add this code: Dim strIdNumber...

You can do that it is just a waste of time! Also, if you start typing in the combo box it finds the one you want anyway. Honestly, this method is far quicker/easier/efficient. And I forgot to alter the query!! Apologies.

Try the attached. I assume you want to search on codes you already have. Select the relevant on from the combo box and open the query. Using the combo eliminates user input. Get back to me if this doesn't match your needs imo.

Use a text box on a form. Enter this is in the criteria field of the query: [Forms].[FormName].[TextBoxName]

Hi Neil, Thanks for the reply. I now have a form based on a query etc. I am having a bit of trouble creating 3 records at a time. I think I need subforms. I have a thread in the "Forms" forum for more info!! Thanks again.

Guys, I now have two subforms on the main form, one for D+1 and one for D+2. At the moment they are just showing records from the first column of data which isn't quite right for a couple of fields, they are also not creating nwe records just displaying them. Does anyone have any advice on...

Attached is a JPEG of what I hope to achieve based on the left hand column of data.

Hi guys, I have a form bound to a table that records actions. For a given record I enter the date, date+1 and date+2 along with some details. My structure, rather than record 3 dates in one record, is to add 3 records to the table for each date I am forecasting for. As far as I understand...

Morning all, I have a small project to set up a db to record the decisions of a tool we use for within day, D+2 and D+2 forecasting. Would it be more prudent to set up a table with these three fields in or just have one field for "decision" and two date fields i.e. "RunDate" and...

Hi Gemma, I sorted the query and implemented FindFirst and it does indeed seem a bit quicker! I assume FindFirst doesn't load the entire recordset? It's not a large application but I wanted to make sure I'd applied the correct technique!

Hi guys, I have just read an article in the Wrox Access VBA 2003 book stating that SEEK is way better than FINDLAST if applicalble to your project. Below is the code I currently use to open a recordset relating to a customer and check the last instance of correspondance. Set rsC =...

Look up the DateDiff function

Hi guys, Just a quickie hopefully. I can return process names etc. ok. Is there a way to do this for the applications?

Haha very sick, thanks so much Brian. Much appreciated.

Hi Brian, That *IS* the case. Say I pass one forecast for a given site for a given settlement date a week before belivery. Then, I get some information like a new weather forecast or something, so I adjust my forecast based on my new data. Each unit can have many forecast dates (the date...