Recent content by Pete Morris

I have a problem which occasionally surfaces. When trying to use an edit form nothing comes up but a blank page. No fields, nothing. The database is split and when I open it. It shows as read only. The database is only used by myself and another and the other is not accessing it. I've tried...

this is just for network diagramming. I need to be able to show what ports are free, what equipment connects to every port and what route those connections take. That could be in the region of 2-300 ports.

Has anyone built a cable database or something similar? I have 6 cabinets each with 10-15patchpanels in with 12 ports on each patch panel. Some of the cabinets are connected to each other, some are not. This allows diverse routing. If i plug a server in at one end it might have 2 connections...

fixed it now, under the tools menu, startup it was still pointing to the switchboard instead of the new form. Cheers, Pete.

Ok, so I had a switchboard which worked well. Great. I disliked the unfriendliness of the layout so changed to own forms. also good. I changed the autoexec file to point to new form. Good stuff. I deleted the old switchboard & table. But now, when I start up the database I get the following...

how would you do that then?

I am trying to use this code in vba as cascading combo boxes. It allows me to select an item in the first cbx, but when I click on the second cbx a parameter qry pops up. selecting ok or cancel allows you to continue with the second cbx, but there are no values in it. Any ideas on what could be...

Hi, I am trying to get this code to work for cascading combo boxes on a form, but keep getting the above error. Could someone look at the code and let me know what obvious bit I'm missing. I'm new to code and have hashed this from an example to try to get it to work on my database. Also would...

thanks very much. It's so easy when you know who (how). Pete.

have only included the switchboard and table as rest of db contains loads of data.

not sure how I see them in design mode?? as it only shows one panel. They are in the switchboard table. Also they are in the switchboard manager and I can click on them there and go to the next button etc...

I have ready many posts about not using switchboards as they are a pain in the a***. I have an existing switchboard which I have added buttons and menus to but they are not showing. I looked at the help file, which recommends "If you created the switchboard by using the Database Wizard, click...

Why did the third monkey fall out of the tree? It though it was a game.

why did the second monkey fall out of the tree? Because it was stapled to the first

ooo err, I have had a database for quite a while, which has been running ok....... I have recently been tarting about with it, adding some code to forms in order that updates can be made to lookup tables etc. Everything is working fine apart from.... If I double click on one of the tables it...