Search results

I have a macro in which I'm using TransferText action to import a tab delimited file. It works great, but I need the File Name to point to a default UNC path that the user(s) set up and store in a table of default settings, i.e. tblDefault, field=NetworkPath. Any ideas how to get the file name...

Being pretentious is OK Jack! Your approach should actually be more streamlined. Mine was based on a subform total being stated on the main form!!!

Creat and unbound control then on the On Current property of the form create an Event Procedure as follows Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb() Set rst = Forms![frmName]!Form.RecordsetClone Me.UnboundControl = rst.RecordCount

Add a basic image frame to the detail section. Add your field that contains the photo path to the detail section of the report and change the properties to visible=no. In the properties of the detail section of the report, click on events and ON FORMAT, select event procedure and type the...

I know we've visited this topic before, but I still can't get it working properly. I have an image path I'm storing in my table with a link to an image (object) control on my form. Works great, except when I go to a new record. The image control is displaying the previous records image until...

I just found the answer to this myself. Hope it's not too late for you. Creat an unbound control on your report and set the properties to: Name to NextNo Visible to No RunSum to OverAll ControlSource to =1 Now set up the control or unbound control you want to sequentially update with...

Why are you not basing your report directly on a query with the query parameters?

:( Me.Requery causes the field to not do any updating to the next record. The more I've been thinking about this, I think it has to do with the multiple primary keys. I'm going to do some experimenting with the autonumber key in conjunction with something like the date as the key also and see...

Thanks a bunch Dennis! That works much better! If you find out any more about getting it to happen immediately upon displaying the new record, that's the ultimate way I'd like to have it! Thanks so much for this forum!!!!!:D

It is one field of 3 that is the primary key, and no it's not auto numbered because I need to have for example multiple no. 1 but under different dates (one of the other parts of the key).

Try a requery on the subform!

I have a control on a form that needs to increment to the next available number on a new record. I have code in the event GotFocus and this works, except only when I click on the control or shift+tab back to it. I've checked my tab order (the control is first) and when a new record is started...

Thx, tried that already . . . any other suggestions ? ? ? ?

To the best of my knowledge you can only change the text color.

I have a combo box (CustID) w/3 columns (CustID, Customer, Phone, col. 1 is bound. I want col.3 to fill in the bound txtPhone box on my form after choosing the CustID. Here's my present code which always returns a null value: Private Sub CustID_AfterUpdate() Me!txtPhone =...

Thx a Bunch!!! It worked!!!!

I would create a pop-up box and tie that form into the query criteria. Type a text message that specifies the format in which the date needs entered, and/or create an input mask. You will also have to define it in the query parameters.

Thx Paris, but I have tried that and it puts quote around the IsNull and then gives me that data type error. I dont't want to use IsNotNull because I want to view all the Null date records. Any other suggestions?

I have a date field in which some records are blank. I want to query those blank records, but I keep getting a "data type mismatch in criteria". I have tried IsNull, "", ##. Nothing is working! HELP! [This message has been edited by kidzmom3 (edited 01-30-2002).]