Search results

So there I am booking a well needed family holiday, two adults and one child. Enter names, ages, etc. Make payment and then wait for email confirmation. All is well. Next day I print off the flight details, hotel booking, insurance etc but then notice that my 5 year old has the name of Guest3...

Recently moved from Office 2003 to 2010 and found that I am unable to open more than 15 workbooks simultaneously like I used to be able to do in 2003. Previously I simply chose select all then right clicking would then give the option to open. I noticed in 2010 I can not do so this unless I...

Any idea why the ability to view the properties of an object within a form is not available when you double click on it in design view? I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me...

Hi, Our lovely IT dept without warning as taken it upon them selves to convert the current access database that I manage to SQL server and seeing as I have no clue about SQL server I need some guidance through this process & hope some of you will be happy enough to answer some of my questions...

I have a query that is used to capture all the fields that can be possibly used. When run & exported to excel the user then simply deletes the columns with the fields that they don't require. We do this so we don't have to keep creating queries over and over again when you just use one that...

Hi Guys, Anyone know how to prevent duplicates on the combination of two fields - text & numeric? I'm currently using the code below that warns users when the combination of two fields have already been used. (Combination of the TWO fields has to always be unique so if used again will warn the...

Any suggestions please? Been experimenting on some code to prevent deletion or changes to records that meet certain conditions. The problem I am having is the code is contradicating each other preventing some of the records to be locked down. Private Sub Form_Current() 'Code 1 - Prevent...

My wife has recently passed a couple of exams working towards obtaining MOS certification using Office 2010 I'm still using Access 2003 & was a little curious to see what it was all about so I tried a few of the on-line test questions to see for myself but quickly failed on the first three...

Having problems with my dvd burner that I normally use to save all my database backups to. Using windows scheduled tasks I was able to use a batch file that was run each evening that would save my data to another location on the network. Only problem was that it would overwrite the previous...

Just read this on my works intranet site :eek: They don't know what they are talking about :mad:

Anyone know how to change the text in a cell depending on the value of another? If the cell has a negative value then the text will read "Over Recovery" Need to to then change to "Under Recovery" when the value changes to a positive value. Thanks

I acted as Guarantor for my best friend when he & his family rented a property about 5 years ago. I have never had any problems with this & actually forgot all about it until I received a letter from the letting agency. The letter stated that they signed a renewal aggreement & that I am...

My workplace is currently going through a restructure & it's been decided that most of our job titles are to be changed because of the fear of being seconded by "others" if it's found that the "others" claim to do what we do. Wanting a better job title anyway I was keen to finally get one that...

Hi All, What type of job titles do people generally hold that work with Access databases? I used to be down as an ICT admintrator but that will be changing shortly & I'm hoping to get something more suitable to what I do. I'm going to be classed as Senior Administration Officer but that...

Hi everyone, Need some advice please I have a database (v2003) with a front & back end, each user has a copy of the front end & the back end is situated on a local server. There are about 30 users each having their own user name & password, but there usually never more than 14 users logged in...

Not sure if this can be done or not but does anyone know how to display the contents of a folder using Access. I was thinking possibly viewing it using a list box like you do when it's based on a query then when a file within the folder is selected it then opens up the file ready for updating...

Anyone know how to keep the hyperlinks when exporting to excel? My db table has a field called FilePath & I've set the data type to Hyperlink which is great when viewing the links via a query but for some reason when I export the data to exel the hyperlinks do not move across :confused: All I'm...

Hi all, I'm trying to prevent records being entered outside a time period & I'm struggling to work out the best method of doing so I've been trying If Me.txtStartDate <= #3/13/2010# Or Me.txtStartDate >= #3/12/2011# Then MsgBox "This date may be incorrect please check your records & try...

Hi all, Can anyone help me please? I'm trying to reference a mobile no from a subform but can't get it to work Basically a mobile phone no is displayed when a user sends an SMS message which should allow the recipient to reply to it. I have a table with all the windows login user names along...

Happy Birthday Hayley :)