Recent content by Nilay

Thanks for reply. I am attaching image which has been marked red and blue for better understanding. Because the red part has grown, the adjacent text boxes (blue part) also grow which I don't want to grow. The text controls have been manually arranged in this fashion so I don't see why they are...

Hello here, I have a report created from scratch design which has several text box controls from a query. All the controls are arranged in 4 (visual) columns. I've set all controls 'Can Grow' to yes. Problem is, if a control grows in 3rd column, it automatically also grows adjacent controls in...

I'll require slightly detailed help. I'm not using docmd.transfertext but plain simple macro in Access 2010 (screenshot attached). (Can I export report with docmd.transfertext ? - on searching found that this has an argument 'tablename', so I presume that only tables can be exported by this). If...

When I export a Report to txt file, by default it is exported to 'User/My Documents' folder on C drive. For my application, I want the file to be exported to the same folder which contains the database. Is this possible ? I guess (and hope) it would be as simple as executing some code for...

Hello. I am attaching the properties window; bound column is column 3. Seems that there is some other problem. Once again restating - text disappears only when that product is no longer pending i.e all order quantity has been invoiced. Meaning that when the product disappears from the mismatch...

Sorry, attached the file in my first post now..Thanks

As in the attachment, problem is with the 'Product' field in the sub form. After selecting from the combo box, the text disappears. The record source for this is a mismatch query - only products pending to be billed against a particular order are displayed in the combo box. For example, if the...

Yes, but the backup is more than 15 days old. Besides the data, I also had done lots of design modifications taking inputs from my staff; is that all gone, or is there a way to retrieve ?

I had 'compact on close' checked in my database, but had never experienced this problem before. Today, about 10 minutes ago when I closed the file, I got a message that 'access can't delete the file....', and on clicking 'ok', my database disappeared. It isn't even in the recycle bin. I found...

I guess those symbols appear for tables in relationship view; the attached screenshot is of a query design which also has queries and not tables. I'll be able to attach the relationship view in a few hours. In the mean time if this can help - Invoices table has 'invoice number' as primary key...

Hello. I run a trading business. My present system allows me to add purchase order from customer, and the invoice that I add allows me to select from dropdown the price of the product as it was input in the PO. PO has a subform 'PO product' and invoice has a subform 'invoice product'. Since I...

Thank you all. It is forums like these that encourage individual self-trained users like me to experiment with Access, knowing that if there's some problem, answers will be around. Here's what I did - I dropped the idea of continuing with autonumbers for invoice numbers. Instead I converted it...

Thank you all. I do have a date field. This sounded easy to less knowledgeble me, so this is what I did. I have now added a field 'Prefix' in the table (current default value is '0809-', will change it to '0910-' from Apr 1), so the invoice number now is 'Prefix' & 'InvoiceNumber' (autonumber...

I'm aware that there is an option to have autonumbers appear in sequence or random; I want them in sequence. It it only the prefix that I want changed for new invoices. I guess 'use code' means some programming, which I am not well versed with. I've used 'if' conditions in queries, but don't...

I have a table 'Invoice', which has an autonumber field 'InvoiceNumber'. The prefix on the autonumber is '0809', that being the current financial year. (Btw, I have given the prefix by specifying the format of this field as "0809"0). I would like to change the prefix to "0910" beginning from Apr...