Search results

Thanks Peter. It worked. U gave me the logic and i cpmleted the rest. on afterupdate event check for data if data found then make sure box below is enabled. if no data found check box below for data, if found copy to self and delete from box below, run after update event for box below If no...

I have another question related to this thread. What about FE open but it is not accessing any data from BE. I mean the FE is open but no object is open. In my application the user navigates through toolbars and menubars. There is no swithboard etc. So if the user hase no objects open in the...

NextDate = DateAdd("d", 1, Date)

Someone help ............!!!!!!!!!!1 i cant figure out

Me! ... i appreciate your response... and i already understand it...... actually i had a situation in ehich i needed to change the system date format. and under winxp i am sucessful. I just want to know that does the code i have posted earlier work under win98 and other versions of windows...

can ypu upload these documents to this forum or somewhere else .... or send thsese docs to me by email. Im sending a pm for my email address.

so what are the values for different types of variables which have not yet been initialized

what is the difference between null , "" , empty, nothing etc. how to reset variables (string, integers, dates etc) eg: dim abc as string abc = "This is a string variable" abc = ?? empty or "" , null , or what

I want to make an unbound form that has the functionality like the form found in access for reports wizard. I want the user to be able to select the sort order dynamically for a report instead of a fixed sort order. But i'am unable to sort out my own problem :mad: plz check out the...

Thank you Wayne

Thanks Doc. now this issue is clear to me. Alaways backup after kicking out everyone out of the db.:D u have done a great job explaaining me about this issue. Thanks once again

Thank you ...... JON I am very thankful to you for taking your time to solve my problem. :) Both the methods worked perfectly alright..... U Rock ....!! :cool:

Is it possible to set a refference through code ?

what are the problems problems or differences backing up while db in use and not in use.

you are right. The issue date is a date feild. but i have tried to pass the dates like datevalue(startdate) and datevalue( format(startdate)) But still not working. Doc MAn plase help me.... Im in great trouble.

is it alright to backup the backend while the database is in use by other users connected through front end or users must log off before the backup

Functions for date calculation 'previous month first date Public Function PreMonthFirst() PreMonthFirst = "01/" & Month(PreMonthLast) & "/" & Year(PreMonthLast) End Function 'previous month last date Public Function PreMonthLast() Dt = Date PreMonthLast = DateAdd("d", -DatePart("d", Dt), Dt)...

Im stuck with this problem for the past 2 days ....... plz plz plz help me ......!!! i have a table containing "production_orders". With feilds (BatchNumber, IssueDate) and some other fields I want to get thoses production orders who fall between the two given dates. The user inputs these...

how can i tell if a certian API is compatible with win98, winxp etc

this code is working perfectly right on winxp. And i can also check the current date fromat without changing. but i want to know that would this code be compatible on other versions of windows (win98 and above )? i dont have access to win 98 , winnt etc.