Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.04 seconds.
Search: Posts Made By: burrina
Forum: The Watercooler 07-21-2015, 09:02 AM
Replies: 28
Views: 2,026
Posted By burrina
Resign from Site!

I have given more to this site than I have received so I leave with no regrets. I do thank all who have assisted me in my posts! I'm afraid it is time for me to part ways.

This will be my final...
Forum: The Watercooler 07-21-2015, 08:05 AM
Replies: 44
Views: 3,279
Posted By burrina
Re: Continuing Adventures of Pepper

Again another rude comment. Pepper is my Blue Front Amazon (that means he is a bird) UK translation for you. I explained in ENGLISH that he made a poo poo and that when I tried to clean it up what he...
Forum: The Watercooler 07-21-2015, 07:49 AM
Replies: 44
Views: 3,279
Posted By burrina
Re: Continuing Adventures of Pepper

If you don't have anything good to say, keep your mouth shut!
I don't appreciate it .
Forum: Reports 07-20-2015, 12:27 PM
Replies: 2
Views: 465
Posted By burrina
Re: Emailing Specialized Report to Multiple Recipients

Take a look at this thread. http://www.access-programmers.co.uk/forums/showthread.php?t=185611
Forum: The Watercooler 07-20-2015, 10:55 AM
Replies: 19
Views: 1,955
Posted By burrina
Re: Post your Tip Of The Day - Advice to learn and live by

Don't Mess With Texas ! Have yourself a Rock Mountain High is not an acceptable term in Texas.
Forum: General 07-19-2015, 01:49 PM
Replies: 2
Views: 580
Posted By burrina
Re: Employees work schadule

You might give this a look and see if it fits your needs,

http://www.databaseanswers.org/data_models/employees_schedules/index.htm
Forum: Modules & VBA 07-19-2015, 09:51 AM
Replies: 16
Views: 15,720
Posted By burrina
Re: How to update/requery a form from another form?

i did not look at the screenshot or the db!


:rolleyes:
Forum: Modules & VBA 07-19-2015, 09:40 AM
Replies: 16
Views: 15,720
Posted By burrina
Re: How to update/requery a form from another form?

Example: form a to form b:
Forms!YourFormNameHere.Requery
Forum: Forms 07-19-2015, 09:37 AM
Replies: 21
Views: 1,450
Posted By burrina
Re: Prevent Cut functionality within Unbound Combobox

I concur with vbaInet, I have personally seen the cpu outrun other functions many times.Bug, maybe, but a pause would not hurt to test!
Forum: General 07-19-2015, 02:53 AM
Replies: 3
Views: 683
Posted By burrina
Wink Is it Just Me ?

I seem to do my best work when I am dead tired, Go figure :confused:

Something to do with old age ? :eek:

Only 2 things left to do on the database I have been working on.
Famous Last Words Go...
Forum: The Watercooler 07-18-2015, 12:47 PM
Replies: 44
Views: 3,279
Posted By burrina
Talking Continuing Adventures of Pepper

Pepper is my Blue Front Amazon.
I went to clean up his business (Pepper's) and he say's , I already cleaned it.

Even for me, I was taken back. Amazingly smart.:)
Forum: Theory and practice of database design 07-18-2015, 12:43 PM
Replies: 9
Views: 1,294
Posted By burrina
Re: When is a Database Finished. Where do I stop.

Rain, I was thoroughly entertained, Thanks for the memories.

P.S.
Short Answer: NEVER
Forum: Modules & VBA 07-18-2015, 12:31 PM
Replies: 12
Views: 687
Posted By burrina
Re: Image in output to Word Document

I believe your solution is:
1. Export to pdf
2. Do a mail merge
Forum: General 07-18-2015, 07:09 AM
Replies: 3
Question printing a form
Views: 457
Posted By burrina
Re: printing a form

Why? It can be done but why not a a Report?



'Print Single Record on Form.
Dim myForm As Form
Dim PageNo As Integer

PageNo = Me.CurrentRecord
Set myForm = Screen.ActiveForm
Forum: Modules & VBA 07-18-2015, 07:03 AM
Replies: 12
Views: 687
Posted By burrina
Re: Image in output to Word Document

Are you trying to automate this or simply put the same bmp file in word as in access?
If the latter, then manually copy and paste.

P.S. Here is a link that may suit your needs.
...
Forum: Modules & VBA 07-18-2015, 05:07 AM
Replies: 8
Views: 897
Posted By burrina
Re: Update doesn't work everytime?

As an alternate you could try:

If MyRecordset.RecordCount > 0 Then
MyRecordset.MoveLast: MyRecordset.MoveFirst 'Traverse the Recordset
Debug.Print MyRecordset.RecordCount
End If
Forum: Reports 07-17-2015, 09:55 AM
Replies: 8
Views: 830
Posted By burrina
Re: Quarterly Reports

I am looking to have a Single Report show the 1st Quarter,2nd Quarter,3rd Quarter,4th Quarter.

This will give me the current quarter.

CurQtr: Format([WorkDate],"q/yyyy")
Forum: Reports 07-17-2015, 08:20 AM
Replies: 8
Views: 830
Posted By burrina
Re: Quarterly Reports

I don't want to hard code it but instead allow it to calculate correctly.
The command buttons set the BeginDate and EndDate and then the query the report is based on uses it as the criteria.
Forum: Reports 07-17-2015, 07:55 AM
Replies: 8
Views: 830
Posted By burrina
Quarterly Reports

'1st Quarterly Report.
BeginDate = DateSerial(Year(Date), Int((Month(Date) - 1) / 3) * 3 + 1, 1)
EndDate = DateSerial(Year(Date), Int((Month(Date) - 1) / 3) * 3 + 4, 0)
Forum: Reports 07-16-2015, 07:32 PM
Replies: 4
Views: 879
Posted By burrina
Re: Character limit for a field in the report

You can set the limit via code. Example: Validation Rule =Len("Specification")<1000
Forum: Reports 07-16-2015, 06:14 PM
Replies: 6
Views: 637
Posted By burrina
Re: end of month reports automated?

That's not the way to do it! You would have to keep repeating this every time.
Example:
FirstDayInMonth = DateSerial(Year(Date), Month(Date), 1)


Last day of the current month:...
Forum: Reports 07-16-2015, 05:29 PM
Replies: 6
Views: 637
Posted By burrina
Re: end of month reports automated?

You will need code for this. Take a look here. https://msdn.microsoft.com/en-us/library/office/Hh134613(v=Office.14).aspx
Forum: Reports 07-16-2015, 05:12 PM
Replies: 6
Views: 637
Posted By burrina
Re: end of month reports automated?

Lot's of variables there. What if the db is not open when it's time?
What email client are you using?
Forum: Queries 07-16-2015, 04:39 PM
Replies: 2
Views: 551
Posted By burrina
Re: query for Inserting random records into temporary table

I'm not sure I understand it? Are you trying to use the open query to add data to another table or are you using a sql statement? Or are you using command button to run this?
Forum: The Watercooler 07-16-2015, 10:20 AM
Replies: 19
Views: 1,955
Posted By burrina
Re: Post your Tip Of The Day - Advice to learn and live by

At the end of the day, all you have is the remembrance of your deeds. Do your best to try and make a good name.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 04:44 PM.


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