Search results

HI Everyone, I have a small form that displays some of my users codes and options. I added a command button which calls a function called testpassword. Testpassword takes the first Initial of First name and First Initial of last name, and then add to that a 4 position alpha numeric code to...

HI Everyone. I changed the following function, and can't get it to work at all. Public Function GetRangedays() Dim strSQL Dim frm As Form Dim db As Database Dim rs As Recordset Set frm = Forms!frmCalender Set db = CurrentDb ' Vacation ' The next line was...

Hi Everyone, I have a strange problem with my report. I am using a Dcount statement in a textbox in the Report footer section, to give me a total for the number of records printed on the report. This works fine when the report is limited to only 1 page. As soon as the report spans more...

Hi Everone, I have yet another Dcount question ? My problem is I haven't been able to format the the criteria correctly. Rather than someone doing this for me, I'd just like to know where or what to look at to accomplish this. I,ve tried it at least 50 different times with no success. I dont...

Hi Everyone, I have created a form with a TabControl on it, which has 11 Tabs. After the 7th tab Access will not allow me to add any more controls to it. I went to the following site, which said that total controls on a form or report could not exceed 754...

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...

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, 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...

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...

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...

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)...

Hi Everyone, I have written an App that processes data from a scanning program. A Text file. The form has a tabcontrol on it with four ( 4 ) tabs. On tabs 2 thru 4 all the entry information is the starting position in the file then the number of positions for that field. The first tab has the...

Hi Everyone, On a tabctl's onchange event there is no option to cancel. My question is this: Can the option to cancel be added to a tabctl ( on the onchange event ) using a Class Module, or is my understanding of what can be done in class modules all wrong. Thanks In Advance Skip P.S...

Hi Everyone, I have the need to read a text file as binary. It's really a fixed length file, but because of the specs I can't use Input # or Line Input # . Each dept puts the file out according to their own specs. ( I assume it's got something stupid to do with politics ) Anyway...

Hi, I have seen a number of requests for info on geting Table names, and Field Names into combo boxes. I have recently created a small app in A2k. Part of it, could be what some are asking for. There are two combo boxes on the form. The first box is filled with all the tables names in the...

Hi EveryOne, I am using A2k. I have written a function called x_lookup, to return certain fields in a table or query based on user input. Lets say one of the variables passed to the function is rtn_fld as string This variable containes the field name of what the user wants passed...