Search results

I have an address section on a report. I would like to know a way to make any txtboxes that are empty not take up a line in the report. example: if the [address2] field is empty I would like the next field [City] to be directly under [address1] rather than have an empty line seperating...

i have resolved the problem.... thanks for all of your input. for anyone interested: Private Sub cboFindDrawing_Change() Dim strRecSource As String Dim strLink As String Dim strDrawing As String strLink = Me.txtLinkRef.Value strDrawing = Me.cboFindDrawing.Value If...

I am having absolutely no luck with this....... Maybe I need to start from the beginning again. How do I change the recordSource of a subform...it has to be possible. I will make two queries... one with no criteria one with a single criteria(the value inside the cboBox on my main form) I...

ok I have the subform so that it only shows the records that are related to the number selected in the combo box in the main form.....and you can change the number in the combo box and it requeries nicely..........problem is that when the form loads there is nothing in the combo...

here is what I have now........It almost seems to work but I get runtime error 2001 "you have cancelled the prevoius operation" message. Does anyone know what causes this error? I have searched and come up with very little.....is there a problem with my sql statement? Thanks for the help I...

Thanks for the help.... I changed the record surce to a query, I tried to requery the from but I get the same problem. An error message tells me that the form (subForm... in this case)does not exist or that it is closed. The form does exist. I tried making a new form.... but got the same...

yes frmUser is the active form..... I have a combo box in frmUser that I want to use to narrow the record source of frmUserSub. ie:Only the records related to the the drawing number selected in the cboBox should come up in the subform. But i can not seem to reference the subform. I have...

frmUserSub is a subform and is not current i tried Forms!frmUser![frmUserSub].RecordSource=.... but now it says it can not find the FIELD frmUserSub do I have to reference the area in the main form that contains the sub form?

Does anyone see the problem with this code.... I get an error that says that the form frmUserSub does not exist......yet I assure you that it does. Private Sub cboFindDrawing_Change() Dim strRecSource As String Dim strLink As String strLink = Me.txtLinkRef.Value strRecSource = "Select * from...

Is it possible to display the records in a continuous form from left to right as well as from top to bottom? my form is square in shape and I would like to be able to display 2 records per row. thanks, P

I have a make table query that needs to only use the data that is dated the previous fiscal week to the current date. The field is in "yyww" format. I can not seem to get this to work. I tried the criteria datepart("ww",date())-1 with no success... I have even tried hard coding the criteria...

thanks, that worked great for getting the data into the correct format... Now I am back to the problem of access dropping the leading 0 in the week part of the format for week numbers below 10. how can I force it to preserve leading zeros in the "yyww" format when the format is forced through...

I have a field that requires a "fiscal week" for data. I formatted the txt box "yyww"...this works fine, it shows the last two digits of the year followed by the number representing the week.example: 0201 Problem is that this all has to be exported to a text file and when the yyww data goes to...

is there a way to force the date format 'ww' to display two digits for example week 1 = 01 not 1 ... every other date format seems to have an option for holding places but not ww. Am I realy going to have to count the digits and concatenate a zero every time I have a single digit week? pls...

That works perfect...Thanks Is there a way to change the caption of the zoom box? p

can you give me the syntax for using the built in zoom box....I can't find it in the help files or in my books all I can find in reference to zooming is using shift f2. Thnx P

that sounds like exactly what I need... thanks I have never worked with it though. thanks again p

I have a form with a subform all is good, they work fine. The subform displays multiple records. I want to add a text field to the sub form for a "description" field. This field is of memo type. The problem is that I do not have room to add a big text box onto the subform. How can I make the...

I want to have a form"switchboard" that determines what "mode" another form will load in. So I need a flag variable that will determine whether the user clicked the VIEW ONLY button or the ADD button. In the past I have declared this variable as Global in a seperate module. example "dim...

How can I force my subform to refresh from a cmd button on main form. the button is supposded to calculate values in the subform based on some queries that run against subforms table, but it doesn't work until i close and re open the forms. I am assuming that the info is not making it to...