Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 160
Search took 0.01 seconds.
Search: Posts Made By: rick roberts
Forum: Forms 06-19-2017, 12:47 AM
Replies: 9
Views: 440
Posted By rick roberts
Re: zeroing records

i have a different database that works in the way you suggest using week numbers to add the records but when I reach week 52 (end of year) I have to start again at week 1 so my dilemma still stands
Forum: Forms 05-17-2017, 04:02 AM
Replies: 9
Views: 440
Posted By rick roberts
Re: zeroing records

will this system zero the entries on the following week if not then I have the same problem if they do then I have another problem since there are some static column figures that need to be...
Forum: Forms 05-17-2017, 12:06 AM
Replies: 9
Views: 440
Posted By rick roberts
Re: zeroing records

the data is for work done on different elements for each company they are billed for that particular week and so the data is returned to zero in order to start with a clean slate for the following...
Forum: Forms 05-16-2017, 02:02 AM
Replies: 9
Views: 440
Posted By rick roberts
Re: zeroing records

I have a table with rows of customers the customers have columns of various payments which are populated during the week. when the week is over I want to revert the figures in the columns to zero...
Forum: Forms 05-16-2017, 01:30 AM
Replies: 9
Views: 440
Posted By rick roberts
zeroing records

I have a button that backs up an application with the current date and forwards the existing date by a week this all works fine but I also want to set some records to zero after backup. can anyone...
Forum: Reports 04-28-2012, 01:29 AM
Replies: 4
Views: 1,311
Posted By rick roberts
Re: character spacing

I looked through the list of fonts and am using Copper Plate Light which seems to be the widest but still not wide enough to cover the spacing. I do realise that I can pass the info a character at a...
Forum: Reports 04-27-2012, 01:19 AM
Replies: 4
Views: 1,311
Posted By rick roberts
Re: character spacing

i have no idea what that means :)
Forum: Reports 04-26-2012, 02:08 AM
Replies: 4
Views: 1,311
Posted By rick roberts
character spacing

I am using access to fill in a ready printed form in which letters are placed in existing boxes but these boxes are not the same width as any font I've looked at. Is there any way of making the space...
Forum: Modules & VBA 12-09-2011, 01:54 AM
Replies: 7
Views: 991
Posted By rick roberts
Re: Checking Windows Version

thanks very much for your help in this matter - especially the link - that looks like what i need if i am going to split the code to use either forms of email
thanks again
Forum: Modules & VBA 12-08-2011, 10:33 AM
Replies: 7
Views: 991
Posted By rick roberts
Re: Checking Windows Version

as i explained that procedure doesnt actually send an email it either takes you to the outlook program to send it or it brings up a warning that an application is trying to use outllook either way...
Forum: Modules & VBA 12-08-2011, 07:39 AM
Replies: 7
Views: 991
Posted By rick roberts
Re: Checking Windows Version

im not sure what you mean by - immediate window
i need this to be set as a variable so i can use it in vb
my version comes up as version 12.0 (i was hoping for xp or vista etc.) is there a list...
Forum: Modules & VBA 12-08-2011, 07:15 AM
Replies: 7
Views: 991
Posted By rick roberts
Checking Windows Version

I have a problem with sending email by the app. route in as much that this only works with windows xp. to email with windows 7 or vista i have to use the docmd. option
is there a way of verifying...
Forum: Modules & VBA 10-28-2011, 12:35 AM
Replies: 5
Views: 787
Posted By rick roberts
Re: Emails only send from my computer

it appears to be a windows issue. the email routine works on other machines running windows xp but wont work with windows 7 i have yet to try it on vista
im using office 2007 to create the...
Forum: Modules & VBA 10-26-2011, 11:50 PM
Replies: 5
Views: 787
Posted By rick roberts
Re: Emails only send from my computer

i clicked the option to allow all macros yes and all other buttons work fine
i did find that the path i used to create a temporary .rtf file as an attachment wasnt always available in the other...
Forum: Modules & VBA 10-26-2011, 12:41 AM
Replies: 5
Views: 787
Posted By rick roberts
Re: Emails only send from my computer

ive tried it on 2 different machines and both use outlook
Forum: Modules & VBA 10-25-2011, 05:25 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

ive split the database and all seems good (its a neat trick) now i only have the email issue but have started a new thread so that if a resolution is found it wont be buried here
thanks all
...
Forum: Modules & VBA 10-25-2011, 05:16 AM
Replies: 5
Views: 787
Posted By rick roberts
Emails only send from my computer

i have a program that sends emails at the click of a button - containing text in the - to. subject. body. and an attachment. all works fine until i use this program on another computer. it seems to...
Forum: Modules & VBA 10-20-2011, 01:54 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

ive had a look at a few articles regarding splitting the database but they seem to suggest that the reasoning behind it is to allow multi accessing of the tables which isnt needed in my case but if...
Forum: Modules & VBA 10-20-2011, 01:12 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

im definitely considering putting my head back firmly in the sand lol
this program will eventually just be shared by 2 computers so i imagine that splitting is not necessary? my intention was to...
Forum: Modules & VBA 10-19-2011, 04:17 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

if i understand you correctly - that isnt the case - i have the program on an external drive and use that as the location of the program for all computers- im not dealing with an office network - ive...
Forum: Modules & VBA 10-19-2011, 03:18 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

sorry i dont know what you mean by - split?
Forum: Modules & VBA 10-19-2011, 03:04 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

i havent tried much yet since it only happens on other peopels computers im going to try using my own email to send on another comp and see what happens - i onlly asked in case there was a simple...
Forum: Modules & VBA 10-19-2011, 02:50 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

it gives that momentary message which i can only presume says its outputting the email (it only appears for a split second) and the routine seems to work fine -- except that the email never gets sent...
Forum: Modules & VBA 10-19-2011, 12:57 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

thats done the trick - i changed the code for all the other buttons too - i guess i was being too vague?? thanks very much for your help in this matter - it was becoming very frustrating - thank you...
Forum: Modules & VBA 10-17-2011, 03:22 AM
Replies: 65
Views: 4,360
Posted By rick roberts
Re: Runtime error when i open a form

this is where the error occurs



it only happens if the box is ticked and the message is displayed
if unticked the routine works fine and an email is sent or letter printed
Showing results 1 to 25 of 160

 
Forum Jump



All times are GMT -8. The time now is 01:07 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World