Search results

This sort of thing is very common when Form properties are changed during Run-Time and then the Form is placed into Design View (oops). When the Form is started again, you will get a "Do you want to save Changes" message. If Yes is selected, then chances are that if code had changed properties...

Hmmmm....Lots of Message Boxes. Try this instead. Add the following to Tag property for each of the following Text Boxes listed below (do not put in Quotation marks): Text88: Please enter Lan ID-CHK Text90: Please enter Staff ID-CHK Text94: Please enter Franchise-CHK Text92: Please enter...

Try this: Bind the frmMASTER to the Bands Table or Query: Make sure you check to ensure the Table Name and the BAND ID name are correctly spelled. Make sure the Controls within the Tab Control are bound to Table (not the two Combo Boxes above the Tab Control). Dim StrgSQL As String StrgSQL...

Assuming all your queries take into account all the Controls on form are bound to the same Field and those Fields are within each of your Queries: Forms("MyFormName").RecordSource = "MyQueryName" Forms("MyFormName").Filter = "YourFilterString" Forms("MyFormName").FilterOn = True If your other...

A 80MB Text File? As in 80 Mega-Byte? Is that a typo? With the code you have posted, it should work. It's just that it would take about 15 to 20 minutes to process (I should think). .

I would suggest you remake your SubForm based on your Query. Perhaps there is something in the Query the Form can't handle. Use the SubForm wizard and see what happens. .

In your case, because there was a Sample DB to deal with, I created the Query Statements directly within the VBA Editor. If you would like to send a striped version of your DB with some fictitious data then I will gladly take a look at it to see what the problem is. Just send me a PM. .

Make sure the Link Master Fields and the Link Child Fields properties are properly set. The properties are located under the Data tab in the properties window for the SubForm Control. Try removing these links. What happens? .

Is this line going into the Control Source property of a Control? If so, when the line is pasted and focus is removed from the property Access should convert it somewhat to look like this: =DCount("*","q_SessionGrid",[Form].[Filter] & " AND [Attendance] = 'A'") Perhaps this is not happening...

Because the Form is Filtered, the easiest way would be: =DCount("*","q_SessionGrid",Form.Filter & " AND [Attendance] = 'A'") or of course: =ECount("*","q_SessionGrid",Form.Filter & " AND [Attendance] = 'A'") .

If you have a query that pulls up over 500 results and your SubForm was originally based from and is now bound to that query then your SubForm should display over 500 records.....unless you have an active Filter on the SubForm. Go to the SubForm from the Database Objects Window and place the...

You can pass he Item you want to add through the OpenArgs property of the OpenForm method. For example: If you want to pass a String to the Opening Form: DoCmd.OpenForm stDocName, , , , acFormAdd, , "My String Value" If you want to pass a Number (3210) to the Opening Form: DoCmd.OpenForm...

You should be able to get the count you want with either DCount or ECount. The advantage of ECount is that it allows you to count the number of distinct values. For either the DCount Function or the ECount Function to give you what you need you will need to also apply the filter used to...

Forms![main]![sub].Form.RecordSource = "YourQueryName" I'm assuming of course that you have the relative field within the query for the Link Master and Link Child Fields properties and if not then ensure there is nothing in the those properties. .

Your Form that you are opening should opened in Dialog mode then after the OpenForm code you would have: Me.cmbClient_Name.Requery DoCmd.OpenForm "MyFormName", , , , acFormAdd, acDialog Me.cmbClient_Name.Requery When you open a Form in Dialog mode this way, the code halts until the Form is...

This is an odd one. I can not duplicate that problem with the Sample I posted, it works just fine. If you look at the For/Next loop which generates the copied Records you can clearly see that is is based off of the number contained within the Text Box beside the Copy Record button. If there is...

To be honest, and I could obviously be wrong here, I'm not sure you can do that with the TransferDatabase Function. Not the end of the world though, you can do it with a SELECT query. Here are some examples: The Query samples shown here to Copy a Table are based off of the following principle...

I realize you have your solution but I just thought I throw a penny into it. :) You didn't specify where you have this code located but for what is happening to you I would say you have it within the LostFocus event of the Combo Box. If your Form is bound to a Table or Query then this really...

Give it a try Ken, I think you will find that it's a lot easier to use than it appears and I believe you will like the results. .

The code provided goes into the command button that is in the SubForm (plase correct me if I am wrong): Private Sub Command6_Click() If DCount("[StaffName]", "qryppe", "[StaffName]=' " & Forms("frmsubmain").Staffname & "'") > 0 Then Exit Sub DoCmd.OpenForm "frmppe", acNormal End Sub...