Search results

In the form properties of the form that you are adding the data to place this in the 'On Open' command Private Sub Form_Load() If Not IsNull(Me.OpenArgs) Then Me.NAMEOFYOURCBO= Me.OpenArgs End If End Sub Steve

Good afternoon Is it possible to have a blank new form open? at the moment it always opens on the first record and I have had to put a button on 'add new record' but I think it would be simplier if it was blank. I have of course tried using the stupid paper clip thingamebob but as usual it...

Sorry I did not mean to start I new thread but I must have hit the wrong button. Tig

Hi, sorry to be bugging you (or debugging) I am now getting the message saying that the new entry does not exist and would I like to add it, when I click it I get an error message runtime error '3265' item not found in this collection this is the complete code I now have Private Sub...

I sent Milo-Phile a private message regarding an example db that was posted regarding updating a table 'on the fly'. The example had one box updating a table from a form (to see the example db in 'search' type not+in+list). I have a form for which I wanted to update several fields and with...

Thank you I shall give that a shot Tig

Good Morning (UK) I know that if I have an email field on a table and make it a hyperlink I can when I enter details in the table type in mailto: followed by the email address it will, when clicked, open up a new message box in outlook with the send too box completed. My question is this, how...

Dear EMP How do you guys do this stuff, you must dream in codes etc. I am flabbergasted. Thank you for doing all the leg work for me I had not expected that but it is great. I have added all my zones, countries rates etc. and it works great, I do not yet understand the mechanics but hopefully...

Sorry, I have tied my self into a knot. My tables will have a country table with 3 fields Country (196 Countries Zone (9 zones) Transit time a Rate table Zone (9 zones) Weight_from Weight_To Rate My form should react something like Select Country: (unbound Combo looking up Country table)...

That looks great, It will take me a while being new to find my way around why it works, if I get stuck is OK to toss a few questions at you? Thanks Tig

Hi I have a number of suppliers tariffs which show a rate per half or full kilo depending on the service, these normally go up to a given weight and then have a fixed amount per half or full kilo thereafter to manage this I have the following...

Sexist Joke season? Woman are like carpets Lay them right the first time and you can walk all over them for the rest of their lives Tig PS. My girlfriend said I could tell that joke

Hi Geoff I have 2 on my machine but will it downsize from 2002 to 2000? no harm in trying you can send it to freightpro@yahoo.co.uk I will be back at that machine about 1900 today and I will give it a shot. Steve

Hi Pat When I use usys on my forms, table and queries the switchboard won't work, is that the bug you are referring to. I am using XP 2002 SP2. Thanks Steve

In the table shouldn't it say FieldSize: Double Format: Fixed DecimalPlaces: 2 I am a complete novice so I would not bet your life on it. Tig

Hi Does anybody know if you can pack and go an access db similar to a powerpoint pack and go so that you can demo your db on machines without access? Thanks Tig

Hi H Its both as they are both getting their results from different tables but above all else I need to know exactly what I did wrong so that in future I will know. In the query I went to the column CountryID Country and then put in the expression [forms]![frmExpressCourier]![cboCountry]...

Thanks H but that did not work, I'll keep on scratching my head and reading the really useful MS help files Cheers Tig

Hi H Yes, yesterday thats what I wanted, I have however been up all night and tried to refine it a bit. I have read heaps of stuff and I know I am quite close but I can't see what I am doing wrong. If you don't mind would you look at the zip and let me know what it is I am missing so that I...

Hi, Will anything on this example help Tig