Search results

Hello, I have created the query as shown below, and it works fine when I click the View button, but when I use the SQL from it to create an ADODB recordset it contains no records!! Its part of an enhanced Switchboard I have, and it is driving me nuts!!! Can somebody please shed some light...

oh, and another nice Switchboard enhancement I thought was to use the 'Description' field above as the CONTROLTIPTEXT property for each button. A simple extra line in the Switchboard Code does this job nicely, so that when the user hovers the mouse over the button, a full description of what...

Further to my 'Enhanced Switchboard' thread, I almost have a great solution, but the last hurdle is causing me ENORMOUS frustration. I have added a field to the 'Switchboard Items' table called 'Description', and it contains a description of what the item does, so the option to print a sales...

I can see where you are going with that, but thats not what I want. I want to be able to go directly to a switchboard by entering some search text. It may be to run a report, it may be to do something else. For another example, I have one option on a switchboard to 'Enter New Sales Invoice'...

Excellent. Many thanks :D

I wonder if anyone can help me puzzle this one out. I have nearly 200 items in my switchboards table, and a lot more to be created yet. I have added a field to the switchboard table with a memo type, and put a description of what the item does in it. For example the Item Text might be...

Hi...I have a question. I have a form that lists some fields in a continuous form, one of the fields being called 'Include?' and of the yes/no type. The user puts a tick on the records they want to use, then clicks a button in the footer of the form to do a certain ACTION on the records...

Sorry guys...when I said I found a solution, it was an alternative way of storing the data, not really a solution to the problem itself.

WOW...thanks for all the input, but guys...handbags at dawn please. Thanks also for the ideas about speeding things up...they are helpfull too. :eek:

I have some queries that run from a General Module also, and with no form loaded except the switchboard...I guess I could change the title Caption on the switchboard to say please wait ....maybe...

Hi, Thanks for the input guys...I tried the using a 'Please wait...' type form, and seemed to work, until one of the queries was using the form data within itself...ie. the query contained me!fieldname references, and 'me' was now a dummy 'Please wait' form with no fields... Any other...

Hello Folks, I have some pretty complex queries that run with the docmd.runSQL method, and some take up to 30 seconds to complete. How can I put something nice on the screen to tell the user it is still working, rather than just having to watch the blue bar in the status bar, or wait for the...

Sequence No's It looked better when I typed it...I have found another way around the problem, but still would like to know how to do it the easy way. Here it is better spaced.... Project No__House Type____Bill Number 1000___________a_____________1 1000___________b_____________2...

Hi, I have a table with two fields...'Project Number' and 'House Type'. I have another table with three fields...'Project Number', 'House Type' and 'Bill Number'. Can I use an Append Query to create records in the second table, with the additional field created in the query as a sequential...

Thanks mmm...why didn't I think of that.... Have found great utility to do that for multiple databases etc...Thanks

Hi, Does anyone know any code that can tell me what users are currently logged on to my multi-user database? Thanks

Yes..but... Hi, I can and probably will do that, but it means the data in my version will be out of date, or I have to make notes of every change I make and import new tables/modules/reports etc. Can anyone advise me of a good hardware/software spec on which to place my back end database to...

Thanks...but... Thanks for that. I really do want to go back/front, and can see how much better would be to develop and distribute updated front ends, but when I tried it was very slow and in fact some code just locked the machine every time I ran it. At the moment I have a Windows 98 network...

Hi there, I am developing an application with several sections in a multi-user environment, and want each section to go live as it is complete. I read about splitting into Front-End and Back-End etc, but found problems with speed and reliability when I split it, so I am keeping it all in one...

Thanks Thanks for that...