Search results

Nope, double click is good for me ;) And thanks for redoing that code for me, it now runs as it should. With reference to my earlier query, would I be right in thinking that to activate the two text boxes (Doc and Doc2) on the form that users will be looking at, I need to add the following...

Hokay, I can get this to almost work now, but there are a couple of things I'm still a little uncertain on. I include a copy of the form with which I'm using to add Invoices (hyperlinks to my word documents) to my records. The table which holds all of the database information has had two...

Thanks. I knew there'd be a simple solution :)

Just a quick query. I use a Switchboard as a main menu for the various commands on my database, but have noticed that the standard 'Exit' command will only close the database, leaving an empty copy of Access running. Since my database is also used by some people who are not as computer...

Thanks all. Much appreciated.

I currently have a databse which - largely thanks to a lot of you on these forums - now works perfectly and does pretty much everything I need it to. I've recently added some new commands to the main switchboard, and am now getting a little bored of the flat, grey-buttoned look of the databse...

Managed to solve this problem now, but I'm going to post the answer here as well just in case somebody ever has a similar problem and pulls this thread up in a search. DOS can be controlled with the following code: call Shell ( Environ$ ( "COMSPEC" ) & " /c c:\test.bat", vbNormalFocus) The...

Hhmmm...it would appear I have been a little to hasty in my jubilation. The code works brilliantly, but when I try to incorporate it into my database I run into problems. Essentially I have removed the ID field (since I don't need it), and changed the record source for the Student field from...

Jeff, you are indeed the proverbial icing on the cake! This is exactly what I'm after. Thanks a lot. :D

That's just it, there isn't. The only thing which really defines both the record and the invoice is the student name, but the invoice cannot be so named. It struck me that I could add a new field to the table of data and call it something like "invoice". I could then give the invoice number...

I have a form which is linked to the table which holds the data. The form just sets the various table fields out and makes them look pretty, and the same form is used for every single record, hence my adding any buttons (and associated code) to the form will cause that same button with the same...

Hmmm...I see what you mean, and again that would almost certainly work, except for the problem that the name field of the student is kept to a name format - and must remain so, whilst the name of the document relating to that student is nkept to an invoice number format - and must remain so, so...

I see what you mean, and yeah, that probably would work. Unfortunately the invoices themselves are stored in various sub-directories, depending upon the course type. It looks as though it isn't possible without shifting the documents around, which isn't worth doing just to get this button...

Thanks for reply, Wayne, but I'm not too sure I get what you mean. Surely if I insert that code then the button, regardless of the record being looked at, will always point to the same Word document. For example, let's say I have a student registered called Rosencrantz. Rosencrantz has an...

Quick question regarding form buttons This query really isn't essential in any way, I'm just in the stage of trying to get my perfectly functioning database to do increasingly clever things. Essentially, I have a database that stores details of students (course dates, names, etc.). Each of...

"Why wouldn't exit work?" That's just it. I've no idea. My batch file runs fine, and my DOS knowledge, whilst not excessive, is good enough to know that my file contains no errors or problems. Why it runs the program then keeps the window open despite the 'exit' command is a total mystery to me.

The title pretty much says it all. I currently have a Macro in my database that, without going in to too much detail, runs a small *.bat dos program on the hard drive. The program runs fine, as does the Macro that executes it. At the moment, once the program is run the DOS window that has...

It works! After four pages, two uploads and repeated confusion on my part, the monster I have created lives!!!! thanks so much to everyone who pitched in with advice. I now have a database that works exactly as it's supposed to. Virtual hugs all round :D

Option 3. To give the context, the database has to be able to show which students (who are in the database long before they actually start their studies) are arriving and which are leaving between any two dates given (the From and To on form1). This is normally a weekend, given as a Friday to...

Ummm...anyone? To recap, I need the search facility to filter records between and including the two dates entered, but these dates must be from two different columns (the Course Start and Course End fields). Rich's code works fantastically, but only filters records from the Course Start...