Search results for query: *

Read the post, and now I'm really interested as well. Any updates ? Phil

Hi there, please find below a q&d way of doing this (not for purists I know, but I'm not to clever with arrays et al.) Create a form for the table you are spell checking, set up a for/next loop (number of records in table) use your code followed by a goto next record command. let me know if...

Hey elwood, I'm not sure how friendl or stable it is but the developer version of office, allows you to bundle dbs you create with the runtime components of access. You may find peoples' experience of the runtime highlighted in questions on this site. Regards Phil.

Hi all, Having a little trouble on one machine with an issue which doesnt arise on others. I have a report which I want to (using VBA) e-mail directly after editing the message text. Works fine on one machine, but on another, the Email edit window opens up with the report file attached, and a...

in the field properties set "input mask" under the data tab to Password. The all you should see are **********'s

In the form (format) properties you can set the folowing properties: MinMax Buttons (None) Close Button (No) Your user will then not be able to minimise or close your form. You can also disable their ability to use the mouse right click (which would enable form design and thus their ability...

Alternatively scripting which read: if isnull(me.myfield) or me.myfield = "" then me.myfield.visible = false endif

i) create a table with a "ticketno" and "flag" field (tbl_MissTickets) ii)create a for next loop to populate it with a sequence of numbers 200k to 215k ie ************* For x = 200000 to 215000 MySQL ="INSERT INTO tbl_MissTickets ( ticketno ) " & _ "SELECT " & x & " AS ticketNO;"...

Hi Guys & Gals, I have just bought an external hard-drive, initially as a back-up device, but now want to use it as my main data store, and back up to one of the pcs that I use it on. Before I start what I imagine (with my limited capabilities) will be a mammoth task, I just thought I'd ask...

DONE IT!!!!!!! If you open up the report in edit mode you can make the changes discussed. As mentioned I am using an array to store the different elements but you can still get the gist (apologies for appalling code - not finished yet) for ctr = 1 to x DoCmd.OpenReport "testrep", acViewDesign...

Ramon, I wouldn't have thought that your application needed to be web-based if all you wish to do is send out e-mails at a given event. Utilising the on timer event(as above), you could run a query everyday, which identified those tenants whose rent was about to expire. Then utiilsing the...

Thanks once again pdldavis. It didn't occur to me that the error was related to the particular charttype that I'd used, doh. I left this alone for a week, and now have to gety back on it, so the other thing I was thinking of doing (yesterday actually) was creating three reports (each one...

Thanks for the tip pdldavis, though I'm not having much fun getting it to work, what version of Access are you using? I am using 2002, and if I try to use the line of code: me.chart0.ChartType = xlbarclustered I get a type mismatch error. I had seem someone else using ...

Unfortunately this thread didn't help. When I try to store the charttype in an array, the value of the array element remains null. Any further thoughts would be greatly appreciated.

Hi Tom, You could have a form hiding in the background, and within it use the ontimer event to trigger your e-mail. if you need the coding to send the e-mail, let me know. Obviously the application would have to be on continuously on the pc sending the e-mails. Regards Phil

Many thanks for the steer KR Phil.

Hi, I have written a data visualisation tool which lets the user, see data displayed graphically utilising a number of parameters. I have been asked to provide a facility whereby the user can create there own report, and print out a number of the paramatised graphs at once. What I was...

Hi guys, thanks for the response, unfortunately I haven't been able to get hold of the machine to test your suggestions, but will let you know how I get on. Ta Phil

Hi all, I have an application running stand alone on four separate machines to cpature research data. The main capture form (unbound) captures all details regarding the subject matter and then a button opens an append query which transafers all the captured data to a table. On 3 of the...

hi kaya, A simple dos batch file may be suitable If so create a file setup.bat containing the following text md c:\MyAppFolder copy MyApp.mdb c:\MyAppFolder\*.* del MyApp.mdb Just get users to copy both files (your App & the batch file) in to the same folder and double click on the batch...