Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 34
Search took 0.01 seconds.
Search: Posts Made By: rgwfly
Forum: Reports 02-02-2018, 10:42 AM
Replies: 9
Views: 368
Posted By rgwfly
Thumbs up Re: Outputs, Reports, KPI's stc.

That really pretty good ridders. I would like to learn how you did that.
Forum: Reports 01-29-2018, 10:15 AM
Replies: 9
Views: 368
Posted By rgwfly
Re: Outputs, Reports, KPI's stc.

Yes the reports in access are fine. However for KPI's I need to have lots of pretty charts (snicker). Excel seems to be the only method for providing this format.
Forum: Reports 01-29-2018, 08:04 AM
Replies: 9
Views: 368
Posted By rgwfly
Outputs, Reports, KPI's stc.

Hello experts. Apologize in advance if this is the wrong place to ask. I am just looking for the advice on reporting protocol. Excel does a great job but normally I have to export, update, email. ...
Forum: Tables 01-24-2018, 07:14 AM
Replies: 15
Views: 730
Posted By rgwfly
Re: Medium Time Input Mask

I believe so it was using direct table entry and not a form. I did try all the formats mentioned above. What's funny is I created a new field and deleted the old field. when I tried to rename the...
Forum: Tables 01-22-2018, 06:17 AM
Replies: 15
Views: 730
Posted By rgwfly
Re: Medium Time Input Mask

Sorry I was offline for much of the discussion. I ended up creating a new field and used the input mask given by Mark60 and it works perfect.
I tried it in the original field and it fails. Also...
Forum: Tables 01-19-2018, 10:41 AM
Replies: 15
Views: 730
Posted By rgwfly
Medium Time Input Mask

Hello experts. I inherited a problem in a database that tracks safety incidents. User inputs data from a form that is handed in. the issue is with the medium time format.
Table consist of, ...
Forum: General 11-22-2017, 05:52 AM
Replies: 5
Views: 461
Posted By rgwfly
Thumbs up Thanks to all you experts

I just wanted to thank all you for help with this forum.
I have really learned a lot from here.
All of those retired and current developers who take time out to share their knowledge.
I hope...
Forum: Forms 11-20-2017, 12:18 PM
Replies: 8
Views: 244
Posted By rgwfly
Smile Re: Remove typover Block from Txt

Works perfect. That's good info to know. I can even skip the query.
Forum: Forms 11-20-2017, 11:32 AM
Replies: 8
Views: 244
Posted By rgwfly
Re: Remove typover Block from Txt

As a label it is not a set value.
It looks up the highest number in a query.
Forum: Forms 11-20-2017, 10:26 AM
Replies: 8
Views: 244
Posted By rgwfly
Re: Remove typover Block from Txt

Still getting the block.
Forum: Forms 11-20-2017, 08:52 AM
Replies: 8
Views: 244
Posted By rgwfly
Re: Remove typover Block from Txt

I tried the recalculate it did not work. I guess I failed to mention it the counter is on another form which pops up for a few seconds.

...
Forum: Forms 11-20-2017, 08:27 AM
Replies: 8
Views: 244
Posted By rgwfly
Remove typover Block from Txt

I have a counter that pops up in a user form. the text box is blocked out like waiting for input. I just need it to display the count number itself without the block. I tried switching edit to no and...
Forum: Modules & VBA 08-11-2017, 07:12 AM
Replies: 3
Views: 215
Posted By rgwfly
Re: Access to outlook body questions.

Thanks Minty,
I actually did run into the null field error. I fixed it in the query to not be null.
But your suggestion is much better.
So the field would look like:
'rec(nz("planHrs","")'?...
Forum: Modules & VBA 08-11-2017, 06:44 AM
Replies: 3
Views: 215
Posted By rgwfly
Access to outlook body questions.

After searching I finally came up with a script to put table information in the body of an outlook email. I have a few questions to enhance this.
1, The last field aRow(8) needs to have a percent...
Forum: Queries 07-07-2017, 11:41 AM
Replies: 4
Views: 468
Posted By rgwfly
Re: Select all records after first meets criteria

OK Doc that works perfectly Almost.
When I run it with the two elements the order by pulls from the first "R" which is perfect.
Now I would like to add a third element and group them by names. ...
Forum: Forms 06-26-2017, 07:31 AM
Replies: 2
Views: 292
Posted By rgwfly
MsgBox Twice

I looked online and tried several different options.

I am looking to have a message pop up when an entry is not completed.
The following code seems to work well but I keep getting the message...
Forum: Queries 06-09-2017, 05:13 AM
Replies: 4
Views: 468
Posted By rgwfly
Re: Select all records after first meets criteria

Plog,
although the above did no pull from the first "F" occurrence; it did pull all the records where there was an occurrence. This is definitely a start. Thank You
Forum: Queries 06-08-2017, 09:16 AM
Replies: 4
Views: 468
Posted By rgwfly
Select all records after first meets criteria

Looking for a query suggestion or SQL where I would pull the first record that contains a certain value and then return all the records after that. I hope this makes sense.
for instance
ID Pass...
Forum: General 04-14-2017, 10:29 AM
Replies: 4
Views: 431
Posted By rgwfly
Re: Testing records

Exactly what I don't want.
I was thinking of using a form to write Drawing & Location to the table (tbltest). in essence to create the test record.
I would somehow need to prevent it from being...
Forum: General 04-14-2017, 09:11 AM
Replies: 4
Views: 431
Posted By rgwfly
Re: Testing records

The location is what I am ultimately testing, however there may be the same location on multiple drawings.
the drawing & location are unique and should only have one record.
Not sure about second...
Forum: General 04-14-2017, 07:47 AM
Replies: 4
Views: 431
Posted By rgwfly
Testing records

I was hoping to get some help with this design. It seems so simple but can't get my head wrapped around.
design scope:

User 1 enters drawing(one) and location's(many)


User 2 finds the...
Forum: Modules & VBA 04-04-2017, 07:18 AM
Replies: 3
Views: 206
Posted By rgwfly
Re: Help with VBA framwork

Thanks for your reply plog,

The test records represent three scenarios of how any single technician may fair each result. I hope this makes more sense.

Yes I already have an Access database...
Forum: Modules & VBA 04-04-2017, 05:29 AM
Replies: 3
Views: 206
Posted By rgwfly
Help with VBA framwork

hello,
I am hoping someone could help with a solution or guidance.
I am framing a test report that records testing for each project and the technician who works on it. the have to maintain a...
Forum: Modules & VBA 12-28-2016, 07:10 AM
Replies: 1
Views: 402
Posted By rgwfly
Another Northwind 2010 question

HI,
I have been trying to modify the NW database to use as a simple inventory program.
Downloaded the 2010 Client version from this site.
Essentially I would like to turn off the shipping (or...
Forum: Theory and practice of database design 11-08-2016, 05:23 AM
Replies: 9
Views: 1,607
Posted By rgwfly
Re: Database assignment design.

Thanks Doc for your perspective.
This project is definitely unique in its structure. I was always used to being able to quantify information and translating it to database design. I have been...
Showing results 1 to 25 of 34

 
Forum Jump



All times are GMT -8. The time now is 02:45 AM.


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

Sponsored Links

How to advertise

Media Kit


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