Search results

Did you notice if your entering duplicate information? say you put flood defence and then picked water before? it may not allow you to do that, you might also want to double check your tables and make sure you have the fields set to accept duplicates(if thats okay). hth

you may need a format tag: example: format[fieldname],"##,##0") play around with that by changing where and how many #'s there are to suit your needs it should work and keep it set at percentage. HTH Rpb

all right from what I understand this may help you out. on your form you have at least 3 or more fields one which says "OT" or not and the second says the class adn teh third says the rate. in one of the events maybe you'd use the "on Load Event" put If fieldnameforOT = "OT" and...

im not sure what you mean by you cannot add another query to your report..how come you can not? -Rpb

thanks Pat I tried to find out a way of eliminating the records from the reports without actually deleting the records from the table but I havent yet could you or anyone else point me in the right direction? thanks, Rpb

this may help you Im not sure. In the format event of whatever header your getting that stuff in try this: If fieldname= "" Or IsNull(fieldname) Or IsEmpty(fieldname) then fieldname = "0" end if I think something along those lines may work if not just ignore me. Rpb

well a field by itself only has a control source, but I'm assuming you mean a combo box, and yes it is possible heres an example: In a combo box I have the control source set to "Manager" so it will save the information to the manager field in whatever table that field came from, however for...

Okay I have a running sum on a report that gives me totals on the bottom, also when certain conditions are met some records are not shown/printed but the problem is when this happens the running sum totals are still adding up the records that are not shown..is there a way to skip the certain...

well if you have the total count value successfully captured in a query this should be relatively simple to solve. First open the form in design view and double click the gray area under the form, click the data tab and click on the recordsource line (should be 1st) click the ... next to the...

ayeshamiah could you please post your solution if you find it I will need to do somehting like that a little later on and would like to see how it works before I get there thanks!

sorry i don't have a specific answer for you as Im still new to this to but maybe this can help you get started. If it were one field this is what I would do If field name = "" Or IsNull(fieldname) Or IsEmpty(fieldname) Then fieldname.setfocus or something along those lines so that when it...

ohh man travis thanks, I was assigned to work on something else and was just getting back to this today and realized I had a question out here, thanks it helped a great deal..made me feel stupid but still helped =) thanks again, Rpb

hey J, I have created reports and have had to send them to management before so I understand where you are coming from, what mail client do you use? more importantly is it Outlook? this may be to simple but when you view the report have you gone to file/send? and then tried RTF or an html...

Open the for in design view, on the toolbox click the icon that looks like it has 2 little windows on the right side of it , then click and drag on the form to make a subform, resize it after your done if necessary, to enter into the subform double click on the white somewhere if it doesnt work...

Hi on a find button I have a message box that pops up and gives basic instructions to the user, what I would like is to have a small popup form open and give the instructions that also supplies a checkbox or whatever and when it is checked it would not display that form again. all I need...

yup, Im assumiong your going to be transferring from one text box to another, if both forms are loaded simply put in the code. Forms![form name you have the date it]!chkmanager.Value = "name of the field on the current form you want the date to go to".value I'm thinking the best place for this...

thanks bob and louise based on your replies I was able to correct the problem, it was a huge help and Im glad that problem is over with thanks! Rpb

yup they are all in the subprojects group header. I was originally executing the code from the on print event but then tried the format event upon your reply. I have decent experience in VB and I have no idea why this isn't working in VBA. thanks again, Rpb

unfortunatly that does not work, it still only changes the first control. how do you get in there and change the properties of each control? you cannot do it the normal way field1.visible=false or whatever if anyone needs more clarification on the problem just let me know thanks again, Rpb...

Hi I have a quick question you guys/gals maybe will be able to answer. how the heck does vba handle controls ? My probelm: I have a report that when a certain condition is met I want certain controls to not be visible when printed. ---------code---- If Subprojects.Value = "" Then...