Search results

Change the colour of a text box depending on it's value WORKED!! Thank you Cosmos75, Your solution was brilliantly simple and yet highly effective. I read your instructions and thought I understood what to do, but ran into some trouble when trying to do it from scratch. After going through...

If value Then Colour ElseIF value Then Colour Changes all fields Thank you for all your replies. So far I have tried what you suggested Smart, to use the If value Then colour ElseIF value Then colour statements. I hadn't thought of doing it this way. After applying that [Event Procedure] VB...

Hello fellow programmers, I have a tricky one for you. We have decided to split our local City up into different zones. Giving each zone a number and assigning it a colour. I have a form with all the customers who want jobs done in different parts of the city. This form has a text box on it...

Replacing Wireless network with ethernet cables helped a little Hi ghudson, I took your advice and tried to hardwire the wireless network instead. It showed small improvements in the db access speed. Also, the FE doesn't seem to be locking up, or timing out, it does get the data from the...

I have completed a database for a company with 60 000 clients and over 100 000 job records. The database works at very resonable speeds on the Server computer, or the computer on which I installed the back end of the database. Each of the other 3 computers on the wireless network, have a local...

Cannot Import or Export User-Defined Outlook Fields I found this article on the microsoft website about some of the issues with this problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;294705 I still haven't worked out how I can apply this info to my problem yet.

Importing Outlook Contacts into MS Access - Problem Creating Unique ID in Table Hi there, I'm trying to go the other way. I'm using Outlook to store all my contacts. In Access I've imported a Linked Table linking directly to my Outlook contacts. However, I can't Create a Unique ID. I want...

Hi ppl, I'm just about to install a database this week. However, I'm trying to provide a "Back up Database" facility. I noticed there was some code floating around to do this. However, I was hoping just to put it in the File Menu so users could backup manually. I have set the Startup options...

The VB Function for Converting OpenAccess Time to MS Access Time Well I'm certainly learning heaps about how time is stored in databases since doing this database project. After all the messing around, I've finally come up with a simple Function that takes the OpenAccess long int value that is...

Calculation to Convert Open Access database time fields to dBase3 format Well, after all my messing around, I found out what some of the problems were with the calculation. I found the Open Access Users Group has encounted this problem before and they have written an article about the...

Update Query Worked Successfully - Thanks! Uncle Gizmo your a GENIUS!!! I didn't realise you could use a function in an Update Query. It makes a lot more sense to me to do it that way. I find it easier to understand. I hadn't noticed the Update query and the test table data you had provided...

Connect to Table and UPDATE Time Field with Time Matrix Function Thanks for cleaning up my function code Uncle Gizmo. In Open Access, the Time value is shown as normal, e.g. 12:00 AM. Let me call this "OpenAccessTime". However, when the OpenAccessTime field is imported into MS Access, the...

Use SELECT CASE statement in UPDATE query in VB Module, to convert Open Access Time Hi people, I'm working on upgrading an old DOS Open Access database for a carpet cleaning company. All the fields were imported into MS Access fine, EXCEPT the time field. This was imported as a Long Integer...