Search results

Hi all, So once again I have bumped into one of the slightly odd and initially very confusing nuances of MS Access/Jet 3.0/VBA. Currently I have a table which holds data about changes that need to be made to our various PC images. The main fields in this table are the Software code, the Image...

Hi all, I keep getting the following error:- Run-time error '3367': Cannot Append. An object with that name already exisits in the collection. This occurs when I use TableDefs.Append. The situation is this. I'm developing a module to create a table. Passed ot the module is a string with...

Hi all :) Ok, let's say I have 3 tables with the following data T1 T2 T3 1 , 1 , 1 2 , 2 , 3 3 , 4 , 4 , , 5 I'd like to be able to create a query that has the only record as its result as 5 as it is the only data item the does not exist in Tables 1 and 2. I don't just want...

Hi all, Should you write an expression the criteria field in a query and use IIF, an interesting little bug appears that I have not managed to get around. Should you want the expression to return a range as the criteria (i.e. Between ... And ... ) it can't do it because IIF tries to evaluate...

Hi all, :) Is it possible to add check boxes (or any controls for that matter) hen a form loads. Bassically I need people to select which items will require a change on a change request form (or could a list box do this?) As the number of items available can change I need the correct number of...

Hi all, In the past in had the usuall bug trying to save data from a text field using a query only to find it has only saved the first so many (256?) characters from the field, truncating the rest. I managed to find some code to overcome this. I now however have a form with two text fields in...

Hi all, I have two tables: ImageSoft and Software. All items of software which have a type SA (Standard Application) must have an entry in ImageSoft under every Image Code. When I add a new software title of type SA, it won't be included in ImageSoft for every Image Code and as I have a lot...

Hi all, I get an Invalid or Unqualified Reference error with this code, highlighting !Comments. Comments is a Memo field in the tblSOftware table. The code is being run from a button on a form. Anyone got any ideas what's up?? Cheers, Matt Dim db As DAO.Database Dim rs As DAO.Recordset Dim...

Hi all, Have been having many problems with memo fields truncating after about 512 characters. Having surfed for a while, a lot of the problem seems to stem from formatting characters residing in the memo text. For example, if you create a text box in a form, any thing you type into that box...

Hi all, I have added an OLE WordPad object to a form. However, when I use the form, I cannot select/give the object focus to activate it. Even if I right click the object, it give me the correct popup menu. :confused: I am using this object as I am having troubles with Memo fields. I use a...

Hi All, I have this line of code: DoCmd.TransferText acExportDelim, "Dhcp Specification", "tblDHCP", "U:\" & [Forms]![frmExportDHCP]![cmbServer] & ".txt", False, "", 850 Where the section highlighted is a combo box on a form. I was trying to use the value in this combo box to describe the...

Hi all, Is it possible to modify data using a query. Say for instance I have a whole load of IP's in a table in the form of A.B.C.*, where and and B are fixed, C varies slightly and * can be anything from 1-255. Can I use a query to look at an IP and the append an IP record to a different...

Hi all, Firstly I am trying to retrieve data from three tables in a format like this Table Data Fields Descirption Table 1 A,B PC Details Table 2 B,C Software/PC Table 3 C,1,2 Software Details Where the B's are linked as are the C's and these both form primary keys in their respective...

Hi all, I was wondering if it is possible to prevent the drop down list from displaying on a combo box, and even better, to hide the drop down button. I know this just sounds like using change to and changing the combo to a text. However, as the text box doesn't have the same properties, it...

Hi all, I need a button on a form to not only add a new record but also run a query. I can't see how to do this using a macro and my coding experience is limited. How can I get this button to do both of these actions? I think that I should add that the add record action must happed first...

Hi all, Is it possible to open a form so that it shows the new record fields only? I want to create a form that only allows the user to enter data and not view any of the records in the table the form is linked to. Cheers, Matt

Hi all, I have two tables, A & B, which are related to each other. A is a list of of Image Codes (IC) that are matched with a list of Software Codes (SC). This effectively gives a list of the images available and all the software packages installed on each image. B is a list of all the software...

Hey all, I have two fields 1 & 2 field 1 is a simple combo list of user defined values ie A, B, C or D Field 2 relates to a attribute of the data in field 1 and is not always the same for A, B, C and D. i.e A could have a,b,c,d or e B could have c,e,f,g or h C could have a,g,h,i or j D could...