Search results

Hi guys, I have a form with a combo box, and when you select an item from this combo box it displays all the records that match that item in a subform. All OK so far. Trouble is, once you've selected an item and the matching records are displayed, when you then click in the subform the first...

Gday, I posted this in the "Word" section since it's a Word document I'm working on, but I'm guessing it relies on VBA anyway, and the lack of response there has led me here. I'm doing a mail merge and I want to instruct Word to retrieve the contents of the previous record, not the next...

Is there some way to adjust the vertical alignment of text in a text box in a Access 2k2 report? It seems to do top alignment by default, but I want to change this to bottom alignment.

Display most recent record when multiple records for an item exist Hi, I have a table which stores a list of all our loan computers and their loan history. Each time a computer is borrowed, a new entry is added to this table, and when it's returned, a checkbox is cleared to show it's no longer...

Hi, I have a parent form which contains information about PCs on our network. In this form is a button which, when clicked, will open a second form and display any licensed software installed on that PC. The heading on the child form is 'Licensed software on <asset number of the PC in...

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

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

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

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

I have created a database and want to restrict the priveliges of certain users so records cannot be deleted, designs changed, etc. Under the user and group permissions, I discovered that even though I'm logged onto the machine under my username, the 'Current user' is 'Admin'. I have no idea...

I have a database being used by several inexperienced users, so have created an instruction sheet as a desktop image. I have a 'Help' button in my database which I want to minimise all windows in order to show the instruction sheet on the desktop, in exactly the same manner as the 'Show Desktop'...

This is probably a very simple one, but I haven't had much success thus far. I know you can make a table field a drop-down combo box by selecting 'combo box' in the setup, and then telling it to get the data for the combo box from another table, but is there some way to do it without another...

I know this is possible in forms (Row source = [Field1] * [Field2]), but I've found no way of actually linking this calculated result to a table cell. Even better would be to do this calculation at table level so any forms or queries based on the table would have access to the calculated...

I want to generate a mail merge document to create wedding invitations. To minimise printing costs, I want to have two consecutive records on the one page. How do I do this? From what I've seen so far, the only way to get the next lot of data from the database is to click the |> button in Word...

I have a single row datasheet form, which, when in 'Open' view, displays several hundred records. I want to be able to have these records numbered 1-500 or whatever, in exactly the same way as the navigation bar displays which record number you're up to in the form. Essentially I just want to...

How do you count how many times a specific string of text occurs in a given field within a report? For example, if a database recorded the results of a voting session, and I wanted to count how many people had recorded "Bob" in the "Choice" field, how what format would I use? Whenever I try...