Search results for query: *

Richard, Thanks So much for your thoughts, sorry it has taken me so long to get back, I have been off the project for a couple of weeks. The first suggestion of yours was exactly what I needed and works beautifully. Thanks again.

I have a main form with a tab control and several subforms. There has been many errors with accidentally hitting the space button when looking up data so I have set the main form to allowedits = false which also sets the subforms to not allow edits which is fine, except that, if the subform has...

I have tried that experimentally. The situation that I have is that the old db is currently being used. I am creating a whole new (updated) fe and be and will then transfer the data to the new be. When I have played with creating a new table it has not input the appropriate item into the...

I typed the items into the row source. At the time I was at the very beginning stages of programming and believed what I was told (no that will be the only things we will want in the list) you know the story. Regards

That is not what I wanted to hear. I have tried to link it to a new table but I lose existing data. I will keep trying. I run reports based on items in the combo so it needs to be saved as an item in the list. Any other suggestions?

PHV, That worked beautifully, added the item to the list but only for as long as the form remained open. As soon as I closed the form and reopened, the item was no longer on the list. Regards

Hi, I have a combobox that I input the list that was to be selected from (ie. list is not derived from another table). I am now needing for items to be added to that list by the user. I have seen plenty of threads that show how to do this when the data is pulled from another table but not for...

Hi, Thanks for your thoughts, I think that there is a corruption in the backend, so I went back to a backup of the backend and the front end and imported the new forms or tables from the "corrupt" ends and it is now fine. How it happened I still don't know. Regards

It is a split database. I have deleted the table and recopied from a backup, I have deleted the code for the switchboard and copied from a backup and I have deleted the form and copied from a backup.

Hi, I have been programming this db for months now and suddenly my switchboard is coming up totally grey in form view. It looks fine in design view. I have no idea what I have done to create this. Can anyone point me in the right direction. I don't want to have to recreate if possible and I...

Thank you Roy-Vidar, The trick was indeed changing the format. I have spent hours pouring over tek-tips previous threads and trying and testing many different things. This is the first I have seen mention of setting the format of the date. Thank you so much, I can now sleep easy. Regards

I am trying to get the code to return "Duplicate" if a duplicate is found, it is not working, I have separated the criteria and found that it is the date part that is the problem. Here is my code and it is returning "0" even though there are duplicates in the table. y =...

Sorry the problem is now resolved. The customer has 11 computer in the office and the exchange uses pop connectors. The owner is a power freak and wanted all emails to go to her computer and she manually forwards them through. this was fine until someone sent somthing out. The reply address...

The server is 70km away and the remote workstation is turned off. I can get to the server via TS but cant replicate the problem without a workstation. Server has no Outlook. somebody will be there tomorrow to reboot the workstation I will get the error then. Thanks

You need to be able to access your server(primary Address) over the net. Example. A server using two nic cards (LAN 192.168.0.1) WAN (10.0.0.1) and router(10.0.0.100) If you have a static IP address (203.114.76.234)you would type 203.114.76.234/exchange. The request would reach your router...

I Have an sbs server running exchange using pop connectors. If I send a message via a client machine it errors saying exchange is in recovery mode. If I send via web mail it sends ok. In the event viewer it shows an application error reporting the exchange to be in recovery mode????? What is...

I have been hunting this for a while and still have no answer for a machine without exchange. Could you please post your work around to help me with my imediate needs and I will post any solution I stumble on.

Daniel, Thanks for your help. Neither of those were my answer but it did make me think along the same lines and I found that it is because my main form is set to not allow edits. thanks for your quick response it helped point me in the right direction

I have a form that I have just added a subform to (using the wizard) and have not put any of my own code in as yet or changed any property settings. When I open the form in form view the subform fields do not show unless there is data in it. I have used subforms many many times and never had...

Ok, I have since read that if a query's criteria is based on an unbound form (which mine is) you have to use querydefs. Not quite sure how to do this in my code, have tried a few things with a basic sql statement but it is not seeing the email address ([Email]). My full sql (copied from the...