Search results

Thanks for the explanation, I will give that a try.

pbaldy, Thanks, can you you expand what you mean by a "utility mdb"? Is this a copy of the db that I have already? Is this a special type of db? Do I have to duplicate info? Sorry to be so ignorant but I have not heard of this.

Hi there, I have a list of registered customers that will sign up for a weekly Saturday seminar. Is there a way to auto-run a report 5 days before each Saturday, so that a courtesy call can be made to them. I have the report made, I am just not so sure how to make it print out 5 days before...

I was looking for something like how you might handle a msgbox() function by programing for vbYes or vbNo but I could not find anything like this if msgbox("Do you want to continue?", vbYesNo, "Continue?") = vbYes then msgbox"Yippeeee!" else msgbox"Bummer!" end if So the answer I...

Hi there, I like having the action query warning appear with what I am doing - "You are about to update xxx rows". The problem that I am having is that when my RunSQL statement in the code executes and selects no to the warning, I get the error - Run-time Error '2501' The RunSQL action was...

OK, Thanks pbaldy, I now see what you mean. I can not double click in the upper left box of the subform to get the properties as you do with regular forms. You have to select the subform so that the 8 sizing dots show and then right click on the subform to get the properties that way. Your...

I thought I was. I had the form open and right clicked on the subform and looked in the properties, but found no name property. Am I doing something wrong?

Why is there no name property for the form? There is one for the header and footer but I can not seem to find one for the form.

I have a form named "sfrmSumaryTotalPerDate_frmReports" in the database window. This form is a sub form of frmReports and when I loop through the sub forms in frmReports in VBA, I am told that its name is "sfrSummaryTotalPerDate" (ctl.Name). Why is this discrepancy occurring and how can I sync...

Solution I had a friend send me some code to locate a Monday and I modified it to find a Saturday. I would love to say that I totally understood it, but I am not sure that I do. It just seems to work. The key seemed to be the 14 in the intOffset statement but I am not so sure what the...

OK thanks, I am not sure what you mean about the vbSaturday and call back function. Is that some sort of a vba command. I will try to look that up and see if it will help.

I have a form and I need a combobox on the form to produce a list of Dates for every Saturday starting from the current day displayed in a short format for the user to select. Does anyone have an idea how I could manage that? I was going to make a table and write in each one and use that for...

Thanks for responding gemma-the-husky. I know that listboxes and comboboxes are 0 based and my function is returning a zero. I know this for sure because I did step through the code and saw that it was returning a 0 (like you had suggested). I actually thought that it might be returning an...

Thanks for responding gemma-the-husky. I know that listboxes and comboboxes are 0 based and my function is returning a zero. I know this for sure because I did step through the code and saw that it was returning a 0 (like you had suggested). I actually thought that it might be returning an...

I am getting a Run-time error '7777' that states "You've used the ListIndex property incorrectly." for code placed in an update button and it only occurs on the 1st entry in the listbox (all others entry's work fine). The form that I have contains a listbox (lstIngredients), a textbox...

Have you tried placing "DoCmd.SetWarnings"? I have turned them off at the beginning of the code "DoCmd.SetWarnings False" and then turned them back on after event was complete so that they were not left on "DoCmd.SetWarnings True"

I realise that lookups in tables is not a sound idea but I was trying to do a favor for someone and did not feel like getting into their design issues. Is there a way to write a sql statement that will enter the data in correctly?

Sorry for the double post, I can not find a way to delete this one.

I have a table (tblStudent) containing a field named fldTeacher1. Looking at the properties of fldTeacher1 I see that it has a lookup: Bound Column: 1 Column Count: 2 Column Widths: 0";1" (id number; teacher's Name) I am trying to run a DoCmd.RunSQL command in code and My question is how...

I have a table (tblStudent) containing a field named fldTeacher1. Looking at the properties of fldTeacher1 I see that it has a lookup: Bound Column: 1 Column Count: 2 Column Widths: 0";1" (id number; teacher's Name) I am trying to run a DoCmd.RunSQL command in code and My question is how...