maybe this can send you in the right direction see
http://bytes.com/topic/access/answer...-word-document...
southoz
Last Activity: May 18 '09, 02:00 PM
Joined: Sep 16 '06
Location: south oz
-
take a look at this thread it'll tell you what you need to know.
http://bytes.com/forum/thread559954-southoz.html
southoz...Leave a comment:
-
Good ay , I did something like that a few years ago have a look at this thread and it should give you most of the answers you are looking for.
http://bytes.com/forum/thread559954-southoz.html
southoz...Leave a comment:
-
Good ay ,
tell us exactly what you are trying to do - eg: why are u trying to use sendkeys and we maybe able help with a clearer understanding
southozLeave a comment:
-
Good ay
Try something like MyStr = Format(MyDate, "dddd, mmm d ") ' = "Wednesday, ' Jan 27 ".
it's just a simple matter of date format
southozLeave a comment:
-
Good ay UAlbanyMBA
well straight from the manual & vb help files
Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
Here, upperbound is the highest number in the range, and lowerbound is the lowest number in the range.
Before calling Rnd, use the Randomize statement without an argument to initialize the random-number generator with a seed based on the system timer.
have fun
southo...Leave a comment:
-
Good ay Ron B
I have posted the code to this forum follow this link http://www.thescripts.com/forum/thread559954.html
I also have the fall demo database on my site http://members.dodo.com.au/gjevers/gregw.zip
hope this helps
southozLeave a comment:
-
Good ay junchan
Have a module ask for a valid email address on first startup and using a yes/no (true/false) field in table to validate that this has been done , from there the first intance the program is run you can use the Now function to get the time and date which is then also put into the table then calculate 30+ days as secondary date field , then every time the program is run the module can check to see if the date has passed...Leave a comment:
-
Good ay BrianHIckman ,
I would do as mmccarthy has suggested , if that fails then I would take a look at your anti virus or adware programs as many of these products will automaticly disable or even delete activex and vba scripts if they think that those programs are a security risk , hopefully this may not be the case but do keep it in mind.
southozLeave a comment:
-
Good ay Grissom,
first of all no matter what you do you will need to learn how to program , access uses many vba subroutines (visual basic) and it doesnt matter what modern programming language you use they mostly use the same type of visual interface for forms(VB , VC ,Delphi ) and so on. For a beginer access is fairly easy to start with but you will have to get some fundermentals of the language.
secondly for access...Leave a comment:
-
My thoughts exactly Killer42 , sounds a lot like MDE to me but could be a few other things
southozLeave a comment:
-
Good ay Imthiyaz ,
it may help a bit if you let us know what format the database is , what code or call is being used to try to open then and if anyone has put a lock on the database and if so why?
southozLeave a comment:
-
How to send query to formated word document
Good ay all ,
I'm fairly new to access(a little over 5 weeks now). Since I'v started I have picked up a lot of useful information from forums such as this and in doing so will share that information with others. I have seen many request for information on mail merging an how to send data to word documents this is something I have put together with the answers given by others and I hope this will help a few newbies , I know there are easier... -
check your PM's for an answer
southozLeave a comment:
-
have a close look at the northwind data base example that comes with access , then go through the access 2003 (or what version u have) visual basic ref help file to cross reference the calls an routines used.
southozLeave a comment:
-
Good ay ,
try using the len function to get the length of the string then use a repeating instr function to find all the spaces in the string, that would give u a proper word count
southozLeave a comment:
-
OOPS SORRY ABOUT THAT, was thinking of something else . AS far as I know U can not have a command button on a report close the report I may be wrong but as far as the DoCmd.Maximize will help u
southozLeave a comment:
-
Good ay ,
use the command DoCmd.Maximize directly after the command that opens your report, as for closing as far as i know u can still put a command button on the report and set it's on_click subroutine to close the report eg: docmd.close
southozLeave a comment:
-
southoz replied to This thread will be deleted go to http://www.thescripts.com/forum/thread557037.htmlin Accessif your looking to find both fields in the query try to add the AND statement at the end (after your WHERE field=data)
so it goes WHERE [table.cause] = data AND [table.cause]=data2
hope it helps
southozLeave a comment:
-
southoz replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessGood ay ,
not sure if this is what u mean but it may help
i have a few fields on a form and a query for statements an invoices , on clicking a command button it open an invisible form that runs a query connected to a listbox
SELECT DISTINCT statement.Order Number,statemen t.clientname,st atement.pickupd ate,statement.s ubprice,stateme nt.orderweek FROM statement WHERE [statement.order week] = Forms![Orders1]![orderweek]...Leave a comment:
No activity results to display
Leave a comment: