Search results

Grrrrr.... look bro. I wanna help. U got it zipped. I can't open 2 IE windows for some idiotic reason, nor do I have time, nor does the techy have time to fix this problem. So e-mail it to me at : brian@nbsprinting.com I will reply asap ok... Sorry about this.

Run an update query.... docmd.runsql(update "code you would get from sql when running the query normallly...") just run this code on the event required.... It isn't more complex then that. If you have the rest ready. zip the file and post it. I will find a way to update it doing what I have...

Run an append query Run an append query calling your c-t and append it all into a table m8...

Having not done this before... I am not in a position to aid you at this moment. I know you would want to pass the stCriteria back to the main form... Then search for a unique value in the recordset and setfocus there. Not sure this helps at all, sorry I can't help more at this time.

"the row (to records) where I change data (I have hundreds of rows in crosstab). " elaborate what you need to see a bit more... and I may be able to offer a solution, I am not sure I understand...

stLinkCriteria when opening the new form... pass through logon # you require and then write it when you write the record. if this field doesn't exist on the log on table, simply add it, and this is transparent to everything so far and pass it when you open form. only thing is when creating...

what I used to do... when I had this problem... dump the c-t into a temp table... / rst too if you know the code... work with it... then delete * it ... while it is populated, you can run update queries to make any changes you want, build work forms on it ... what ever you want...

sure... pass the parameter... look up functions in the help file. assign the value from your txtbox to the string/long to be passed and pass it through, functions can pass a parameter to an opening form.... Dim stDocName As String Dim stLinkCriteria As String stDocName =...

yes of course all it takes is willingness to code it and implement it... str1 pr for project str2 date format extract the 05 from it str3 c & 'concatenate ' an autonumber which would movelast . str3 = right(fldFileName,3) str3 = cint(str3) then str1 & str2 & str3 voila.. and if the pesky...

Well... having not done this... here is my logic... you have 2 options. user group level... say 1 being the highest when form opens, cmdbutton is hidden... on open, if user group level = 1, then cmdbutton.visible = true... 2nd option, make a new passwordform, modify it a bit, to open...

Ok so. Well, here is the problem I gather... After I pull access to the front, I think I mess up the arrangement of windows, I did read a theory on it... What it seems I need to do... Is assign the value at the time while its in the back. Then after I pull it to the front, re-assign it the...

Something I have done... Use a combo box on the entry screen. Have it read off of a 'customer table' / query ... or you can feed it off of a query grouping by customer name... Don't force users to select from it, so limit to list is set to no. If you opt for a table, what I have done, if they...

if you didn't get date function... DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) is another function u can look up.

Ok odd.... It always works the first time... but not after.... after changing windows for a second time, it only flashes.... Weird or what.? Damn microsoft! j/k'n :eek:

Boy this is tiring.... Declare Function SetActiveWindow Lib "user32" () As Long Declare Function BringWindowToTop Lib "user32.dll" (ByVal hwnd As Long) As Long Declare Function SetForegroundWindow Lib "user32.dll" (ByVal hwnd As Long) As Long all are functions I use to try and bring my...

Thanks Pat. This is what I found in the associated help file that may be able to help me... "The GetActiveWindow function retrieves the window handle to the active window associated with the thread that calls the function. HWND GetActiveWindow(VOID) Parameters This function has no...

Age easy... deduct the birth date from current system date. from there you can format your response... look up format() on help or searching through threads. I would spell it all out for you and give you the code, but it is in these forums, and did you try a search first...??? Often you...

exclude text leave the .text part out. just assign the txtbox to the field, and it should be fine. or txtBox.setfocus then write to the field... I only assign focus when required when i am writing, like with combo boxes sometimes and such.... when referencing .text and .value you must set...

Well used max function on a txtBox I will make invisible and use this to retain max order #. If any1 know a cleaner way, feel free to reply. Thanks.

here ya go =IIf([txtBox1]-5<0,0,[txtBox1]-5)