Recent content by bistec

I have something similar that I'm doing in one of my dbs. Firstly created you're word doc and where you want the data to be inserted create a bookmark with an appropiate name. Continue with as many bookmarks as you like. In your access app ad a button open the word doc and send the info puting...

Wouldn't a "not in list" event procedure be more useful than the form timer? Correct me if I'm wrong, but the prog is only now hanging when an invalid serial no is entered. I suppose it depends on what you want to do with an incorrect part no. as to how you would proceed with this event. You...

Wouldn't it be better just to program the scanner to send a CR at the end of the barcode? All modern barcode scanners can be programmed to send all sorts of things and emulating an enter key is just one of them. With the scanners you should have got a programming manual. If you didn't go to...

Hi I'm playing with passwording forms and although security is not a big issue I'm finding that I'm having to add a few more passworded forms. I though about usernames and passwords but it doesn't really fit into the big picture. I've created a function (below) that I think will do everything...

Gooday Bill How are ya? Thanks for that bit of code, I'll give it a go. I've been fairly busy learning MySQL/PHP and the like so I haven't been on the forum for a while. Yes, the backend code worked a treat, thanks for that. A few stars are in order ;-) cheers Howard

Hi Is it possible to change the format of a field via vba? I'm adding a field to a remote backend db using the following; <snip> Function AddNewField() Dim db As DAO.Database Set db = OpenDatabase(&quot;D:\nbm\smdata\smdata.mdb&quot;) db.Execute &quot;ALTER TABLE jobs ADD...

Thanks for that Bill, it looks good. I'm a bit tired up at the moment (aren't we all) so I'll have a look at it later this week. cheers Howard

I'm trying to use an seperate mdb file (like an update to run at the remote site), to create a new table in the backend db to the frontend db. I've had a look at &quot;TransferDatabase&quot; but that seems to only be configurable to run in the frontend db only. Creating the new backend table...

I have an main form with subform and I'd like to add a new record to the subform. That bit is not so bad. I need to get info from another table to fill in on the new record when it's created. So do I open two record sources with SQL get the values from one record then add the new record to...

YEAH! fixed it. I found this article ACC2000: Errors Concatenating Variables or Controls (Q210244) @Microsoft and modified the following strSQL = &quot;SELECT tblUnitAccessories.Description FROM tblUnitAccessories WHERE ((tblUnitAccessories.UnitID)=&quot; & vUnitId & &quot;);&quot; That...

I've tried that one too. Actually the dbOpenSnapshot was added out of desperation as was the setting of it as a DAO Recordset. The SQL Statement works and returns 4 records (as it should)

Errr... No that didn't work. The full error code is Run-time Error '3061'; Too Few Parameters. Expected 1. From what I can see I'm only passing 1 parameter to it. Hmmmm....

Trying to take the data out a field from several records and create a string using VB. e.g. Description (field) -------------------- Lounge Chair Television etc I want to get this output as a string variable Lounge, Chair, Television, etc I've been trying to get the following working but I...

thanks for that. I ended up fixing the problem by setting a bookmark by before I requery the form, then calling that bokkmark back again.

Long discription I know but... I have a form that returns a list of records via SQL in VBA. User can dbl-click to open form with full details update, edit etc. After details forms is closed, the list does a refresh to show changes. What I would like to do is set a bookmark and return to...