Search results

Hi When opening MS Word, the default picture layout when pasting an image is set to "In Line With Text". Unfortunately, this layout does not permit the grouping of pictures. Through the options screen, I changed the Insert/Paste Pictures option to "Tight" as per attached screenshot...

I have an excel sheet and one of the columns store the name of a country. I would like to see how many times each country features in this list e.g. Spain 5, Italy 5, Germany 4 etc I can do this easily in Access using a total query by grouping and use a count, but I am stuck how I should go...

Hi I have a field which I use it a lot to search for a series of characters within its text. Am I right in saying that by adding an index on this field it wouldn't produce faster results? My reasoning is that with this type of query there is no means of establishing where the index tree should...

I have a table in a database and I am planning to divide it in two tables. The current table contains information about stamps and at present it also contains 3 fields to contain the number of duplicates of each stamp. The table is as follows: tblstamps: stampid, stampdescription, yearofissue...

When printing some vba code from the vba editor is it possible to include the syntax highlighting in the printout rather than getting all the code in black font? Thank you

In Access 2007 when creating a button using the command button wizard, when I click on the ellipsis to view the code created, the Macro Builder is displayed, showing the actions that make up the embedded macro. Is there a way to view the vba code rather than the macro as it used to be in...

I have a small database which takes care of my stamps collection. The main entities of the database are stamps, collectors and themes. Although the structure of my data works good and with reliable performance, I have a question regarding the stamps entity with regards to normalization. Apart...

Isn't it frustrating to see a spammer posting about 5 posts in different sections in a matter of seconds and then ironically you read at the bottom of the forum; Welcome to our newest member, SpammerName :mad:

Hi, I have created a query from two tables which returns personal info such as firstname, surname, idcard etc. Due to data protection act i cannot distribute this information to third parties, however, i need a way where the third party can at least input the idcard number on a form and i...

Happy Birthday boblarson Happy birthday Bob :)

When you are about to create a database which will store personal data but for different entities for example Customers and Employees do you normally create two tables i.e. tblCustomers and tblEmployees or you create a single table tblContacts and you add an additional field to store the type of...

Hi, I have a pc which although it has outlook installed this is not configured, as the only mail sent from this pc are web based. Therefore is it possible to send email from an access database using the SendObject without having an email client installed? Thanks

Hi, I normally use Access to link tables via ODBC to a database which resides on the server. I have create some databases to perform certain reports and all of these work fine, however, some of the databases work fine on the pc which were created on but i get an ODBC - connection to 'sipr'...

I have several folders in ms outlook which i would like to turn their reading pane option to "off", however according to the outlook help files this has to be done on each folder individually. Does anyone knows of a "trick" which can change this setting to all folders at once rather than going...

Hi, I was wondering if it would be a good idea if there had to be a section on these forums where members could post samples of their databases so that they can be reviewed by other members. I am aware of the samples databases forum, but my idea is the other way round ... i notice (myself...

Hi, I have two fields in a query which their datatype is set to Date/Time. I am using the following to calculate their difference, and it works fine. Format([StartTime]-1-[EndTime],"Short Time") How can i amend the above code to deduct 8 hrs from the result returned ? i.e. if the result is 9...

Hi, When I use a parameter query i normally get the value from an unbound textbox from a form and then reference it in the criteria row of the query. However, is there a way in which rather than passing a value from the unbound textbox to the criteria row, i would was a full criteria clause...

Hi, I am creating my main table of a database, and while i am planning the setup i am noticing that some of the fields are going to change often ... now i remember myself reading somewhere that ideally fields which have their data changed often should be created in a different table, and not...

Hi, I have created an unbound form, which has 4 combos and 4 command buttons and when the form is opened all these have their enabled property set to false. Then i have another combo box which has 4 values in it, and when a value is selected, a combo and its associated command button are...

Hi, I am creating a search form which is going to have about 4 combo boxes, which will be populated from lookup tables. The "enabled" default value of these combos are going to be set to false, and at any one time, only 1 combo box can be enabled. This form will return records from a query so...