Search results

Thanks for the help and advice, I'll be sure to look into the supplied links (tomorrow morning). Right now, at this side of the pond anyway, it's time to head home. My head is beginning to hurt :) Thanks again, and I'll post back the results as soon as I can.

Just to flesh out my original post a little more I have so far been working along these lines: Expr: Mid([ChargeRef],5,6) produces the following results; 12345_ Or 123456 (from ABC_12345_1 or ABC_123456_1) What would I need to add to the expression to get rid of the trailing underscore on...

Hi, I am having difficulty writing the expression that will extract a portion of a string. I'm busy looking at examples but for the life of me, I can't seem to work out the combination I need to extract the portion I want :o The string follows this format: ABC_12345_1, Or ABC_123456_1...

I second that! :( I will be looking at adopting the approach you have suggested. Thanks very much for your help. Looks like I'm in for a bit of a late night! ;)

Hi Brian and thanks. Sorry. In an effort to present my problem as fully as possible I failed to describe very much of it at all. I have an existing form (frmStockCount) which has a subform (frmAisles). frmAisles has 6 checkbox columns which represent stock take counts and 256 rows which...

Hi, I've managed to drop myself in it again! My boss has asked me to take charge of one of our existing Access dbs. The guy who wrote it is no longer with us and I can no longer contact him for advice and help on it. It is, essentially, a stock take tool and I've been saddled with the task of...

Hi and thanks. I totally agree with your comments, this forum is always my first 'port of call' for help and advice. I do search the web on a very frequent basis for answers to my problems however, I think that having some sort of text, on my desk and available immediately is a must have. For...

Thanks for your input, its much appreciated. I had no luck with the modifications though, which leads me to believe I should be looking at another approach. I need to generate five tables on the fly. All related and all generated in such a way the they populate with data in the correct order...

Hi, What appears to be wrong with the following: Dim strSQL As String strSQL = "ALTER TABLE [tbl_zone] ALTER COLUMN [blIsActive] BIT DEFAULT '1';" DoCmd.RunSQL strSQL I'm getting a runtime error every time, what have I missed? Thanks in advance

Hi, I need a good book! I'm not new to VB but I need a good, solid book which assumes a basic understanding but which leans towards intermediate to advanced levels. What do you suggest? Thanks in advance.

Hi, been banging my head against a wall for the last two to three hours trying to figure out something so simple that when I do get the answer, I'll feel like kicking myself. Hope you can prevent me from doing too much damage :o I'm trying to create a series of tables using 'ExecuteSQLDDL...

As usual, you guys Rock! :D I'm still not crystal clear on the reason this problem has given me so much grief (having no formal VB training can be a pain sometimes).:mad: The single quotes are removed as you have suggested. Now all is well!

Hi, I have a problem. Below I've posted two separate code snippets. Both are intended to run on separate AfterUpdade() events on the same form. As such, I have two (unbound) comboboxes on the form to retrieve the data. The first one works perfectly. However, the second one won't work at all...

Yes indeed. It certainly does! :) Thanks

Thanks for your time and the superquick responses. I will let you know how I get on! :)

Hi, I am looking at a whole bunch of example modules trying to find one that fits my needs. I'm a little stumped and could use somebodys help!! What I have is a large .xls spreadsheet that I have to link to an access 2k db for address label printing. The spreadsheet contains customer data and...

Thanks, the line spacing was indeed the problem. I now feel very stupid for not realizing this. Thanks again.

Hi, I'm under a bit of pressure to get this job done so I'm asking for help rather than spending too much time scouring the net. The solution should be obvious to me by now, but I can't for the life of me figure out what is missing... I'm working with charts and graphs in Access 2k and have...

Thanks for all your advice. I feared this would be the case. I was rather hoping that there was a way, other than relying on the honesty/integrity of the database user, to accurately confirm the success of a print job. Not meaning to be disrespectful to the operator but the 'user confirms'...

Hi, we ran into quite a serious problem the other day whilst batch printing a large number of reports from Access 2000. For some unknown reason the print job got interrupted part way through, resulting in a large number of reports not printing at all. Our database uses an sql fragment to set...