Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 44
Search took 0.03 seconds.
Search: Posts Made By: rgwfly
Forum: Forms 08-21-2018, 06:25 AM
Replies: 1
Views: 190
Posted By rgwfly
Make table prior to form loading.

OK was not sure if this is the best place to post this. I had another thread where I wanted to concatenate records together on a query and form. I used Allen Browne's method mentioned. ...
Forum: Queries 08-14-2018, 07:39 AM
Replies: 8
Views: 192
Posted By rgwfly
Re: Songle row one to many

OK seems to work in a independent query.
I am using this for a form with a text box search. I noticed the form slowed significantly using Allen Brownes VBA.
If I create a table and run the query...
Forum: Queries 08-08-2018, 09:46 AM
Replies: 8
Views: 192
Posted By rgwfly
Re: Songle row one to many

Edit:
OK I think I have it, there was a null field in the underlying table. I added a where clause and it runs without the error. Funny in the original table I don't see the null value. :o
Forum: Queries 08-08-2018, 09:20 AM
Replies: 8
Views: 192
Posted By rgwfly
Re: Songle row one to many

Still get the error.
Something in my group by. if I remove it runs OK.
Forum: Queries 08-08-2018, 07:23 AM
Replies: 8
Views: 192
Posted By rgwfly
Re: Songle row one to many

OK, I did use the code from Allen Browne above.
I used in a SQL query as mentioned using



I keep getting a Error "Syntax error (missing operator) in query expression".
However it does run....
Forum: Queries 08-06-2018, 11:42 AM
Replies: 8
Views: 192
Posted By rgwfly
Songle row one to many

Hello,
I have two tables in a one to many relationship.
tbl_Test & tbl_tech
I may have several Tech's working on one test.
I was trying to get a query where I have one record from tbl_Test
with...
Forum: Forms 07-30-2018, 07:22 AM
Replies: 6
Views: 144
Posted By rgwfly
Re: Only One checkbox Allowed

Yes I did. This puts different values (1,2,3) on each option instead of a true false.
I should have used this on initial design.
Forum: Forms 07-30-2018, 07:05 AM
Replies: 6
Views: 144
Posted By rgwfly
Only One checkbox Allowed

I searched and sure the answer is there. I have a sub-form with multiple
checkboxes. Would like to select one and only one.
I know I can set the on OnClick event to clear the others. I was curious...
Forum: Tables 06-15-2018, 06:32 AM
Replies: 12
Views: 359
Posted By rgwfly
Re: Easiest way to get Excel table into Access

If you use the wizard just be careful in your data types. I usually use text type for everything except where calculations need to be performed. More than once I had to redo it because I imported one...
Forum: Tables 06-15-2018, 03:49 AM
Replies: 12
Views: 359
Posted By rgwfly
Re: Easiest way to get Excel table into Access

I usually export the SAP data into a text file and then link to the database. I found sometimes the excel export from SAP caused errors. Then you can just overwrite the same file when you do future...
Forum: Reports 02-02-2018, 10:42 AM
Replies: 9
Views: 462
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: 462
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: 462
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: 924
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: 924
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: 924
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: 547
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: 319
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: 319
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: 319
Posted By rgwfly
Re: Remove typover Block from Txt

Still getting the block.
Forum: Forms 11-20-2017, 08:52 AM
Replies: 8
Views: 319
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: 319
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: 243
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: 243
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: 507
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. ...
Showing results 1 to 25 of 44

 
Forum Jump



All times are GMT -8. The time now is 02:30 PM.


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