Search results for query: *

Hi Remou, Would you by any chance have an example of the process of the screen? Thanks

Hi All, I have reports that use queries that a user needs to put in a location such as ER, CCU, POST PARTUM, Etc They have asked if there is a way to have a drop down box to select the location instead of typing it out in the parameter query. If someone could shed some light on this, I would...

CDO?? This is probably a stupid question but......What is it?

Hi All, I have a DB that has an ICON to send an email. When the user selects the option a msg appears ( You are trying to send an email outside of Outlook, Do you want to do thi?) The user then selects YES and the email gets sent. Is there a way to keep this msg from appearing? Thanks in...

Hi JK, Here is code..THANKS!! Private Sub Combo57_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Str(Me![Combo57]) Me.Bookmark = rs.Bookmark If Signature.Value <> "" Then...

Can anyone offer any help with this??

Ooops, typo. When the DB is opened, the screen defaults to the first record in the table including the signature (first employee has signature on file) If I select a name from the dropdown box who has NOT signed the sigpad yet ^

Hi All, I have a database that captures signatures for our nursing area. I do weekly imports of new hires that keep the table updated. Here is my issue..........small but annoying: When the user selects a name from the dropdown box, the signature field will not update UNLESS the employee has...

Thanks Remou, I am a novice could you explain how and where I would begin to set this up? Is there a way to have the user select which report they wanted? 1 = All records 2 = Less than 5 hits 3 = Greater than 1000...

Hi all, I have a DB that has a report that currently counts the number of times a user accesses a certain area of our core system. The report looks like the example below: Jones 13 Smith 26 Taylor 5 Hawks 1110 (I get these by the following control source of a text file in the report...

Mark, I have tried the compact and compare...on all DB's with this issue(??) Strange part is this started to happen on multible DB's....I have uninstalled and reinstalled Access but the issue still appears. I am not sure why the image error is starting on DB's that have been in production for...

I started having this issue where "None" of my DB's are working due to the error "Cannot move focus to image XX (XX = image number) This started about two weeks ago with one of my major DB's, strange part is thew end user can open it without the error showing up(??) I have uninstalled and...

I use a product called "Automate" I can run the job the generates the files and then store the file wherever with this product. We are a hospital running a "Meditech" as the core system. Automate is submitting and processing over 150 jobs daily behind the scenes that used to be done manually...

I am not on the "Network side" What is NET USE?? Thanks

Is there a way in a NOVELL Env. to be able see a networked PCs C drive?? I hear this can be accomplished in a Microsoft Env. I create files that get updated hourly, If the network goes down we want the users to be able to access the last one processed. This can only be accomplished if I can...

I have attempted the solutions indicated on the link, I am still encountering this problem and it is causing me major headaches!! Is there any other options for this problem? anyone have any idea why this would start happening within the last 2 months? Thanks

I created a DB that collects nursing signaturs. This has been in place for about 6 months, No issues. I have created additional queries to assist in nursings searches, the queries work fine. I wanted to create a switchboard for easy navigation, after I build the switchboard or even create...

Tony, If IS NULL or >=[Forms]![InputForm]![InputStartDAte] is used, Won't it pull ALL Nulls in the table even if it is not in the date range the user selects? Rick

I am sorry for the confusion guys, The &quot;Unit&quot;, &quot;StartDate&quot;, and &quot;EndDate&quot; need to be setup in a parameter query to let the user select the data they want to query. The big hurdle here is my experience with this type of search. I get the feeling from the post that...

Ken, Sorry for the simplistic question but, Where would the Nz statement go? In the criteria of the Query?? Is this how the query should look: Unit Start End Criteria [Unit] <=[Start] Nz(End,&quot;12/31/2999&quot;) Thanks again Ken