Search results

Hi, I have a report and when the page grows to a size where it needs another page it literally splits the text in 1/2 if the textbox happens to fall at the page break. So, If there is a textbox with even one line of text in it it and access forces a new page it will show the top 1/2 of the...

Is there any way to have a label show on a report only if one of the txt boxes has a particlar value in it? Say I have a label "Sign Here _______" and I only want this to show on the report if txtName has Bob in it otherwise the label sign here is invisible. Thanks. Fen How

Yes, i have tried it all over the place and it wants to count all of the pages in the entire query. It starts at each new page but says 1 of 6775 etc.., Thanks.

Thanks, ok I want it to show Page 1 of 3 for an example and when a new group starts it begins over again. Is that possible? Thanks

Hi, I have a report that goes like this Report Header Page Header Data1 Header Data2 Header Detail Data1 Footer Page Footer Report Footer In the Page Footer I have ="Page " & [Page] & " of " & [Pages] When I run the report it starts a new page when it should but the [Pages] is showing the...

Hi, Is there any way to select a record in a sub form and bring the main form to it? I have a sub form that is in data view showing all records, I want to be able to click on one of the records and have it show in the main form. Thanks. Fen How

Thanks, any way I can format the NOW() from 9/4/09 to long date? Thanks.

Great, I got that to work, any way I can make the fields from the DB bold? also anyway to auto insert the date? Fen

Thanks, do I put that in a label, list box, ??

Hi, Running into a bit of a problem. I am creating a form that has base information. There are areas of the form that will be populated from specific fields in the database. Is there any good way to accomplish this? I am trying to "insert" the appropiate data as show below. The text is...

Ok but i really need the result to be written to the table. So Box 1 is CRFileName (bound to the table as CRFileName) which is added when the user selects the file Box 2 is CRPath (Unbound) the path C:\File\ which is fixed Box 3 is CRLink(Bound to the table as CRLink)the result of Box 1 and Box...

Ok, another approach, i have three bound textboxes 1, 2, 3 is there anyway i can merge 1 & 2 to write in 3? Thanks.. Fen

Thanks, can you show me an example, i dont quite follow you.. but i am close.

Paul, the textbox is populated after a selection of a file is made using this code. The tbFile is the name of my textbox. Fen Private Sub Label510_Click() Dim strFilter As String Dim lngFlags As Long Dim varFileName As Variant Me.tbHidden.SetFocus ' strFilter = "Access...

I tried this and i get an error "You cannot assign a value to this object" when i run it? ="C:\Folder\" & [CRFileName]

I have a textbox that is populated with a value as a result of a button, that function works fine. What I am trying to do is have some information fixed and the result of the button added to the end of it. For an example, When I click a button the word mydoc.txt is placed in the textbox...

Sorry, i got it, had my col numbers wrong.. cant add :) thanks for taking the time. I really apprecaite it. Fen

Thanks, that looks like a far better way to do it, i tried it but the field does not pouplate, do i need the () around the Column? Vendor is the name of the ddl and VendorContact is the name of the text box on the form. Private Sub Vendor_AfterUpdate() Me.VendorContact = Me.Vendor.Column(10)...

Hi, I have a form that has a ddl which the user can select a name from another table called Vendors. The vendors table has Name, Tel, Address. On my form I have an area for Vendor (which is the ddl), Name, Tel and Address. When I select the Vendor from the DDL I am trying to populate the...

Got it, thanks for everyones help. Innerjoin query shows matches. Fen