Search results for query: *

Hi all, I'm trying my hand at some MySQL. Although I am a seasoned programmer, I have never touched MySQL and I am struggling to create a new trigger using phpMyAdmin. In short, there are 3 tables, "tblusers" "tblprofile" and "tblfamily". Assuming a user is logged in and they want to create a...

Hi all, I'm trying my hand at some MySQL. Although I am a seasoned programmer, I have never touched MySQL and I am struggling to create a new trigger using phpMyAdmin. In short, there are 3 tables, "tblusers" "tblprofile" and "tblfamily". Assuming a user is logged in and they want to create a...

Hi all, I'm trying to get a value from a closed workbook which is in merged cell B30:G32 and I get error 2015. If I change the reference to "E10" (a non merged cell) it works. Private Function GetValue(path, file, sheet, ref) ' Retrieves a value from a closed workbook Dim arg As String...

Hi All, Hopefully this won't be too confused. I have a "Register" Form to book people in and out using a Bar code etc. This form is called "frmBookInOut". When loading from the Main Menu, this form uses now() to calculate from. If a different date to day is required, another form is loaded...

Hi All, I wonder if you can help me, I'm trying to return some values using a connection from Excel to SQL Server. The code I'm using is as follows: select name, filename, convert(decimal(12,2),round(a.size/128.000,2)) as FileSizeMB ...

Hi All, Here's a good one for you. I've got a report, which for each record,highlights fields depending on the values in that field, think Conditional Formatting, however, I have got this working for a number of different values, for example, I've used percentages in blocks of 10 as below...

Hi All, I'm trying to create a generic routine to pass a SQL statement to and return a recordset. This code works if I call a function within MySQL, however, it doesn't work with a SQL statement. Any ideas? Routine for reading the returned Recordset Sub dftestRecordSet() Dim strSQL As...

Hey guys and gals, I'm new to MySQL, however, I am being told information by my DBA's which I;m not sure holds true. Can anyone give me some clue on if they are correctly analysing the problem. We have 2 servers working on a cluser using ndb on Lynux. Recently, over the past 6 weeks, we have...

Hi All, I'm sure I'm asking the most basic of questions, so sorry if this seems to be the very basics. I am trying my best to learn Java.... I have an access database which for example is called "myDB.mdb". I can access this database from a class that I have written to output a simple select...

Hi All, I know this is probably a really basic question, however, I am making my first entry into Java programming and I am struggling a little with the coding and errors I'm getting. My main issue is with this piece of code...

Hi All, I'm trying to create an image similar to the Blue Brothers image below: http://www.decalsandstickers.co.uk/catalog/images/blues_brothers.jpg http://archer.gamebanana.com/img/ico/sprays/blue_brothers.png Or the Opening Titles from the Inbetweeners below...

Hi All, I'm helping to organise a charity event, I do not have access to the domain for sending emails, however, I would like emails to be sent from Outlook as if I was using the charity account. Further to this, there are a number of people (40+) on the mailing list and I am creating a VBa...

Hi all, This is a really easy one, but for some reason Google can't help me!! I know it's possible as I've done it before, but I can't remember the code. When the form is called from it's calling form, the calling form passes it's name in OpenArgs. I am trying to get the process to call the...

Hi All, I'm trying to work out how to disable a single item on a popup menu. Let me start from the begininning. I've got a form with a treeview attached. When a record is selected using right-click on the menu TreeView, a popup menu appears. Depending on the state of the record on the...

Hi All, I've got a form with a treeview and a subform inside. Depending on the record selected on the TreeView, it will show a different form within the sub form. All sounding ok thus far!! Well, as part of the above, I'm using Case statements to define the form name, which is then used a...

Hi All, This should be an easy one, and it may be me being stupid!! I'm trying to create my first Excel Form, which shouldn't be too hard, seeing as I've used Access for 10+ years!! The issue I'm having is all I want to do is to add a couple of rectangle shapes from the toolbar into the form...

Hi All, I've got a little problem with a recent database I've taken on. The database has not had any changes to it recently (Feb 2010). There is a form, with a tab control. One of the tabs has a sub form with another subform embeded within it. When the "bottom" subform has a new record updated...

Hi All, Let me give you a little background to this. I have recently taken on an MS Access XP db. As part of this, I've reviewed the code and there is NO error handler at all. [noevil] I'm looking at creating a separate module purely for logging the errors. To save a lot of faffing, I wanted...

Hi All, I've got a form, with a subform included (parent/child). I've been asked to make changes to the system. Due to the way the enhancements are needed, I have had to create my own code to save, move records etc, intead of using the std Access record selectors. No problem with this, all...

Hi All, I'm guessing there is a really easy solution to this . . . Assuming I've got a multidimentional array as below: Dim arrData(1, 10) As String where x is variable and defined by a load process in a separate function. I could pass the total through to the child sub routine, however...