Search results

I have seen several posts on here on this topic, but none have provided me with a concise implementable answer, and I'm in a bit of a hurry. I have a report that must have one of three titles, depending upon the information returned in the report query. If no instances of a value are returned...

I'm trying to change the height of a subform based on certain criteria from another form. That is I have a form that I wish to determine the height of a subform from. I've added code to the form along the lines of: Forms! {parent form name} . {subform name} . height = 6000 But this generates...

Works perfectly first time, thank you very much! Matt

Hi gang, I've been asked to modify a form of a database so that at the click of a button, the data entry form will be refreshed and ready for a new record with the values of the previous record (just entered prior to pressing the button), as defaults for the fields. This functionality isn't...

Hi, I'm trying to import a CSV file into access using the DoCmd.TransferSpreadsheet action. I've managed to get a workbook version of the CSV file to import by saving the CSV file as an Xls file and then running the VBA code with the 'spreadsheet type' parameter blank (to run the default). This...

I've Got it Working! I have found what my problem was. I'm posting my solution on here in case anybody else gets stuck at the same point I did. I had been using the RWOP queries incorrectly. I had changed the permissions so that no one except the developer user could run them (to prevent the...

Hello, I know there are posts on forums all over the internet on this topic, but it is just one aspect in particular that I would like some simple advice on. I have worked through user-level security suggestions online and made a test back-end database that has a user and a group, named...

Okay. Is there something that can be done along those lines? Was the author onto something there? If not then I'm happy to stick to the label idea. Matt

http://www.freevbcode.com/ShowCode.asp?ID=669&NoBox=True Could this, or a variation of it, be used in Access? Matt

I see, very good. It's a shame that using this technique prevents the user from dragging the window around by the title bar (for example to move it into a different position on the screen). But that isn't really a problem. Thanks! Matt

Oh I see. Okay then. Well if anyone knows of a way that I could change just the title bars of access windows then please post instructions for me. Surely there must be a way to do it with VBA? Matt

Thanks for the reply. I can't find the pop-up that you speak of. In fact, right-clicking an empty part of the screen yeilds nothing at all. I am using Access 2000, does that make a difference? Matt

Hello, I'm sorry if this has been asked before on this forum, but after a brief browse I didn't see it here. How can I change the colour of the title bar of a form? Thanks, Matt

It's Friday afternoon, I'll just be happy to get this form finished; doesn't matter how :) Thanks again.

No, that didn't work either. I'm happy to just use the query, it worked first time.

Using a totals query I've managed to get exactly what I wanted, so I may just use that instead. Thanks for the suggestion and your time. Matt

In the code for the OnClick event on a button. I'm storing the result in a variable which I am then returning in a MsgBox on click of the button. I was planning on using the result in an if statement, but wanted to check that it was returning correct values before I implemented it; and it's not...

Affraid not, it's an autonumber. If I completely remove the criteria section from my statement, it still returns the same results, it seems to be ignoring it. Any other ideas?

I'm trying to return the number of records in my table that have a Department_ID of 4. However, the statement returns the total number of records in the table, whatever the value of their Department_IDs. Here's the statement: = DCount("[Department_ID]", "tabDepartment_Rates", "[Department_ID] =...