Search results for query: *

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!!

Hi Tony, the full code in the query is as follows: SELECT UPDATES2.cn, UPDATES2.type, STATUS.type, UPDATES2.model, UPDATES2.exreg, STATUS.status, UPDATES2.Field6 AS Operator, Mid([Operator],InStr([Operator],",")+1) AS Expr1 FROM UPDATES2 LEFT JOIN STATUS ON UPDATES2.cn = STATUS.cn WITH...

Hi Tony, Does this need to go into the actual query? I've tried this, only when I run the query I get: Compile error in query expression '=Mid([Operator],InStr([Operator],",")+1)' Thanks! Noel

Hi guys and gals, I'm trying to split a field down in a query and to be quite honest don't know where to begin! The field I am splitting is called "Operator", and some of the records have a comma in them and some not. I would like to split after the comma. For instance, I may have British...

Hi there I'm trying to put some code behind a button to insert an ole object. The field in my table is called ImageLocatin, and when I click the button I want it to look for the jpg in the location specified where the jpg is called forename surname.jpg, and insert it into the relevant field...

Hi Martin Thanks for your reply, very useful. I think I'll just look at getting a new system - the processor is only one part and for a good all round improvement in performance I'd need more than just the processor anyway - and to get to anything like a good spec would probably mean spending...