Search results

Right! Lets say you have a Form called "FormA" and a Form called "FormB". Now lets also assume you have a field in "FormA" called "Name" and you have a field in "FormB" called "UserName". so here goes; in the onClick event of the button you use to open FormB put the following: Dim stDocName...

Hi, I have a report which lists records from some tables. Lets for argument say there is a department table and an emplayee table. There is a one to many relationship with many employees belonging to a single department. The report is structed so that the main raport list department details and...

Hi, I have a couple of questions that I hope someone might be able to answer because frankly I'm lost! Q1. I have a continuous form which can list a couple of hundred records, obviously each line represents an individual line/record from a table. Now one of the fields displayed in each record...

Not sure exactly what you mean? Let me see if I have this right. You have two forms, Form A is based on Table A and Form B is based on Table B. Now you can open Form B from Form A. Now here's where I get a bit lost so I have two questions. 1. Do you want to copy information entered into some...

Hi, I have a button on a form which I use to delete records. The code behind the button is as follows: 'Turn off system messages DoCmd.SetWarnings False 'The response from the Yes/No message box Dim Response As Integer 'My customised deletion messgae Response = msgBox("You are about to...

What is this Auto Name correct feature, how do I get at it to turn it off? Sorry, idiot Access user here! Liam

Hi, Every time I open a report the page margins keep getting set back to their default windows setting. I've tried changing the page setup and then re-saving the report but this doesn't seem to work. Is there a way I can explicitly set them every time I open a report or is there something...

Hi, I have a field in my table by which I want the records to be ordered by. The values for this field are alphanumeric, something lke this: C12/343/567 C12/76/234 C12/3390/65 The problem is that the user wants these ordered "numerically", i.e. they want that example above to be ordered in the...

Hi, this is kind of a long problem but I'll explain it as best I can. I have two forms, Add a New Record and Add a New Code. Add a New Record has a combo box control and it gets it values from a query which gets its information from a Codes table. This all works fine, as it should. Now on the...

Thanks Pat, that solved it perfectly! Liam

I have a sinking feeling this is not possible but I'm going to throw it out there anyway. I have a field in my database and it stores Pole numbers. Generally these are 1,2,3,4,5,6, etc. etc. etc. Lovely and no problems there. However my end-user has a special numbering system for certain...

Hi, here is an update query I have in a section of VB code: oldValue = oldCodeValue 'the new and possibly changed value newValue = Me!Code.value 'the syntax for the update query that may have to run updateCodesQuery = "UPDATE [NETWORK REFURBISHMENT-WORK_COMPLETED] SET [NETWORK...

I have a form that has two subforms. I have a button that exits out of this form, when the user clicks it it first "undo's" any changes made and then exits (I have a specific button for saving also). I have the following code in the OnClick event of this button: 'Runs an Undo command to undo...

Thanks for the replies. Looks like there's no easy answer. I've seen something like this for sale by FMS Inc. which is what got me thinking in the first place. But I'm a tight git and I ain't paying =) Liam

Quick question, it isn't life or death so not to worry. Is there any way of putting formatted text such as bold/italic in a textbox, similar really to the same way in which we can do it here when we post a message to this forum. Is it even possible to obtain a patch to do this??? Thanks, Liam

Not sure how to do this, because you're trying to have one form and two different ways of searching for information. My way of doing this ( and it may be completely off the mark!) is to have two copies of the form and each is based on an underlying query. The fields in the two queries are...

A checkbox would be nice and handy but if you have some specific reason for the 'a/' and 'o' then here's what you do. In the OnClick event of your text box put : Me![name_of_textbox].Value = "a/" and in the OnDblClick similarly put: Me![name_of_textbox].Value = "o" If this doesn't work...

Hi, I have been developing an Access 2000 database on Windows 98 for the past 6 weeks. However recently I have come across a problem that I cannot find a solution for. This is going to sound bizarre but I swear it's true. The program has taken on a mind of it's own! My VB code is getting really...

Won't this just refresh the checkbox?

Hi, I have a continuous form and each line displays a record form a table. One of the fields from this table is a checkbox. I also have another text box in the form footer which looks up a value from an underlying query using DLookup. I use the checkbox to select certain records. When I click...