Search results

The clue is in the title :P I can drag and drop an image file into my bound object frame and it inserts it into my database and displays it onscreen nicely. I've managed to set up code to capture an image by webcam but I want the image to be inserted into the frame and database automatically...

right lots to look into here, thanks peeps for now I have speeded things up by using disconnected recordsets, and making a couple of lookup tables our client uses local instaed of remote... speeds are just about acceptable for now. I'll probably bump this thread to the top again when I've...

Fantastic thank you! Just to clarify, the code example you have given me is a disconnected recordset, but it's worth looking at creating a server procedure to add the recordsets, which would presumably take longer to impliment but offer a significantly improved processing time, but may cause...

Hi all We have recently moved our database onto a WAN, with the database server now being located in a different city to me. The problem is that (apparently) due to network lag my code seems to be running very slowly. My client has to read several thousand entries in an XML file and write it...

thanks people got it working now :)

Thanks for the responses. I'm having a little trouble implimenting these ideas AfterUpdate will not trigger if I move from one form to the other that shares the same bound table. It only triggers if I move into a subform bound to a different table. Form_Activate, Form_Deactivate...

Hi people I have a bit of a conundrum, my software is upgrading to dual monitors and I have to set up my client to have a different form maximised on each screen. The problem is in some occasions the two forms will be bound to the same table. So I need to syncronise the data so when you edit a...

Good morning all I'm trying to set up a 'check all' tickbox in the header of my continuous subform, that will check or uncheck the desired field for every row displayed in the subform. All I can think of is opening a the recordset that matches the form, cycling through the rows, and setting...

yes it is .

here's a slightly trickier one I used to switch between datasheet and form view with the following code DoCmd.RunCommand acCmdSubformDatasheetView DoCmd.RunCommand acCmdSubformFormView However 'the command or action 'SubformDatasheetView' is not available now.. I must confess I dont really...

awesome.. that did the trick nice one. where would i be without this forum..

um how do I reference controls on the subform now? 'Me.subfrmname.button' is no longer working as the subform is no longer a subsection of the parent form. Also Me.displayPanel.button wont work and Me.displayPanel.subfrmName isnt working either..

aah i see.. thanks again!

wow thats so much faster and more efficient.. thanks guys :D

Sorry to spam two questions in one go Is it possible to have a tab control with sub tab controls within it? If I create a new tab control within a tab it appears on every screen of the master tab, seems to be bound to the form not the tab I created it on. Is this not possible? I can work...

Hi all My applications main screen has about 15 subforms layered ontop of each other (all identical size) Depending on which dataset the user is looking at only one will be visible. This has worked fine for many years but its a real pain to do any design changes, if I want to widen the forms...

As detailed in my post this is not an option, I need something that can work on any table with any number of fields.

Hi I'm looking at how to duplicate an entire row of data in my table (apart from the autonumber primary key, I'd want this to assign a new value) I've been trying the following code: cmdstr = "INSERT INTO tblExhibitInfo SELECT * FROM tblExhibitInfo WHERE Exhibit =" & Chr(39) & strExhibit &...

Is it possible to do something similar with tickboxes? neither the tickbox or it's label allows me to do conditional formatting. I could have a flat text box instead of a label I suppose but if there's another way...

perfect thanks! and thanks for the advice regarding the name field