Recent content by DanMurphy

It ultimately depends on what your users will be doing and the server the database is on, if all they are doing is basic data entry then you can have more than if they were running many complicated reports. Could you give an idea of what the database is for?

Hello An idea for my database, but I have an issue I am unsure how to handle. I have a picture of a sample table attached. CommandmentID is the primary key, CommandmentSet is a foreign key, with the other two fields not having an index. Is it possible to set the CommandmentNumber field to...

Newbie myself, so this may not be the best solution, but I had to do something similar for only a couple of spaces. Expr1: [Table]![Field] & Chr(32) Will add a single space to the end of a field in a query. You can also get tabs by using Chr(9). :)

Hello I am not sure if this is Macro, Word or VBA discussion, forgive me if this is the wrong section. I have a database for which I need to automate a mail merge. Want I would ideally like it to do with the press of one button is 1 - Open Word Template 2 - Merge to new Document 3 -...

Hello My office has a database that manages a small number of direct debit collections. Our Direct Debit software connects to a table to collect information, that table is filled by data from a query. Unfortunately, we need to prefix some currency figures, however the premium amount appears...

Hello I have a textbox on a form for entering addresses into a table, It is so that a user can copy and paste an address into a textbox, and it will split the string into the fields I have on a table (So that I can copy and paste an address from an email into my database quickly). A picture of...