Recent content by NoelMG

Hi, Thanks for your reply. The BIOS is seeing the first 32GB of the drive, the tools told me that was normal as it can't handle more than 32GB, there is some sort of driver for the rest. If I try with just the old drive connected, it tries to network boot the machine, then reboots. I'm...

I'm having major problems installing a new hard disk. Basically I currently have a 30GB that I want to use as a second hard disk, replacing the main disk with an 80GB that we have bought. I used the "Data Lifeguard" package after I had fitted the disk, it came up automatically. However, an...

Hi PH I've just tried your SQL, but unfortunately this brings up everybody regardless of whether or not the boxes are ticked on their record. Possibly because when the boxes are blank, it's recorded as a "No", so it's saying pick up the field if it's yes or no? Thanks, Noel.

Hi all I have been trying for weeks with no success. I hope someone on this wonderful forum can help! Basically I have a form that has 5 checkboxes - BrandDirector, Marketing, Stakeholder, Aftersales and Sales. There are checkbox fields in a table with the same names. Basically, the user...

Thanks so much for that Roy - I used Me.refresh and it worked fine! Had no idea it was something so simple! Cheers, Noel.

Sorry I guess the code I'm using behind the button would help! Private Sub Command25_Click() 'Dim stDocName As String Dim outApp As Outlook.Application, outMsg As MailItem Set outApp = CreateObject("Outlook.Application") Set outMsg = outApp.CreateItem(olMailItem) 'Set status as Not...

I have a continuous form (it's an Action List) in an Access database. Basically, I want the user to click the Submit button and it to run some code to modify some data, append to another database and send me an email. The "Submit" button is against each record. The code is all working...

Sounds good - I'll have a go and let you know how I get on! Thanks, Noel.

We are importing data from a spreadsheet, which is generated by a website from registration forms that people fill in. I have to get the data into the database, and in the right format etc and have got 90% of the way there with the rest of it! Trouble is, a lot of the options are in different...

Right the problem was a missing bracket - the rest of the code worked. I'm now getting a message "No Value Given for One Or More Given Parameters" Not quite sure where this is from - it's not being helpful and showing me where it is! Cheers, Noel.

Hi there We've just copied the SQL from the query builder and added line breaks in - we haven't touched the SQL!

A few of us have looked at this SQL that is in a module and just can't figure out where it's going wrong - we're getting loads of problems getting it to work - I've transposed it from the SQL window to the VBA window and inserted line breaks etc but think somewhere it's not worked properly...

The code I'm using so far is: SELECT tblPeople.[People ID], tblPeople_1.[People ID], tblPeople.CoSponsor, tblPeople.[Known as], tblPeople.[Surname Known As], tblOrganisation.[Organisation name] AS [Company name], tblPeople.DinnerTableType, IIf([tblpeople_1].[known as] Is Not Null,"Co-Sponsor...

The database keeps a record of people attending a Gala Dinner and is intended to show who is co-sponsoring a table with whom. For instance - Joe Bloggs could be co-sponsoring a table with John Smith. The user selects the person the delegate will be sharing with from a combo box which places...

Fixed it! I had a missing reference in the VBA code which I removed, and hey presto it works a dream! Thanks all!!