Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 112
Search took 0.02 seconds.
Search: Posts Made By: dmyoungsal
Forum: Forms 05-24-2018, 11:00 AM
Replies: 6
Views: 264
Posted By dmyoungsal
Re: whats wrong with this Distinct

From another forum, it was suggested that I only use
SELECT DISTINCT qryPurchaseInfoNew.TracModel. When I do that, nothing appears in the combo box.

If I remove ID from the Select Statement, then...
Forum: Forms 05-24-2018, 10:55 AM
Replies: 6
Views: 264
Posted By dmyoungsal
Re: whats wrong with this Distinct

Some of the models say 6230, will show three times. I want the combo boxt show 6230 only one time.
Forum: Forms 05-24-2018, 10:16 AM
Replies: 6
Views: 264
Posted By dmyoungsal
whats wrong with this Distinct

I am reworking a DB to simplify maintenance for salesman if/when I leave this company. The intent is to consolidate three tables into one flat file (which will work just fine).

However, I still...
Forum: General 05-21-2018, 12:18 PM
Replies: 1
Views: 936
Posted By dmyoungsal
Rework Form

I have decided to re-make a table and at the same time, remake the form.

On the form, I will have three fields that will effectively help drill down to get the right data.

Brand (John Deere,...
Forum: General 05-15-2018, 03:41 PM
Replies: 5
Views: 1,278
Posted By dmyoungsal
Re: Incosistent State

what would happen if I made a copy of the FE for each user on the network so the effect is each user is running their own copy.
Forum: General 05-15-2018, 03:18 PM
Replies: 5
Views: 1,278
Posted By dmyoungsal
Incosistent State

I have a database that we have been using for about three years. The DB consists of a front-end and a back-end. I have about 30 users that share the front end using a shortcut. (Again, this has...
Forum: Forms 01-18-2018, 01:55 PM
Replies: 14
Views: 512
Posted By dmyoungsal
Re: Refresh record and screen

scroll up the thread and find my Jan 16 post:

Look for "Public Sub Form_Current()"

Its all the lines between that and ends and the first "End Sub"
Forum: Forms 01-18-2018, 01:38 PM
Replies: 4
Views: 360
Posted By dmyoungsal
combo Box filtering

I have a form that is used I to display tractor purchase price information. To get to the particular tractor I want to look at, I have three combo boxes that help me find the tractor I want.

The...
Forum: Forms 01-18-2018, 01:21 PM
Replies: 14
Views: 512
Posted By dmyoungsal
Re: Refresh record and screen

I got my problem solved. After searching other resources someone mentioned calling the sub routine that performed the desired action and then repaint.

so the resulting code in AfterUpdate was:...
Forum: Forms 01-16-2018, 04:10 PM
Replies: 14
Views: 512
Posted By dmyoungsal
Re: Refresh record and screen

here is my Sub Form programming where fields are checked and colors changed in the fields I use when the new record is displayed

the last four lines are the AfterUPdate for the specific combo...
Forum: Forms 01-16-2018, 03:32 PM
Replies: 14
Views: 512
Posted By dmyoungsal
Re: Refresh record and screen

I have tried the "Me....." suggestions and nothing seems to work.

Perhaps this tidbit will help. If I make the change to the field, change to a new record and then back to the record I change,...
Forum: Forms 01-16-2018, 02:28 PM
Replies: 14
Views: 512
Posted By dmyoungsal
Re: Refresh record and screen

I have been putting this in OnChange
Forum: Forms 01-15-2018, 04:55 PM
Replies: 14
Views: 512
Posted By dmyoungsal
Re: Refresh record and screen

I used me.Recalc and the screen did not refresh.
Forum: Forms 01-15-2018, 04:16 PM
Replies: 14
Views: 512
Posted By dmyoungsal
Refresh record and screen

I have a combo field that, when changed will update the background color on itself and two other fields. The issue is that the colors dont change until I have gone to another record and then come...
Forum: Tables 01-08-2018, 02:58 PM
Replies: 2
Views: 518
Posted By dmyoungsal
Split tables

I have a split DB that I want need to copy and use in a different manner.

The new use will be putting a version of the DB on indvidual laptops (sales) so they can use a price tool program. This...
Forum: Forms 02-16-2017, 08:58 AM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Re: Pulling a username

Just to give a final update, below is the code I found on this site from a post dated a few years ago. I placed the code in one of the modules loaded upon startup.

Public Function getWinUser() As...
Forum: Forms 02-14-2017, 01:09 PM
Replies: 2
Views: 11,072
Posted By dmyoungsal
Re: Setting default value of textbox to Environ("username") not working

This thread is old, but it solved my problem! Thank you
Forum: Forms 02-09-2017, 08:38 AM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Re: Pulling a username

Ted.Martin

Can you share how you are getting the Environ variable to work?
Forum: Forms 02-06-2017, 10:32 AM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Re: Pulling a username

so, what am I doing wrong? As I said, I have tried it numerous times with no luck

Just to reiterate, I am using an unbound text box and under "control source" i have entered =environ("UserName")...
Forum: Forms 02-06-2017, 08:26 AM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Re: Pulling a username

I have stored the LoginID into the table that is the basis for the login form and the name is still there even though the login form has closed.

I made the Default Value of the Textbox...
Forum: Forms 02-06-2017, 08:20 AM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Re: Pulling a username

I have tried that and nothing happens. Apparently it is because I am using Access 2013 and the Environ stopped working as early as Access 2007 (or 2010).
Forum: Forms 02-03-2017, 03:51 PM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Re: Pulling a username

This is what I have done so far.

I have my tblImagePath with a field LoginID

After I login to my DB and login, I open the table and see the username in the field.

I go to my form and put in...
Forum: Forms 02-03-2017, 01:07 PM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Re: Pulling a username

In my current process, when the user opens the database, they are presented with a login screen, from which they select their name. This login determines which menu they will see while using the...
Forum: Forms 02-03-2017, 11:26 AM
Replies: 14
Views: 1,065
Posted By dmyoungsal
Pulling a username

I have partially figured out how to record a username into a table used during logging into the database.

I now want to get the contents of that field (LoginID) from the table (tblImagePath) in a...
Forum: Queries 01-20-2017, 08:09 AM
Replies: 17
Views: 525
Posted By dmyoungsal
Re: Query Filter

Good News!

I came in early this morning and reformatted the DateTime field to NOT be a text field.

I then went back to my query and entered ">DateAdd("h",-1,Now())". I ran the query and got...
Showing results 1 to 25 of 112

 
Forum Jump



All times are GMT -8. The time now is 06:42 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