Search results

Doh! :o :o :o Actually, to save some of my blushes, I did already try and rename the database from createcontrol to other names but it didn't work. However after reading your post I created a new database with a different name and that worked. :) bl**dy databases! Thank you Red.

Hi and thanks for the replies, It was in the onClick event of a different form than the one I am trying to create a new control. So this shouldn't be an issue. I do have a table called orders, however wouldn't the code still compile and the code just break when it got the line referencing...

I am using Access 2003 and I am trying to use the createcontrol method (See Code below). I just copied some example code from Microsoft, however I keep getting a complie error when compiling the code. The error says: "Expected variable or procedure, not project" and the createcontrol method is...

Just an Update.... I am closing the form using a command button and the code 'docmd.close'. If I disable the command button and just close the form using the close control box. (the red 'X' in the top right) I don't get any problems! :confused::confused::confused: Anyway, this will do for...

Hi MStCyr, The app will run on a dedicated PC when done, but I've been developing it on my laptop. I tried running app & closing it on the dedicated PC but got the same problem. I also did the a cold reboot but it still does it. Nothing else runs on the dedicated PC Both running win XP pro and...

I have a form where the ontimer event triggers a communication with an external device, opening a WinSock connection. (I think!) The device has its own IP address and uses TCP. I the use the Declare Sub xxxx Lib ‘xxx’ etc. to declare any subs or functions I need to open/close connections and...

Sounds like its public variables then. The code is quite time critical as it has to run in less than 100ms but there isn't a lot of code to process so I should be ok. Thanks Red

I have some code that executes on the 'On Timer' event of a form. I have some variables that I currently store in public arrays, about 12. Eventually there may be up to 15 or so forms open that all will trigger some code using the ‘On Timer’ event on each form. Once open the will run constantly...

Excellent M8 :D Thanks Red

I have a bit of code which runs on the 'On Click' event of a command button on a form. The code checks for a connection status to an external device. If the status is ok, it changes a rectangle's back colour to green, if not changes it to red. The code should then pause 3 seconds (Which will...

Hi Ken, Figured it out thanks. It was a combination of things but mainly because I was using the wrong server name, I forgot to add 'SQLEXPRESS' to the end of the server name :o The full server name doesn't show in the drop down lists in the ODBC configuration. Anyway once in, I could...

Hi Ken, Thanks for the reply. I did try through ODBC but couldn't figure it out.:o Although I've been working with Access databases for a while I'm quite new to SQL and working outside of the Access enviornment. I tried connecting though the ODBC Data source administrator, using SQL native...

Is there a way that I can connect to data in a SQL Server Express Database (mdf file) using Access? I can currently connect to the data using SQL Server Management Stuido Express, but I would like to be able to work with the data in Access. Cheers Red

Yes I did that. None were missing but could have been pointing to an updated ocx or dll maybe? However I remembered the work around. I installed Access 2000 in a seperate Office directory. Open the database and let it run. Then repaired Office 2003 so Access opens this version and not 2000. Now...

Hi boblarson, The code is in the 'Open' event of a form. When it opens the code is meant to set the Calender to today's date. Me.Cal = now() Then when the calender is updated I use: me.frmcontrol = me.cal This is to update a date control on the form. I have changed the code to: Me.Cal =...

I have just installed Office 2003 and I am trying to use an old database in Access 2000 file format. Within the forms are activeX Calender controls. I am now getting a runtime error when I try reference these controls: Runtime Error - Method 'Value' of object '_CustomControl' failed. This...

The simplest solutions are usually the best! :o Thanks Dennisk. It would be good to know if there was SQL that did what I wanted working directly with the tables. That way I could hard code the SQL behind a report button or something similar. Anyway, thanks again. Red

I have 2 tables with employee details in it. There is no natural link between the 2. I wish to write a query that will sum up the total pay for both tables. I've had a look through the forum and it seems that a Union query is probably best. I haven't worked with Unions before, so I did 2 sub...

When I close my form using the close button (docmd.close) I get message asking me to enter a parameter value, referencing a control on the form. I obviously have some code doing something silly but I haven't figured it yet. Anyway, if I close the form by pressing the 'X' control at the top...

I have form with a list box that contains various info. On the list box double-click event I have some code that opens a new form that enables the user to edit items in the list box. When the form closes it saves the changes and re-queries the listbox to show the changes. When this happens the...