Search results

Hi Wayne, I just tried that, maybe I didn't do it the right way, didn't seem to make a difference. Could you send back the one you worked on so I can see what you mean? Ta, Greg

Hi Wayne, Thanks for your response, please find the zipped database attached. The form causing the problem is called frmSoftware. If you try to type a number into the 'EENo' field in the subform, the error will be presented. I tried importing the form and subform from my other database...

Hi, I've got a database I wrote a little while ago which has customer details in the main form, and details of all their orders in the sub-form. This works perfectly, and allows me to add orders into the sub-form. The two forms are linked through the customer's ID number which is included in...

It's OK, got it to work. Rather than running a macro to save the current record, I used the button wizard to hunt down the appropriate VB code for it, and incorporated it into the 'Generate Receipt' button code. For the record, this is the code. It ticks the checkbox, then saves the current...

Well I had a macro which saved the current form, but that didn't work. Nor did manually pressing the 'Save' button. Macros to save the associated query or table failed because the table/query in question wasn't open. In each case, the checkbox status didn't *appear* to be saved into the...

Hi, I have an address book for my customers, and once they've completed a transaction I want to generate a receipt. The way I've done this so far is to have a field in the orders table called 'GenerateReceipt', and a button called 'GenerateReceiptButton' for each record in my tabular orders...

True legend, thanks! :D Do you happen to have a listing of all the control characters? For future reference.

That *should* work, but all I get is the address, then two boxes, and then the suburb. Using Access2k. It doesn't seem to understand control characters. Is there some extra control character handler which has to be installed or something?

Hi, I've got a composite field in my report containing several fields from the query, but I want to be able to insert a carriage return and a line break (<crlf> in the example below). It's for an invoice, and in the database I have a field for address (i.e. street name and number), another...

I have no troubles modifying a query to cater for my search criteria, but what if you want the user to be able to do it, ideally at a form level? Similar to the 'Find' button in a form, but I want to create a datasheet or tabular form containing only the records I want. The closest I've gotten...

Super, thanks!

Thankyou gents, worked a charm! All I need to know now is how to indicate *how* to sort, i.e. A-Z, Z-A. Sorry for the simple questions!

This thread sounds very much like what I'm wanting to do, but I couldn't get my adapted version of the supplied code to do anything. I have a tabular form with column headings in the form header, and form information in the detail. I want to have a button next to a label in the form header to...

Thanks guys, there do appear to be a few bandaids available, but not really the full thing I was looking for. That's OK, it's no major drama, it does work as is, but I'm a rookie at VBA and thought there may be condition I didn't know of which would do exactly what I was after. Thanks for your help!

I think mailman has presented the issue I'm faced with, and I think you've answered it Wayne. Yes I know I can only type in the current record, but I'll explain exactly the situation. I have a datasheet form, chosen because it allows the user to view multiple records on one screen. In each...

No, using Access2k, but conditional formatting only appears to affect the appearance. VBA seems to be the way to do it, and as I said I can make all instances of certain fields enabled or disabled, but I only want to effect this in the current record.

I have a tabular form, meaning multiple records are on the screen simultaneously. When I click a checkbox, I want the associated fields in the current record only to be enabled / disabled, but all my coding efforts seem to enable / disable every instance of those fields in every record...

Sounds good, I'll give it a whirl!

Yep, but those directories are the locations of the quick launch bar for different users in Windows Explorer. If you put applications into that directory they'll appear in the quick launch bar. I made a shortcut from there and tried to paste it into Access, which is where I had the problems. Its...

Great, thanks. I don't have another copy of it yet, but I'll try restoring it as you suggested if I need to.