Search results

Just realised that I've been mistakenly saying "Record Source" when what I meant was "Row Source". Thanks, -NS

Humm, I'm unsure now. I basically need what you have just described but depending on what is chosen in the first combobox, the second combobox will need to display different columns (if that makes sense!). Thanks, -NS

Sorry, I meant do I need to use an IF to check what has been slected in the first combo box. For example... IF ComboA = "Region 1" Then recordsource = "area1qry" ElseIf ComboA = "Region 2" Then recordsource = "area2qry" ..and so on. Thanks, -NS

Thanks for the reply Dave. I just have a couple more questions... Would this method be used as part of an IF statement? By "somequery", would this just be the name of the pre-made Access query or would it be an SQL statement? Many thanks! -NS

Hey all, I'm basically trying to change a combo box's record source based on another combo box. However, to make matters a little more complicated (at least for me!), depending on what is slected in the first combo box, the number of columns in the second combo box will change. They will...

Hey all, Basically, I have a subform and each row in that subform has a little button. What i'd like is a popup form to appear when that button is pressed which displays a comments field for that particular record. Each record (and therefore row) has its own ID so I guess I need to link the...

Thanks for the replies. It tunrs out that I just needed to save the current record before requerying! -NS

Hey all, I have a simple form with a combo box that filters a subform. However, there is a little issue when the user clears the combobox by clicking in and deleting the text then hitting enter or clicking out of the combox box, it produces an error (and if in runtime mode, it will close the...

Hi All, Could really use some help on this one! I have conditional formatting on a text box in my form that makes the text red if the value is equal to or less than zero. However, when the number drops below zero, for example -2, the text does not format to red! Anyone know a way around this...

Hey all, I'm needing to create a page that will contain some standard text and will be printed duplex so it always appear on the back of any report I generate. Is this possible with the reports in MS Access 2007? Any help is appreciated! -NS

Hey all, I'm not that used to reports in Acces. I was just wondering if it's possible to have a combo box actually on the report, perhaps in the header? This would be used to filter the report for sprecific customers. Also, out of interest, is it possible to SUM and COUNT etc in a report? or...

Thanks Taruz for your solution. I was trying to avoid VBA if I could...is this possible with some sort of Update query or similar? Thanks, -NS

Hey all, Please can someone let me know if this can be done in a query?.. If I have a total figure stored in a table, and I enter a new figure in a form. Is it possible to add the new figure in the form to the total figure in the table? For example, if I have 10 stored in a table, and I enter...

Thanks Paul!

Hey all, I'm sure this is pretty simple but I cant think of the answer! I have a subform that displays records that have been entered. What I would like to do is only display records a month previous to today's date. So, if today's date is 30th Sep 2011, I would like to display all records...

Thanks for the pointers people! I think I'll go the calculating route rather than keeping a stock total in the table. Just one small question. Roughly how large (in terms on number of records) do you think it would take for it to become too slow to run? Also, any hints on how I might split the...

Thanks for the reply Paul. Please can you let me know what you mean by 'SQL Server view'? Also, am I right in thinking, if I chose to calculate it on the fly, I would have to look at every single IN/OUT transaction of, say, Tin of Beans? For example: In: 10 tins. Out: 5 tins. The database...

Hey all, I'm working on a stock control database. Very simple stock in/stock out kind of thing. However, I would like to know the best way to achieve calculating the totals of each product that we have in stock. At first I was going to simply use the stock in/out and calculate the total left...

There are only a few test records in at the minute, less than 10. The forms take a very long time to load normally but when I run the frontend in Runtime it becomes reasonable.

Hey all, I have developed a database and would like to speed up the loading of certain forms. I have a frontend/backend design. I am thinking about using a splashscreen that stays for a few seconds befoe loading the main menu form. I was wondering if I can utilise the time the splashscreen is...