Search results

I used the line method to draw a box as described on: http://support.microsoft.com/kb/210321 I was wondering if there is a simple way to give the box drawn in such way a shadow effect. (I guess I could always draw additional lines and play with the coordinates but was hoping there is a simpler...

Thanks a lot Ziggy1; I finally got back to that report and your solution worked perfect. At first I had some problems (my fault) and tried things like changing the recordsource of the subreport with vba, but was getting errors that source cannot be changed on printpreview. That went back to your...

solution Yes, those were correct.TThe subform works fine now. My problem was: I had a vba on current event in main form that was setting allowadditions to false which I completly forgot about - how stupid of me. Sometimes I think one simply has to take a brake, wake up in the morning and find...

I'm just starting to design reports and already ran into the limits of my knowledge, so I hope you can help. I have a Class name as a header and then a detail section that has the following fields: Date of class, Teacher, and other... I wish my report would show the Class name in the header...

Hi; I have a subform linked with a Main form. Both linked to seperate tables. The subform is in a Single form view. When I try to add new record (via button created with the wizard) ,using just the subform by itself, it works fine. However, when I open the main form with the subform and then try...

I have a frmMain with field AmountAvailable and sbfDetails with field AllocatedPayments. How can show a warning MsgBox when the SUM of AllocatedPayments is larger then the AmountAvailable? I'm not sure how to replicate the SUM function in VBA (do I run SQL statement that uses SUM?) and how I...

Another question: What if I want to use a custom function for the row source? e.g.: SELECT tblClassesAttended.ClassID FROM tblClassesAttended WHERE tblClassesAttended.IndividualID=ValueFromFunction(); Would the best solution be a VBA that presets row source properties for my controls on LoadForm?

Michael J Ross - thanks man, that does it.

I have two tables: tblA with PersonID field; tblB with PersonID field and AppointmentDates field. Tables are joined on PersonID field. How to run a query which would return all records from tblA and only the most recent date from AppointmentsDates field from tableB? Do I use GroupBy somewhere...

Could someone answer the above? Mstef, thanks for the tip but I knew about the BETWEEN; this doesn't solve my question but I'm having a hard time to explain why. Maybe some tips on the quote above would help me to ask the question again in a better way.

solution I found a solution, the row source of the control should have: SELECT tblClassesAttended.ClassID FROM tblClassesAttended WHERE tblClassesAttended.IndividualID=Parent!IndividualID;

I have a main form with a subform. On a subform I created a combobox which I want to populate with ClassIDs that match the main forms Individual. I know the criteria in VBA for the above would look something like this: "SELECT tblClassesAttended.ClassID FROM tblClassesAttended WHERE...

I have two tables: tblClasses & tblSchedule. There are joined by ClassID. For each class in the tblClasses there are several records with date field in the tblSchedule. (So each class stored in tblClasses happens on multiple dates stored in tblSchedule). I want to create a query (SQL view) that...

the problem is that my form then would have to have 2 comboboxes but the delete request would be a very seldom accurance, so I'd rather use some other solution to keep my main form clean. Is there no way to initiate some sort of behavior after the user picks a value from the combo and then...

I'm sorry, I forgot to specify that my ID column is not an autonumber index - it is the index column on which I sort. As Pat writes above, it is a "manually" inserted number which tells the query how to sort the classes. I should have called it differently not to confuse you, e.g. SortID My...

My combobox looks up values from a table. If the user types in a value which is not in a table a msgbox comes up asking if he wishes to add it. If he accepts the value gets added. However, how should I handle an instance when the user adds a misspelled value and then wishes to delete it? How can...

I have a tbl ClassTitles. It has two fields: one is a custom ID the other is a className. I use the ID to properly sort the classes in order in which they need to be taken(this order is used later for certification requirments and many other quaries). However, I need to create a form where the...

possible solution Just wanted to add a post on how I proceeded (someone may find it useful): I used a table to store the WindowHandle and each time a new instance of my form gets activated I update the record with its handle. Then I Dlookup the handle when I need to refer to the Last Instance...

I have a tbl ClassTitles. It has two fields: one is a custom ID the other is a className. I use the ID to properly sort the classes in order in which they need to be taken(this order is used later for certification requirments and many other quaries). However, I need to create a form where the...

Partial records are accepted. The subform is sitting on a TAB control and it has the following buttons: Add New - it changes allowadditions to TRUE Save - disabled when when no records exist and/or after the last one was deleted Delete - disabled when no records exist and/or after the last one...