Search results

Hi people I've got a bit of a headscratcher I'm trying to loop backwards through time in 15 minute slots until I match a variable. However the my code doesn't seem to recognise my date variable as 'equal' when it is! I.e. I step through and when I get to the line: If t = firstAppointment...

Good afternoon. Apologies if this is a topic that has been discussed before, I performed a search but did not find anything useful. We've been developing a MSAccess front end for our database for nearly 10 years now and it has grown to many thousands of lines of code with 8 modules and nearly...

Hi all My form has a bound object frame that links to a table with OLE Object type The user can drag bitmaps into the frame which are then stored in the table and displayed on the form However after a time (it seems to randomly break on the computers in our office) the frame stops showing the...

Good afternoon I'm writing code to read in some XML files and the nodes which are empty seem to be returning strange results with a non-ascii character Dim MessageList As IXMLDOMNodeList Dim MessageNode As IXMLDOMNode Dim childNode As IXMLDOMNode Set MessageList =...

Hi all I've recently been trying to upgrade my software so instead of access queries I have sql server views. The continuous subforms will be bound to an editable recordset instead of a sql statement using an access query I've got this up and running but I'm getting some strange behaviour of...

Hi We're having a problem where data entered into our database by form is not always being saved The data entry is into continuous subforms which are bound to an msaccess query. The query links to the datatables which are SQL Server 2008 using an ODBC connection with the native client 10.0...

Hi peeps I'm having a problem where data is being truncated at the start when written into my table. It happens when updating a field with a string that is several thousand characters long. Apparently truncating at the start not the end is not normal behaviour for any database so im a bit...

I have a bit of a problem with switching between form view and datasheet view now my main form has two subforms I used to use the following code Private Sub btnSwitchView_Click() intview = Me.DisplayPanel.Form.CurrentView ' change view If intview = 1 Then DoCmd.RunCommand...

Good morning I'm having trouble saving a bitmap from my database to file. It's stored as the 'Image' type in my SQL Server 2008 table, and is put into the table by simply dragging a bitmap file into a bound OLE object To retrieve it I'm trying the following code: Dim strSQL As String...

Hi all I'm very confused as to why my continuous subform displays no data even though I know it should be. If I do a record count of my SQL string: Dim rs As New ADODB.Recordset strSQL = "SELECT * FROM tblContacts WHERE UniqueRef = " & gUniqueRef & _ " AND DataSet =1 " & _ " AND...

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

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

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

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

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

Hi. Not sure if this is possible: I have a subform linked to a table. It will either be continuous forms or datasheet view, so there can be any number of records. I would like the background colour of some of the text boxes to vary dependent on booleans on the table. For example if a...

Hi I need to be able to vary the connection string in a query depending on who is logged in (I'm using SQL Server 2005 back end to my access client). I have a function getConnectionString which generates teh connection string depending on the logged in user and the required database, but I'm...

I've recently attempted to migrate from an Access back end to a Microsoft SQL Server Express 2007 back end. I've linked up the tables to my Access front end client no problem, and anything that gets data using an Access query works fine. However when I try and open a recordset using code I get...