Search results

Hey no problem. I just dabble myself with computers as a rest from people :D

Thanks Cable, Works well and a good alternative to forcing data into a table unneccessarily. My only concern is with the ActiveX control. I purposefully avoid them due to known problems (or maybe I am reading too many heresay testimonies) :cool:

If the form is bigger than the window, why would you want to deny the user the opportunity of seeing and therefore using it :confused:

Create a table with the report names and descriptions. Make the query that powers the combo include the description field. Create an unbound textbox on the form. On the AfterUpdate event of the combo, set the value of the textbox ie Private Sub YourCombo After_Update() me.NameofTextbox =...

Good point :rolleyes:

The easy bit is storing the passwords, selecting the account and retrieving the correct password. The hard bit is reading the URL (try http://www.mvps.org/access/api/api0051.htm) and then automatically filling in the form fields with the required information...

It would probably be better if you post the code or an example of what you are trying to acheive.

Calculate the sums in each subreport then add them (or whatever) in the main report. You will need (in each subreports footer) a control that has the controlsource such as =Sum([FieldtoSum]) Then on your main report the controlsource would need to be something like...

There is no 'sider' and even using a subform on the continuous form is unlikely to have the desired effect as you would have multiple incidences of the same form for every record - not what you seem to be looking for. You would most likely have to have a subform adjacent to your current...

SportsGuy, Although your code will work well, I still think that the issue of hard coding the variables into code is not the best solution as you can use a lookup table with more efficiency as this allows for more versatility. Also guess how many of the variables in this statement are actually...

Be patient!! remember most of the UK are either getting their beauty sleep or are enjoying their leisure time right now :cool: As far as your question goes, I have quoted yo answering your own question! You have set your number returned with your strTopVal variable so you have lost me a bit...

If you are having to make complex queries to show what appears to be simple data design, it sounds like your structure is not optimal. A quick tip - always use queries to power your forms, not the tables themselves as these are more versatile to manipulation. You can easily show all clients...

I shall try to be your knight! :cool: A couple of further questions... If you change a previous value, do you want the following record to be updated? What exactly do you mean by it not working for new records? I would probably use different code (using a mirror recordset rather than...

Phew! I'm exhausted just reading it, no wonder Access is complaining ;) Personally, sniffing at that controlsource, it smells of limited database design (but feel free to correct me) as you seem to have a lot of fields in one table, indicating options chosen for maybe a little cruise on the...

There seems to be a bit of a conflict between the client and their authorisations. You state that a client with a code of N-02 can have authorisations but if the authorisation expires, you remove the N-02 code. Now you have to decide how you want to a) control the display of the clients b)...

I cannot access my Demo at the minute as I designed in 2k but only have access to 97 :Doh: The main difference is that tblComponents are linked to the tblCourses table ie 1 course can have many components. This is ok if the student enrols for a course and has to take all the componenets...

The best way to do this is to cheat! Create a textbox (invisible) with the ID of the record you want to print. Under this, create a label (or button for that matter) with the 'Envelope' Hyperlink on it. Ensure that the invisible textbox is on top of the buton/label In the on_click event of the...

With the Db structure you have, you will find the scheduler impossible to do. It is actually difficult to pull this off effectively so I would search this forum and comb through the relevant results as it has been asked a lot. If you persist with your current Db structure, expect impending doom :(

I hope that this is not a test ;) Couple of simple observations. Less Nesting of brackets - despite having a loop, mathematics are a lot more simple. No call to built in functions (CInt) You may of already done this but explicitly defining your variables will shave off a little more time as...

It is set for the particular Db, not by PC, so if you set it on your Db, this will be apply for every PC it runs on.