Ok thanks, I'll try that
Tiffany
tcveltma
Last Activity: Sep 20 '07, 01:04 PM
Joined: Jul 3 '07
Location:
-
Thanks for the help, it seems to be working so far, with the exception of a minor compiler issue. Could you also tell me what the proper format is to replace "Me." for a table and field?
Thanks,
Tiffany...Leave a comment:
-
Incrementing a field without Autonumber
Hi Everyone,
I know this topic has been posted a lot, so I apologize for having to post another one, but the answers I've been finding seem to be more advanced than I know how to use.
I have a table called [MOC Tracking Log], with a field named [MOC ID Number]. The general format for this number is supposed to be (yyyy-0001). The last 4 digits are supposed to increment each time a new record is created (ie, 2007-0002,... -
Okay, thanks :)
TiffanyLeave a comment:
-
Multiple dependancies for a cascading combo box
Hi Everyone,
I have a cascading combo box, where you choose a general topic, and the next combo box only shows the related options....easy . Now I'm being told that one of the options I have can only be visible when a different combo box has a certain option. The table I am drawing form is not really set up to add to my SELECT statement, so I'm basically looking for a code along the lines of
Forms!FormName! ComboBox.ItemDa ta(0).Visible... -
I'm not sure what you are looking for out of a loop, but if you have all of the countries listed in a table already, you can use a SELECT statement on the rowsource of your combo box.
Hope this helps,
TiffanyLeave a comment:
-
Great, Thank you so much. That was the answer I was looking for. Sorry for all the confusion.
Thanks,
TiffanyLeave a comment:
-
My apologies for not making my problem properly clear.
We currently have a Word Document template. Any time someone makes a change to a certain process, they're supposed to fill out that form and save a copy. They then have to fill out a lot of the same information in an excel spreadsheet.
In order to simplify the process, I'm trying to create a database. Ideally, the person would fill out the text boxes in the form...Leave a comment:
-
Ok, I seem to be getting mixed messages for hyperpau, and Scott. Being able to save an image onto a pdf file will work for my purposes as it will not need to be modified. I noticed Scott mentioned saving an Access form as an image on a pdf file, but from everything I've found, I could only save into a pdf from a report. But then to create a report, wouldn't I need to create a form, send this information to a table and then create the report from...Leave a comment:
-
I do like simpler solutions...but will I still have an electronic copy, or does it only print the form as a pdf file? Also, is there any way I can set up a code to print it to the pdf file, or would the person have to choose Print? I can look all this up if you happen to know where I can find some good tutorials on the subject.
Thanks,
Tiffany...Leave a comment:
-
It's funny you should suggest that because that is exactly what I'm trying to do..and the exact opposite at the same time. Right now we have it set up as a word document. The person is supposed to fill out the word document, then save a copy. From there they had to fill in some of the information to a spreadsheet. Now we're trying to move it over to an access database so we can keep all the records together and not have to fill the same information...Leave a comment:
-
Saving copies of a form
Hi Everyone,
Is there any way I can fill in information on a form, then have a command button to either save all the information as a copy of the form, or export the exact layout, and information, as a document or pdf file?
I don't think I can and I haven't yet found any web sites that say otherwise so this is basically my last desperate attempt to make it so my form creation wasn't a complete waste of time ;)
... -
Great thanks, I'll try that.
TiffanyLeave a comment:
-
Nevermind. I figured it out. We can all just ignore me now.Leave a comment:
-
I think parameter promts in forms happen when your source isn't spelled exactly the same way.Leave a comment:
-
Viewing multiple pivot charts at one time
I'm fairly certain there's no way for me to do this but my boss wants it done, so I thought I would ask.
Is there any way to display multiple pivot charts from the same query (differently filtered) on one screen?
Thanks,
Tiffany -
Thanks for the advice. I have a few of the tables you suggested. Unfortunately I don't know enough about relationships to do anything with them....a task for another day I suppose.
Thanks,
Tiffany...Leave a comment:
-
Is there any way you could be more specific about your problem? Could you have forgotten to drag your field data into the Pivot Chart?
TiffanyLeave a comment:
-
Each time an employee fills out the form, their information goes to their own table. So each employee has their own table. I'm finding more and more that one combined table is the more effective option so I will probably end up doing that....making my previous dilema a useless question. So I guess I don't really need any more help yet. Thanks for reading though :)
TiffanyLeave a comment:
-
Combining Crosstab Queries
Hi again,
Ok, so I have about 15 crosstab queries. Each crosstab query is an employee's name. Within the query are the weeks as the column heading, the work order numbers as the row heading, and the hours as a value. Each query comes from a different employee table (1 table per employee). Is there any way I can combine all the queries into 1 query/report?
So far it seems to me that the only way I'll have a chance at making...
No activity results to display
Leave a comment: