Search results

Thanks for the tip Brian, Ok, used the wizard and fiddled with the query. I can get the appropriate list of Software that does not have a relation ship with the Image Codes, however there are no list of image code returned. i.e. If sofware A does not have a relationship with Image Codes 1,2 and...

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

Possible muppetry, but still problems Hi all again, Dumb ass here didn't see the enbled property set to no.:rolleyes: So the OLE object now works, however... Now each record seems to hold exactly the same data. Is it possible to have seperate opbjects for each record and how??:confused...

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

Ay?? :confused:

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

Not just a pretty face! Good skills! It was the order I entered them in. I would never have guessed. Time to insert a sort somewhere. Hooray....Job done! :D :cool: Cheers, Matt

Almost There Hi Pat, Thanks for all your help so far. This almost works completely. My is now based on a query which contains fields B and C from Table 2 and 1 and 2 from Table 3. I can now link a text box to field 2 and display the version number. My control soure for my combo box which...

Sort of tried that. So what did I do wrong? Hi Pat, I've kinda tried that by making a query with values from table b and c in it, but when I open the form the values in table C don't appear on the form and if you use a combo box for the table c fields, the drop down list has each value listed...

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

Tricky Data Retrieval! Hi all, Rich - Nice idea, but it looks a little unprofessional. Certainly hides the button! Keith - Are you ready for a bit of a complicated one?? Here goes! Firstly I am trying to retrieve data from three tables in a format like this Table Data Fields...

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

Nice one! Thanks John, Good skills lad, that's worked a treat. Thankyou very much. :D :) Cheers, Matt

Nearly perfect! Thanks John, That code works a treat. It was much easier to do than I expected. The only bit I have trouble with is the acNewRec command. If, say, I've just entered in the first record onto the form and pressed the button, when the acNewRec command runs, it leaves the newly...

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