Search results

Thanks... I should have thought of that.... many thanks!

The following snippet appears in the detail portion of a report of mine. Basically it says: if a customer has a balance due that is over 30 days but less than 60 days old, show it here. I would like to total all of these in the footer but have no idea how to make that happen... thoughts? Many...

I'm desperate to know if anybody has an answer re: how to perform cacluations on date/time fields for times that run over midnight. Here's an example for calculating duration of time for "treatment": Treatment Start Time (Field: time_tx_start): 10/1/2002 @ 23:59 Treatment End Time (Field...

Thanks, "F" ... I always forget about dragging and dropping. It worked perfectly. -G

I have a report that uses one query as its data source. I have another query that only has one number as the result... let's say that the number is 212. I would like to have that number appear in the report footer. When I use the build function in the report footer, I just cannot get the value...

The keyboard settings were set correctly and the tab order has my "OK" button set last. Still, when I am in the first field and enter data and hit "enter", it acts as though I pressed the "ok" button.

I would like a user to be able to hit the "enter" key to tab between fields when they are entering data into a form which has command buttons. Is it possible for "enter" to move them between fields and then when the focus is on the first command button, activate it (the button)?

I am using SendKeys to automatically IMPORT and Excel spreadsheet into my database. I have the macro working fine up to the point where all I need to do is press {ENTER}. I can have the cursor focus on either the actual file or the "IMPORT" button and simply hit {ENTER} to work. If I manually...

I have a form that is designated "yes" for pop-up. When this is the case, the "delete record" and "copy record" buttons that I have created cease to function. Is there a way around this? If I set the pop-up to "no" the buttons work fine. Thanks for any input. -GAC

I am trying to calculate =sum([field1]/[field2]) in a report. I am getting an overflow error and a div by zero error. How can I handle this to make it work? Thanks. -GAC

Answered my own question. Thought I'd post it for anyone with similar needs. In validation rule field enter: Like "???????". You can put your cursor in the validation rule field and hit F1 and the answer appears before you. -GAC

I'm sure this is a simple one for most... but I am stumped. What is the validation syntax to limit a user to a 7 digit entry in a form field? ( I want a user to enter a code that must be 7 digits in length) Thanks in advance. -GAC

I have created a data input form using the tab control feature. This allows users to tab between subject matter as well as not having to scroll to input data. However, I have created a button that copies the data from the current record and creates a new record, but it will only copy the data...