Recent content by ajhts

I have several clients that remote into a terminal services server and have been for about 2 years. They log into their own separate databases. Everything has been working fine, but today out of the blue, the reports screen doesn't work with any clients sep. database. When they click on a...

I apologize for my ignorance, but how do I make the form bound??

Payrate is pulling the payrate from a different table called therapisttable. This is a data entry form to enter minutes and some other info. When they select the employee id, it pulls the employees payrate info into it so they can see what they make for the line that they are working on. I...

I have a data entry form using a lookup query (datasheet view) to where they enter the employee id and it pulls the name and payrate automatically. Then they enter the number of minutes in the appropriate fields. However, it doesn't save the name or payrate into the table. It only displays...

Worked great, thanks!

I have a query that produces this: Name HomePhone BusinessPhone MobilePhone Angie 555-5555 Angie 333-3333 Angie 222-2222 I need it to combine into one line in the query like this Name HomePHone BusinessPhone MobilePhone...

I have checked both and they are empty. I can't figure this one out! If you have any other ideas, please let me know. I have even cleaned up the registry of any stamps.com files. I will check to see if any .dot stamp files are in the registry. Thanks, AJ

Stamps.com has taken over the insert autotext section. Inserting header or footer shows only stamps.com options. How do I get rid of this. I have uninstalled stamps.com and also reinstalled word and it is still showing up. I have also looked at the addins within word and I don't see it...

I am sorry, but the article didn't make sense to me. I still can't get it. Is there any other resources out there that might explain it a little better. Sorry again, AJ

No it does not matter which code gets it. The codes are not unique.

I have a query to where I added a column called visits. I need it to place a 1 in the visits column. The trick is, I can only have a 1 per day per patient for the same disc. How do I have it place a one on the first record of the group. I hope this example helps show you what I need. I need...

I have a report that I generated that will list each day and the day of the week. I have a footer for week showing up at the end of the week and tells me the number of overtime hours. Works Perfect! Now, I need help! Our payroll works in a different way. We are paid for the 1st through...

I have another linking field issue. This does not involve calculations. I have a data entry query to speed up the process. When they enter the facility number, the facility name automatically pops up in the next field labeled facility name. What I need is for the facility name to go with the...

heres the problem, the sheet that comes in for data entry is not totaled for her. She has two options, use a calculator to add aminutes and bminutes together, then add that result into the txminutes field. Or, what I would like to do is let her data entry form be her calculator and save the...

I forget to say that my form is from a data entry query that when they enter the facility number is pops up with the facility name so they know they have selected the correct facility number. I don't know if this matters about linking a field back to the table.