Search results

OK thanks - just one way to trim down the code I guess.

I have it as shown and it is working - what is the difference between the two? Sue

Thanks - actually it was Record Source - strange thing is I did have this correct but somehow the record source became part of the properties list and that was what was causing the problem. I must have been working in code and close the form before while the record source was entered and then...

I need to hide my subform on load or open of the main form but am experiencing some weird results. I have tried putting Me.SubForm.Form.Visible = False in both the on open and the on load of the main form and it works only if the tables on which the subform have records in them. If the tables...

OK - thanks for the response. I was getting an error but after your comment, realized the error was from the Subform on the Subform. I corrected the error and now the child parent linking is working correctlly Thanks

Can someone please help me with the code for VBA to set the child/parent properties for a sub form from the main? I have been able to set the record source, but can't find the correct vba term for the child/parent properties. I know this is basic stuff from many of you, but I have searched and...

No not Magic the Gathering... I will work on this again Friday and will try commenting out SGL until I can find the problem. The sub form does need info from the main form to display it's info. Could that missing info be causing such an error? Thanks for your response. Hiding makes sense...

I currently have a form with a combo box. The user selects a record from the combo box (a pack) and another form opens which lists all of the items within that pac and where the user applies an attribute to each of the items (say for this example, red or blue). Based on this 2nd form the user...

Thanks Bob and Galaxion, this has helped immensely. Sue

I have a field (SNumber) which is a text field and contains records that have a number which sometimes also have 2 letters on the right. ( examples: 1, 2, 3CD, 5, 6 HD). I am using the Right function in a code I am writing. If Right (SNumber, 2) = "CD" then .....rest of code here I would...

WOW - there is a lot of information here (just got back to checking) Thank you - I am sure I will be able to do what I need from your help. Sue

I know you can't execute a select query and you need to create a recordset but I am not finding any instructions that are helpful to me. The select statement I am trying to use is a follows: strSQL = "SELECT [PP Type TBL].[Prepack Type], [PP Type TBL].Width, [PP Type TBL].Height, [PP Type...

That was what I needed. Thank you!

On http://www.cpearson.com/excel/PlaySound.aspx I found how to access the Windows sounds - that work better as I don't have to store a wav file (though I did like the loud beep I found) Thanks for your help Sue

My database keeps track of training for employees, some of which expires after a period of time, which is in the tables. I need to create a query that displays only the employees and the training that expires during the next 30 days. I have a query that displays the expiration date (this field...

Is there a way to store the wav file in a table and reference that in the code? Sue

Will test that out - wondering if the path in the code works as it is or will need work.

That works - my concern is that this is a split database - need to know where to put the sound so it can be found. Is there another sound, standard to Access, that will always be available??

You are better than I am at Google - thank you! Will give that a try (though a gunshot may not be the best choice - I will need to find another sound!) Sue

I am writing a piece of code for a message box and really want get the user's attention, more than the standard DoCmd.beep. Is there any way to add another sound, something more noticeable? Thanks Sue