I'm looking to make a macro that takes data in column A and seperate it into three columns. I'm able to do it by setting up the macro manually, but is there a way to loop it to do it automatically as long as there is information in column A...
Is there a way to have two If Functions running together. The second one is attempting to place an greater than or less than equation into the first If loop based on if a specific cell contains a negative or positive number.
ie
This is what mycurrent attempt has produced, but doesn't work, the...
Does anyone have an idea why a movie file won't run on one persons computer but run on anothers. I have a presentation with 4 media clips attached to it, the presentation runs flawlessly on my computer and anothers, but will not run others. I'm dumbfounded.
Thanks for any ideas in advance.
Is there a way to take 11 seperate reports and combine them into one continuous report (the reports each have different fields). report1 followed by report2 and then report3, etc all are apart of reportall.
The program was originally set up to print off all 11 reports, but the user now wants...
I have a report that prints out 10 Labels to a page and some information doesn't take up the whole Label, so I was wondering if there was a way to vertically center the information so that the whitespace isn't so drastic. You can do it in Excel, but I can't seem to figure out a way to do it in...
In a report I have a bunch of personal information for multiple people. They are listed in such a fashion:
Name
Address1
Address2
Address3
CityStateZip
HomePhone
WorkPhone1
WorkPhone2
etc...
When information isn't present I have the textboxes become invisible and the information then moves...
In a birthday report, I am sorting the birthdays by month. In the group header I have this as the format of the text box:
=Format([txtBirthday],"mmmm")
The information being brought in is from a query and is being sorted/grouped by this action:
=Month([Birthday])
=DatePart("d",[Birthday])
Those...
I am trying to edit the input mask of a Birthday field. The only data I want to be entered is the Month and the Day, not the year. I've tried mm/dd and 99/99, and neither of them work, they always default to mm/dd/yyyy. This is most likely very easy, I am just probably going about it the wrong...
Is there a way to output a report that is designed and stored in the Access Database, in a common folder on a network, so that users can go to the report and view/print it w/o having access to the database? If it is possible, when the report is being stored in the seperare location, will it...
I am merging three data fields into a word document through the mail merge function. I have it set up so that only the current record I am looking at in the database, sends information to the word document. What I am really doing is populating a template word form. My question is: When I...
This should be quite easy for you guys, but I just don't understand the problem.
I am taking three fields from a table and mail merging them into a Word Template so that it automatically updates the document with the information in the database. That works fine, but my problem arises when I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.