Search results

Thank you for the suggestion, I will try that out :)

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

Thanks, I will check that out. :)

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

Thank you very much both for your replies. I will try to look into the index table as suggested. Once again thank you.

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

Is your form based on a query or directly to one of the tables? As regards the one to one relationship, do you have such a relationship between all four tables? I am asking you this question because one to one relationship are not so commonly used so you might have a problem with the design of...

you can use the "size to fit form" option to get the form fit to your screen.

you can change your field length(s) from the design view of your table.

not sure if I understood your question correctly but to pass your number from one form to the other you may use the "openargs". try to search for that word on these forums and you will find several examples.

you're welcome.

Create an unbound textbox and set the following as its control source =[FirstNameFieldName] & " " & [LastNameFieldName] Make sure that your replace the above with the actual names of your fields. As regards the other question try searching for "switchboard".

thank you both for the replies :) Exactly that's what I want to do. So I guess it will be better if I will leave the set up as it is (since after all it is working fine). Just a final question: if I had the same scenario but rather than 3 fields they were 5 or more fields for example, does it...

thank you for your reply. Actually the most thing I was originally worried about is that with the current set up I have a lot of records that has the 3 fields relating to duplicates with 0 as input so I am not sure if this goes against normalization. While it is true that with the new tables I...

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

Thank you for your help.

thanks for your reply. Actually I had already ticked that option, but I am still getting the macro display instead of the code.

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

you're welcome :)