Search results

Pat, Thanks, that is what I was looking for. The second table is an option, but would require some major work in regard to new forms, queries, reports, etc... Thanks Again, Chris

FoFa, I actually have an MD Sign-off field (yes/no), that the doctor needs to check off when complete. I use this to provide a count of "open" chart notes. I am just not sure how this would relate to locking the rest of the fields. In concept, your saying if that field is checked, then...

Hi, I am trying to place a command button on a form that will "Lock" the record. By that I mean the specific record can never be edited or deleted again. I know I can set the form properties to do this but the problem there is once you tab to the next field you can no longer edit the previous...

1. You first need two tables, one with employee info and one with orders info. Create the employee info table first and have an EMP # field (auto number). Then create the orders table and include an order # (use an autonumber) field, other order info fields, and an EMP # field (make this a...

I am trying to split my database and the database spliter wizard seems to get about 90% through the processs and then give me a "Subscript out of range" message, when I click OK , it gives me "Invalid procedure call or arguement" message. It does create the separate database with the tables...

TPK, I actually mistated that, we only needed to cont-alt-delete to end the process and close the program. Could you elaborate on "echo off" ?? Thanks Chris

Thansk, Sorry for the Caps. But we had already split the database, same problem. Any other thoughts ?? Thanks

WE HAVE SETUP AN ACCESS DATABASE ON A SMALL PEER-TO-PEER LOCAL-AREA-NETWORK WITH A SERVER AND ONE REMOTE WORKSTATION. WE HAVE BEEN HAVING A CONSISTANT PROBLEM WITH THE SYSTEM FREEZING WHEN THE USER ON THE SERVER CLICKS ON A PARTICULAR FORM. THE ONLY WAY TO GET OUT OF IT IS TO CONTROL-ALT-DELETE...

Rob, I may have to go with that approach if there is no way to append data to a text box. But what you gave me has been very helpful. Thanks for your time ! Chris

Robert, Your code is working well when I choose all three items at the same time. But there may be instances when I need to choose two items, enter free text and add two more items from the list box. Is there another command other then strData that will pasteappend the data rather then...

Still Stumped Bob, Itried that code in a command button, but it just replaces the value in the cell, and did not append to the values in the field. Any Thoughts Is it possible to create a Macro that copies the highlighted value in the list box, goes to the memo field, and pasteappends the...

Could anyone point me in the right direction on this. I would like to have the ability to select multiple values in a field that can string to one another. My problem is that by using drop down menus, I can only place one value in the field. As example, I would like a memo-type field that...

Is there any easy way to automatically refresh a screen on a form. I have set up a macro to refresh the screen and placed it on a command button, but I was wondering if there was a way to have the screen refresh automatically? My problem is that have gotten very good at developing with...

Thanks jack, I'll give it a try ! Chris D.

Jack, Thanks, I downloaded the file and unzipped. It was an access database that had two sample forms with colored tabs, but I am not sure what to do with it, or how it would relate or link to my database. Any ideas ?? Thanks again Chris

Stupid quick question, Is it possible to change the color of tab controls from gray to some other color ? I can't see any background color field in the properties box ? Thanks Chris

I have replicated my database, and now am noticing that in the process of replicating the database, the system changed my account # (auto-number) field from increment to random. This causes a problem because it assigns numbers like 10987655444, or -3245677788 as account numbers. I am unable to...

I now have this to the point where I can click on the Calander control to change the date field on the form, which I have listed as the control source for the calander control. But the "date" field on the form will not change until I actually move my mouse to click on the date field, and then...

Hi Everyone, Thanks for the feedback. I have the system working up to this point: I have created a form that allows me to schedule the patients appointment. On that same form, I have a calander control for the user to select a date. I also have a subform that pulls from a query of...

Thanks Guys, My e-mail is cdacey@ripcpc.com. I have actually been able to develop it to the point where I can book the appointment with all the revelent data (date, time, appt type, reason,etc..) and display that patient's appointments on their info screen, but my real problem is displaying all...