Search results

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...

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...

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...

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...

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...

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...

Is it important to use autonumber when creating tables? I have seen some examples of tables when looking at other options like cascade combo boxes etc and they always seem to contain autonumer as the key. For instance, if you have two tables, one for countries and one for continents, why include...

I would like to restrict the options available in field 2 based on the selection of field 1. Would vba code be required in the "after update" field? Would it be an if statement? if a is selected then 1,2,3,4? if b is selected then 5,6 etc, etc...?? I would really appreciate guidanance on...

as you can probably tell, I'm new to this. The code has run through me several times, with me getting closer to the solution?? Can anybody tell me what is wrong with this as I am getting syntax error at the dlookup customer section. Private Sub customer_notinlist(newdata As String, _ response...

I have a date field. I have a query which runs between start and end date, but obviously requires the dates to be typed in. Can I set up this query so that I only have to type in the No of the month say 8 for it to return all the records in August?

I am running a query where I total up Numbers. I have clicked on the fields to assign the properties as general no. with 2 places, however the result returns with more that 2 decimal places. what should I be doing to ammend this?

I want to update three fields in the master table, based on matching fields between the master table and an imported one. I know it needs to be an update query, but am at a loss as to how to work it. Any assistance would be appreciated.

I have created a switchboard with various pages which I can move between. Each page has the title Main menu. How can I change these to show what should be the title of different pages?