Search results

Thanks for the help. As it turns out it was just stupid me all along(no surprises there!) I was running the query BEFORE inputting the data in the dialog box. I stupidly thought that when I ran the query the dialog box would pop up. Not so as it turns out... Incidentally how do I close that...

Hi I have a form and when the value in a certain control is changed I want a query to refresh its data so that when I open another combo box on the form it will list the right values(picked up from the query). How do I get the query to refresh itself? I've been messing around with QueryDefs...

Hi I have a form based on an underlying query and this query prompts for 2 pieces of information before the form opens. I have created a custom dialog box which I want to use instead of one of the default dialog boxes the query pops up. I have tried placing a reference to the form in the...

Firstly to find the correct name of the subform, go into design view in the main form, now right click on the subform, select properties and the correct name for the subform should be in the blue part of the properties window, or under the "Other" tab. The point is the name of the subform to use...

I encountered the same problem as you and unfortunately I don't know how to solve it! I came up with another sol though and it works fine if your end users are ONLY accessing the tables through the form. (No datasheet view etc.) I just set the required property for a table field to No. Then...

Excellent, and the problem is solved! Just whipped out the # to specify my field as a number and bingo. Thanks very much! Liam

Can't I'm afraid, each segment can have a number of different poles so to ensure that I get unique records in the table I have to use the two fields combined as the primary key.

Hi, I have a form which opens with specific criteria. The code I have for doing this is as follows: stDocName = "Network Refurbishment 20kV-QuickUpdate" stLinkCriteria = "[Segment]=" & " ' " & Me![Segment] & " ' " DoCmd.OpenForm stDocName, , , stLinkCriteria This works fine but I...

If I understand you correctly you have two forms which are based on the one table. If this is the case check that the data entry property on both forms is the same. This is under the the Data tab in the properties window. Setting this to no would cause the form to appear blank when there is no...

I have a form that contains 2 subforms. I have a save button for the purposes of saving any information entered. What I'm worried about is a user entering an incomplete record, deciding they don't want to enter any more information and hitting the x or closing the form. What I have then is a...

I have a form and it contains a button to preview a report. That's fine, however when I close the report the form is not maximised anymore. What is causing this. In the forms OnCurrent event I have DoCmd.Maximise I want the form to still be maximised when I close the report. What is causing...

I have data entry forms but I want to include a button whcih allows a user to close the form but not save any current information that they may have entered in the form. As default Access saves the record to the table when the form is closed. At present i have the following code in the button...

Hi, I have a form with a number of checkboxes. However rather than clicking on them with the mouse to select their value can I tab into the check box and use a hot key or something similar from the keyboard? Liam

Can I refer to tables or the information in tables in a database that is closed from an open one? Liam

I am backing up all the tables in my database onto a blank database using the DoCmd.CopyObject method. This is working fine but I have trouble with tables that are in relationships. I want to keep the relationships but I am prevented from copying over tables that are in relationships. How do I...

Thanks, adding the checkbox is actually what I ended up doing because I couldn't find another way around it! thanks for the help Liam

Hi, I have a continuous form which displays records from a particular table. I want to be able to select a number of records using the record selector on the form and then displays only those records on a report. How can I do this? If I use an "Open Form" button I can open another form and...

Hi, I have a continuous form which displays records from a particular table. I want to be able to select a number of records using the record selector on the form and then displays only those records on a report. How can I do this? If I use an "Open Form" button I can open another form and...

I've tried this code but I'm getting an error Runtime '438': Object doesn't support this property or method Any ideas???

Hi, I have a form that I use to enter records into a table. However when I open the form I want it to display the last record I entered from the table to save me re-typing some duplicate information again. Maybe the information in the fields could appear in a different colour to show it's an...