Recent content by newmanje

Thanks Skip but I'm still struggling. I'll try it again in the morning and see if I get anywhere. Jim

I need to produce a spreadsheet that will allow me to team up members of staff and tally their weekly sales points. It needs to show me who is paired with who each week. The difficulty is that the spreadsheet needs to randomly pair up 2 members from the staff list each week then at the end of...

Free at last. Roy and bboffin's code worked for everything but the forms - these still turned out to be corrupt. I subsequently used their code for all objects except forms, copied the code for the forms using DeanWilliams' code and manually pasted it back in (as suggested in Microsoft's...

Hi Roy, Thanks for the help. It wouldn't work in the corrupted database as it now refuses to allow any code to run (gives the 'Network connection error' every time. I'm about to try and see if I can find a way around this as the code both bboffin and you have seems like it's perfect for the...

Hi Dean, I'd already decompiled and that didn't work. That's why I'd found your code for exporting it and saving a whole load of time in the process - a lifesaver. I've reversed the code to set the HasModule to true for the forms and reports it's just importing it from the text files that I...

Thanks Roy. I'd already tried a decompile (as to date that has got us through previous problems). This time round it just didn't want to work so I went hunting for alternatives. I'm sure there's a cleverer way to import the text files than manually copying and pasting. I know someone's brain...

Using Access2k I am currently trying to recover my database from the 'Network Connection Lost' problem caused by importing objects from another database. I have used DeanWilliams' code to export all objects to text files and set the HasModule property to false. I have now imported these into a...

I'm trying to work out how to do exactly the same thing. Did you have any luck? Jim

What I need to stipulate is the Vendor but it only returns detail when I stipulate a brand as well. SELECT returns.[Store #], returns.[Customer Name], returns.[Repair #], returns.[Date out], returns.Brand, returns.Vendor, returns.Qty, returns.[Style #], returns.Colour, returns.[PLU#]...

I am trying to write a query in a database for my sister. The table I am trying to query refers to a lookup table for two fields. I need to be able to specify data for one of these fields but every time I try it fails to return any records. They are both text fields and one of them is the...

Have you tried creating two separate tables: tblCustomer tblOrders You should then be able to link the two with an ID field then display the data you need. James

Thanks SQLSister, I've just taken a look at a sample of the data and can see that there are also a number of records where it has listed surname followed by firstname then records where firstname is followed by firstname. I suspect I am going to have to go through this manually.

Hi, I have just imported some data that includes a field for an applicant's name. The field has already concatenated a first name, middle initials and a surname. I need to extract this to two fields - FirstandMiddleName and Surname (the first field to include any spaces and middle initials if...