Search results

Pat, Thanks for the sample! I originally set up 2 data entry forms that each have repeating entries that are non normal (C and S in one, O and N in another). I've now combined both tables into a more normal structure where C, S, O, and N are now all in an Analyte field/column and the data is in...

Found it! Did more site searching and found another post where Pat had attached the example: http://www.access-programmers.co.uk/forums/showthread.php?t=97415&highlight=Denormalized Thank you Pat.

Yup, works MUCH better than my suggestion. Sarah, copy the code that is in the form's On Load event into the form's On Current event, the stuff that prepares the tablet and ActiveX. It "refreshes" the ActiveX and tells it to represent the current value of the text box holding te value string of...

Hey folks! A favor to ask: Pat Hartman posted an example db shortly before this site was attacked that dealt with setting up a form in a non-normal fashion to enter/display data that was in normalized tables. Did anyone download and keep a copy? I downloaded it and was going to study it to try...

Sarah, as discussed in your other post on this topic (double-posting is not encouraged here, it generally makes folks mad), I've run into the same problem as you, but it did not bother me enough to work a solution. I just looked at one of my forms that is used for signatures and thought of a...

Right, Sarah. Mine does the same thing. Does your report have similar code to what I posted in the report's Detail section On Format? That last line tells the ActiveX control that it is to be what the text string in the memo field is, and represent it as a signature. Even though it is stored in...

Sarah, what is the ActiveX control name? I also have a report using this to show the signature, and it works okay. Be sure that in the report's underlying query that you have a field for the memo field from your table that holds the actual signature, as a text string. You will need that AND...

Wish I could help on that one, Sarah, but I haven't figured that one out on my sign-in forms either. I'd say disabling the mouse on the sign-in forms and forcing the user to use the form navigation buttons is the best way to go.

This is a link to the site with the example app that I used for a workaround on the dynamic crosstab query report issue: http://www.invisibleinc.com/divFiles.cfm?divDivID=4 It's the crosstab report download. Full credit to Duane-dhookum over at the Tek-Tips Forums for this, as it is his...

Sarah, is Signature the name of the control on your form that stores the actual signature? Is SigPlus1 the name of the ActiveX control on your form that is where the signature is seen onscreen? Do you have the SigSign ActiveX control on the form also? The recordsource for your control...

Hmmm, you're right, as far as getting data from the query. You can still have the report print a header (not sure about report header, but I have one that still prints a page header). I have a report that sticks 3 values picked up off the dialog form and puts them in the page header. But these...

I'm sorry, but I had to post on this HORRIBLE misconception: The rap of Vanilla Ice was THE single worst form of rap and far from being a non-threatening from, it was senses-threatening. From the time the first beat hits till the last "Ice Ice Baby" came from the speaker, the unsuspecting hearer...

I usually put stuff like that in the header. I do it by using an unbound form as a dialog form to input the query parameters. Have the query parameters reference the specific controls (text box, combo box, etc) on the form to run the query and report. In the report design view, put text boxes...

I have gone a different route with this problem, after seeing another person's solution. I have done away with the Solution's dynamic crosstab report and put in a workaround to this. I'll try to find the link where I got the sample app from to do my report and post it here. I got it from Duane...

Another note on this: I pulled the tables used for this into a new database on my desktop, and then linked those tables to my front end and tried running the report. It took almost 20 seconds to run the report this time. So it runs fastest when the tables are actually part of the front end (7...

Not sure about that Brian. I'm not much when it comes to code, unfortunately. I'm wondering if your tablet PC vendor has a solution for this?

Brian, I don't have any experience with tablet PC's, but I've set up an application that uses digital signature pads. Do a search for that topic and go to the website I noted for Topaz signature pads. The example Access apps they have in the downloads section might help you out. The control for...

More on this issue. I've played around wih the report more, and made an interesting discovery today. I made a blank database and imported all the modules, reports, forms, queries, and tables associated with this one lab testing method. Of the 19K + records in the main table, I deleted and left...

Good day, folks! I have a question regarding dynamic crosstab query reports. I've successfully put together one of these to report some lab data we regularly generate. I used the example in the Solutions application to do this, and it outputs exactly what I want it to. My question is, should...

First thing I can think of assumes that you use a query as the record source of the main form. If so, maybe you can set the underlying query to filter all records shown based on the username off the form (which, again assuming, is either from a app login or from using the environ trick to get...