Recent content by Meinthecorner

Each template has on average 6 unique fields, each template is different. So 6 fields and 20 templates leaves me with roughly 120 different fields. I'm looking forward and can see more templates being added as different products \ services are created.

Hello - Need some suggestions on the way forward with a Form \ Report design. There are two parts to data, 15 fixed fields, ie customer name, address, tell, serial number etc all laid out in a MS Word Document. The second part currently consists of 20 MS Word Docs that are just numbered lines...

I'm not going to Automate the import. The end process links this data to other tables, runs a few queries that are pushed to another spreadsheet. It's been working fine for months as the original data was numeric only. We've since updated our main system that uses Alpha\Numeric job numbers...

Its coming from an Excel spreadsheet. When I paste to Notepad its fine. If I sort the Excel Data into order so that the mixed data appears at the top of the list it pastes fine i.e. 260H 164H 72H 261H 442513 442390 442473 442542 437284 442500 If the data order is mixed, the paste fails.

Hopefully somebody can shed some light onto this, it's driving me nuts! I'm using Access 2007 I need to paste a column of data into a table. The table field is a standard text field. The data is a mixture of numbers and numbers with letters, i.e. 442513 442390 442473 442542 437284 260H 72H...

Thanks for the reply. I needed static column headers, so they are now acting as the dummy values. :)

I've now worked out a way round this. I've changed this part Sheets("WeeklySummary").Select Cells.Select Application.CutCopyMode = False Selection.ClearContents To a range starting from cells.select to a Range starting from A7:BH300, with the column headers in Row 6.

I have a sheet (AgentSummary) that lets the user cycle through a number of employee giving a score for various performance areas. There scores give a balanced score for the week. On a seperate sheet (WeeklySummary) the employees are all listed by row and week numbers across the top. To save...

Thanks Peeps, changing to a 2 sorted the problem :)

Access 2007, Crosstab query . Evening - We've just started opening our business on a Sunday and this little issue has just manifested itself! We record volumes of calls previously just Monday to Saturday and the call volumes are grouped by week number. Which worked fine, now we open Sunday the...

Right I'm stumped. I run a small football based competition at work. The players predict the outcome of random matches throughout the leagues. What I want to be able to do is run a query to simply show each PlayerID against that the highest score they have got and the week that occoured...

Sorry ignore the system.mda string, so "C:\Program Files\Microsoft Office\Art\office\MSACCESS.EXE" "C:\deeley\DeeleyFE.accdb" I haven't got the Access 2007 runtimes installed but have a look around the c:\program files\ folder for the files. Or install the runtimes on a empty machine and then...

Ah right ok. When I've been testing my Frontends with Access Runtimes I normaly just create a shortcut to the Frontend file then modify the properties of the shortcut so that it launches the Runtime msaccess.exe instead of the full version. For example on my works XP Pro machine running Access...

Generally the Runtimes are used for Frontend users who are running the Client side of the database. It gives the users access to your forms, queries, reports. It wont allow them to design elements of the database. As an example you can roll out the Runtimes to all your users without the need to...

Fixed! I feel like beating my head against the wall as I kind of answered the question in my first post. I moved the password table to the frontend instead of it being linked to the backend and it solved the problems. Thanks dkinley for your pointers :)