Search results

I add a view of the Decision Table in case that helps for this to make sense. And a view of the From in action. The view is already filtered (through the query) for only SQE GK.

Maybe so. It would be the next one in numeric order so I thought it would be easy enough to get that mathematically, Current mmr_num +1. I actually changed mrr_num from a text value to a number in case I needed to do that. I may try that later. Thank You

I had tried that code and it did work as well as what I have now, and it shorter so that's usually good. Sorry my explanation is probably not using the correct syntax in all case. Let me try again. As a tab format I see several records on screen at once. I want to go down the list and...

Option Compare Database Private Sub Combo34_Change() ' Try to set Decision Date and Close date when control is updated ' So far no luck. doesn't update the correct record Dim rs As DAO.Recordset ' If Decision < 7 then ... Else... New code to get back to Record after Requery PK =...

I want to use a Tabular for to go down a list of 'records' which the user may take action or not. There is a cbo field Decision on the form. The user makes a choice which is recorded. There are two of the five choices which means the 'record' should be removed from the form view. Those...

yes some sort of security loop. or maybe something else but 'Linking...' stays until I choose 'NewRank as Unique Identiier . As soon as I do that I get the table with the single field consisting of NewRank which is not a useful field and is NOT unique to each record. About 98% of records have...

making some progress. I make new connection. I get "you are logged on with non-Admin privleges. System DSNs could not be created or modified. Then click OK and new window. Select type. Only avail is User Data Source, System Data source is greyed out. Click Next. Choose driver. I...

OK so after just a quick look I may need some help to do that. In excel I can choose 'From other sources' then 'from sequel server'. When I go to Access external data there are several choices but I can't tell which would work. I see ODBC, data services and dBase files. there are others such...

Thank You The instructions to use the SQL connection were to pipe it to Excel. Our IT knits their brow quite furiously if they think one of us (non IT) are using Access in a way that threatens their purvey over everything informational. There is literally a policy which says I can't write an...

I am working on a database that can pull data from a SQL server. The avenue that I have available is to use Excel's data connection function. I then create a linked table in Access which is linked to the aforementioned Excel with the data connection. I made a combo on a form that pulls from...

So basically just use code to recreate the work that ColumnHistory does so I can have it to exactly what I want. It is as I imagined. Thanks to all.

I am familiar with ColumnHistory and have used it successfully. I really like it, especially the time date stamp that goes along with it. Is there any way to add information to that time date stamp. I already have a table which holds a text value representing the Current User. In fact I...

isladogs Love the simplicity. I thought I was way overthinking it. so rather than SetProperty, I just call Me.controlname.property = True or False? And the value of togglecontrol is already true or false so that can be the expression after the '='. Now on to other improvements.

Private Sub Toggle36_Click() Dim Toggle As Boolean If Toggle = False Then Toggle = True Else: Toggle = True End If If Toggle = True Then DoCmd.SelectObject acForm, CboSQEPicker DoCmd.SetProperty CboSQEPicker, acPropertyVisible, 0 Else...

Went with Pbaldy suggestion. I'm new to login process in general but I think I need to use a table to store passwords, etc. Haven't tried having each user have a copy of 'front' on their own computer but I will after I get a few more wrinkles straightened on this current improvement project...

I have a CurrentUser table. Only function is to hold the username of the person currently 'logged on' This is set by a 'log in' form from which the user selects their name. This is very basic login process. Later I want to add a password control and use the username to control access to...

DBguy: Being new to the blog/forum concept, am I supposed to do something to close out the discussion at this point?

DBguy Seems to work perfectly now. I'll test a bit to make sure but Thank You very much.

JHB: yes, I figured that out later yesterday evening. I use a open form macro command with a where clause that is based on a control on a previous form to get to the record I want. Is there a way I can still do that but then have the form 'recognize' all the records like it does when the form...

Isla Dogs. point somewhat missed in that I am looking for a different form behavior. The db had been faithfully showing the duplicate value message. Before that I had tried setting RefNum as the PK. The code has evolved since then but I first made RefNum the PK, even before the code to show...