Search results

Kara, try this DoCmd.OpenForm FormName:="Your Form Name", windowmode:=acDialog ' Stops Here And Waits ' For Information To Returm From Form Skip

Hi Everyone When you do a ORDER BY in VBA there is a limitation of 10 column's the recordset is sorted on. Is there the same limitation of 10 column's when you use the sort Property of a recordset. Also is there a way to override any sort limitations. P.S. IN either DAO or ADO Thanks in...

Sorry for the confusion. Next time I'll explain things in more detail. No I didn't use TransferText, I wrote my own code to handle everything. The bigest problem I had was stoping the code from running while I opened a pop-up form. I'm glad this one is finished, it was driving me crazy...

Hi Pat, That is exactly the problem. The date fields are in the text file I'm reading in, with only the position and length, or just the field number if the file is delimited. I have a couple of combo boxes, and check boxes on the pop-up forms that I open asking users to click or ckeck the...

Hi Everyone. Just getting back to this. After a little thought, I can only go with Doug's suggestion. The only information on my form is either position numbers and length's ,or field references if the data is delimited. None of the data written to the table is displayed anywhere on the form...

Doug and Pat, Our Internet Server has been down. Just came back up. Thanks for the reply's I think I'll use Pat's suggestion and use the BeforeUpdate event. Thanks Again Skip

Hi Everyone, When updating my table, I have two text date fields which could possibly give me the same Error. How can I trap the Error and tell the users which of the two fields is giving the Error. I looked up Raise.Err but am not exactly sure how to use it in this case. Thanks Skip...

Hi Everyone, Information : I just found out if you open a pop-up form with windowmode acDialog DoCmd.OpenForm FormName:="formname", windowmode:=acDialog forces all vba code that follows the openform method to pause, waiting for the form to be closed or hidden. Skip [This message has...

Alex, The easiest solutions always seem to be the last we think of. Thanks Skip

Hi Everyone, I have a main form which has a tab ctl on it that equates to 4 pages. During a lengthly sub procedure I call a pop-up form which gathers information on the type of text date field being read. Example: mdy, ymd, dmy, ect. plus whether it's a 4 position year, leading zeros...

Jack, Yes, I created my Variable in the code behind the form? Thanks Skip [This message has been edited by skiphooper (edited 03-08-2002).]

Hi all, I have the following problem. I start off with form A having a Public Variable as String. During the process I load form B which has the following code in it which loads data to a combo box. The only other code is for a close command button which set the public variable to whatever was...

Alex Thanks Skip

Hi jatfill, Thanks for the reply. It looks like that's exactly what I'll have to do. There are a few more formats, and one where they only send me the month and year. They dont care what the day is. Thanks again Skip

Alex, Now that you got that out of the way, try reading what I wrote. I'm reading in text from a .txt file and trying to create a date field in a table. the first one creates a date of 05/15/2229 the second one is a correct date the last one doesn't create anything. Skip [This message has...

Hi Everyone, I have some text coming in a delimited file. there are 3 date fields. Here are the fields as they come in, and the results I received. 120301 results 05/15/2229 12-10-01 results 12/10/2001 12192001 results overflow my system short date is set to MM/dd/yy...

Hi Everyone, I thought I was finished with a project when I found out the dates used in the program all come in with diferent formats. There is one situation where they send in a date field with only the month and year. and the final end result of this field must be a valid date field. Each...

Thanks Again Skip

raskew, worked just fine Thanks Skip P.S. Is there a way to loop thru the field names when the names are not sequential. Skip

Hi everyone, This is part of the code I need to cut down. ' ***************************** Private Sub updatesub1() int_loop = 1 rstID.AddNew rstID!stukey = txtStuNum rstID!SUBCD = int_I rstID!I001 = Mid(txtsub1, int_loop, 1)...