Search results

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

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

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

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

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

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

Hi, a colleague of mine has Office 2000 installed on her work PC in order to carry out Access datadase responsibilities (amongst other things) as part of her job. I think (though I cannot be sure) that someone has 'locked down' the copy of Access to such a point that shift bypass no longer...

Hi, I found a couple of short threads on the forum discussing the above. None of them go sufficiently far enough into detal to help me solve my (relatively simple) problem. My boss has asked me to produce both mean and mode calculations for the number of pallets we ship to our branches on the...

Hi, I need to find a simple and efficient way to log past transactions into our database. Our deliveries can be anything from one day up to a week old before transaction data (including actual dates) is recorded. As we log in excess of 275 records a day, I'm hoping to save a few keystrokes by...

Hi, I have a problem I'm trying to solve using an expression in a query So far I have a working expression giving me the result I want. Simply it's: subtotal: ([ChargeA])+([ChargeB])+([ChargeC]) etc. etc. However, I also have to apply an effective 'Cap' which I'm calling a 'Full Load...

Hi, I would like to know if it's possible (if so, how) to restrict the data produced by a report to records that have a (currency) value greater than £0.00. Currently, the report is based on a query which does most of the 'donkey work'...creating subtotals etc. The report itself is calculating...

Hi, I'm trying to write a Sub which is to display a message box should a particular field be null as a user tabs through the form. The control itself is on a subform as you can see from the supplied example code below. I have a feeling that 'Null' is an incorrect property but I'm also uncertain...

Hi, I have a module with which I would like to offer the user an option to cancel their action using a dialog box. Being new to VB, I'm not quite sure how to implement this. Here is the content of the module so far: '------------------------------------------------------------ '...

Hi, I'm looking at using the 'AutoFillNewRecord' sample to input a previous date into a new record. I am using the Calendar control to pick the 'date of transaction' (which may be anything up to a week prior to the current date). The date picked may have to be input for a full 180+ recordset...

Hi, New here, first post! I need to find a way using a module/VBA or even a macro which will 'flag' duplicates in a sequence of numbers. For example, I have a list of delivery destinations in a table. Each delivery is unique but some share the same destination. Because of this they are...