Search results

That sounds a bit over complicated to me, but then I don't know what I'm doing half the time. I ended up getting round it by shoving this in the load event of the results display form; Private Sub Form_Load() If IsNull(Me.cboRoomID) Then MsgBox "No Records", vbInformation...

I have a database that holds hardware data. It's working fine, but there's a slight itch I'd like to scratch and I'm not sure how. Very simply, I have a table listing printers. I have a search form with combo boxes called 'cboRoom' and 'cboDepartment'. The room and department fields in the...

Heh, easy as that eh? Thanks.

It's not a database of our design, it's some third party thing specifically for schools. The company sends out an update by way of these table roughly once a year but they're all named wrong, every time, every year, despite us telling them over and over. Why there's so many tables I don't...

Sorry I haven't got back to you guys sooner on this. The guy who was trying to do this ended up taking a copy of the database home and renaming them all manually...took him about three hours! It's something that happens oncea year though so your help won't be a total waste. Thanks, Steve Swallow

McIrvine, thanks for the quick reply, but I've just this minute solved the issue (or done it a different way). What I ended up doing was creating a form with three combo boxes, referring to those combo boxes in the query and setting the record source of my form to the query. Hitting a "Search"...

Kind of related to my other post but a seperate question. I once saw a database where the designers had created a form that at first sight was blank. You could click in any of the many text boxes on the form, enter some data, click a command button labelled "Search" and it would display all...

Hi, I've found some similar issues by searching around here but none have been quite the same as my issue. I have a form that display PC details. It's not set up in any special way and allows additions/edit etc. It refers to one table with all the PC details in it (tblDesktops). We're...

Thanks, I'll have a play with that tomorrow (I work at a school so I finish early). Ste

Pseudo(ish) define variable varTableName as a string for varTableName = the name of a table remove the "STUD_ADMIN_" from varTableName rename the table as varTableName next table end somewhat messily Ste

Thanks, I'm aware of that. Luckily the database is just a collection of tables at the moment with no relationships set up (I believe they were imported from elsewhere). Ste

Nope, NOT an access guru. SwiftCS is my own domain name, so anything can go before "@swiftcs.co.uk". I organise Outlook that way. Everything to that e-mail address automatically goes to an Access folder...helps to filter out spam when I join websites (I use crap@swiftcs.co.uk for that)...

Thanks for replying. I am however a noober, and although I found the tabledefs object in the help, I've no VB knowledge and I didn't really understand any of it. I can't see how I'd change the name of all tables using a module using this object. More prompting..? Regards, Steve

I've been asked to come up with a way (one-off) of renaming over 100 hundred tables. The table are all called "STUD_ADMIN_blah". We need to remove the "STUD_ADMIN_" part of the table name. Is there a nice easy way of doing this without having to physically rename each table individually...

Doh! Oh good grief how obvious was that...I was looking for a similar propert in the subforms properties! Thanks!

I have a form which I use for call logging. I have created a subform which, when a client reference number is selected from a combo box in the main form, the client details appear (address, telephone number blah). It works fine but for purely aesthetic reasons, I want to make this subform...

Thanks. I had tried something similar but just ended up with more #Errors...I was on the right lines but couldn't reach the finish. Thanks again. Ste

I'm having trouble with a text box, which is trying to sum some date in a subform. All I get is #Error, yet I'm sure I'm referencing the item in the subform OK. I've attached the database as it's self explanatory (I stuck a label on it). The form I'm having trouble with is...

I thought it had to open the query to run the query to then refresh the subform. Obviously not :rolleyes: Thanks, Steve

Great Stuff Thanks guys...that's got me on the right foot. I now have a silly problem. The form itself works...I put in a start and end date, click my query button and the results appear in the subform below. Unfortunately, the results also appear in the usual query results window...here's...