Search results

Thanks for all the help, I figured out what I had to add to my code to fix the problem, it was a an if statement. Thanks If Len(Signature.Value) > 0 Then SigPlus1.SigString = Signature.Value End If

Signature is the name of the unseen textbox. Which store the signature I guess. The SigPlus is the activeX Control Where the signature appears yes. Yes I have a SigSign as well. Yes the control source is memo. Like I said it doesnt work when there is no name in the Signature control. When there...

Hi All, I have just recently purchases a signature pad, I have added it to my working program, via using the demo applicaiton which comes with it. However I am getting a mismatch type. On the form load this code is highlighted in debug mode: SigPlus1.SigString = Signature.Value. I think that the...

Hi all, I was just wondering if anyone could help me with a problem. I have a form that displays only the records for a specific field. in my table I have many records so I have narrowed the records I want to display by displaying only the records with the same pin number. So if Pin number 2550...

yes I know that. but I the forms objects are linked to my table, and when I open my other forms then the controls then contains filtered data what is within the table. This is the data that I would like to use in my report.

Hey Scott, thanks for the input.

yeah I would like to do that! but this will use the records contained in my table correct?? not the ones that are on my form!

yeah that is an idea. what do you mean but they would enter what criteria they want on each field??

So what would that deal with a report/export utility??

The excel was already presented to my people and it is not what they are looking for at all. Thanks

Well it is not me, it is the people who I am creating this database for. It was also just a example, I am not sure how many reports in a day they would need, but see since they have a way of doing it now I am trying to give them the same way but better with this new program!

stored query?? So what would this be like?? so would the stored query change every time. ie only one for the database instead of 10-20 since I could need that many reporst in a day/week??

Thanks for the advice. I have been steard away from the dynamic reports I guess. However I am not sure that hiding controls and moving controls is what I want to happen either, but thanks for the help. I am just not sure what to do. I will have to discuss this again with my people. We might just...

yes my forms are bound. dynamic reports hey! well that is the way that the people who are using my program wants to use it. since that is what they are use to and people dont like changing there ways when it comes to computers but, maybe you could help me out with looking at both of the ways...

yes! okay, sorry i am a litte new with this topic, so How do I know if my form is bound or unbound?? I understand that the controls have the data not the form yes. okay my data in the fields are effected by the ones in my table?? you can pass to a filter to a report! My filter is by form as...

options as?? I would like the user to have the ability to create a report on the fly. I have no idea how to do this. I though of a report wizard?? check boxes to tanser data into a table/query and create a report based on that query/table. Can I create a blank query/table for this? i have no...

Hey all, I was thiking can i make a blank query and then on my filtered form. Pass the data from the selected fields(VIA a ceckbox) and then display a report based on that query? Then have the query cleared for the next time?? Is this possible? Thanks in advance for any help!

so everyone is saying here, to use a temp query instead of a table. that would kind of make sence since a query is like a table. So How can I make a temp query??

You mean from the default that come up when the fields are added. No I havent changed it.

Well I didn't know if there was an possible way to transfer my data from a form into the report wizard, thats what I was wondering. A query is so informal, I would like it in a report form or a form format. I dont know if a query wizard is what I need in particualr but I just thought it would be...