Search results

I have used the following code to validate UK postcodes in an Access 2003 database. Everything works fine with no apparent problems. However, I have given the database to a friend who has Access 2007 - when he tries to enter a postcode (in the postcode field on a form, that has the function set...

Hi guys, I have searched for an hour now but to no avail! Can anyone tell me how I enable the XP style for my Msgbox buttons? Any command buttons I create on forms are in the XP style but when I use Msgbox in VBA they appear in the old flat (ugly) style. It must be a simple thing to do - I...

I copied and pasted all of the code from the Northwind sample database that allows you to add/change an employee's photo. I checked I have all the same references and have declared all variables but I still get the error "Compile Error: Variable not defined" at ...

I have checked the forum for tab colour/color and there is plenty telling me the background colour of the tab control but I couldnt find a single thread on the actual colour of the tab - you know (in Access 2003 anyway), that sort of off white colour. I have put a subform onto one tab but I cant...

I have used the Calendar created by Brock W Denys that works within subforms (see attached). Its a great calendar and I am very grateful for the use of it. However, it only works for forms and subforms. Unfortunately I need it to work in a subform within a subform within a form! I am as good...

I am a complete newbie to vba and I am sure I end up writing far more code than I need to. For example I needed to disable all but one control on the oncurrent event of a form and so I wrote: Me.controlname.Enabled = False Me.controlname2.Enabled = False etc etc I did this for 13 controls...

Why is it that auto center doesn't auto centre? Yes it centres horizontally - but not vertically. Does anyone know how to actually center horizontally and vertically i.e centre!? (I have used both spellings in order to appeal to a larger audience!)

When I exit my application I sometimes (about 1 in 5 times) get an error message (see attached jpg). This doesnt make any senese to me as I am closing my application NOT opening it. Is this happening because my mdb is corrupted? (I compact and repair on close)

Cant find what I am looking for on the forum so if anyone can help me or tell me what to search for that would be great... I need one of my forms to display a running total of updated records, but only those records that the user clicks a command button on. i.e if i have a recordset of n...

Help please guys! I have searched the forum but can't find anything specific enough for me to work with. I have a form that displays the results of a query one at a time. The user then checks a few boxes/fills a few fields before clicking OK to move to the next record. When the user gets to the...

I saw the solution to this on this forum a while back but no matter what I search under I cant seem to find it again! Can someone remind me how to change the Title of the error message boxes I can change the error message - by changing the Err.Description - but how do you replace the...

Having researched further I am now under the impression that I can actually make my db available THROUGH my website i.e through the users browser (does this eliminate the need for Access to be installed on the users machine?). From what I can gather (and I am not at all clear with these things)...

I created a stand alone db for my brothers business (it holds employee records, customer records and order details). Up till now it has always only had one user (my brother!). However, he now wants to have multiple users (not always to be logged in at the same time) and so is getting his...

I am a novice to db design but I started my db quite a while ago but have only just noticed it keeps doubling in size periodically, even though I have not added many records or changed much. The first time I noticed this phenomena it was at 65Mb (already too big?), it then periodically (and...