Search results

Sub prep() On Error GoTo ErrorHandler Dim db As DAO.Database Dim timecards As DAO.Recordset Dim myDate As Variant Dim dated As Date Set db = CurrentDb Set rstprep = db.OpenRecordset("timecards") rstprep.MoveFirst myDate = InputBox("Enter New Week's Saturday Start Date in Format...

I have events coded on the form fields as well as some conditional formatting. After I run VBA code to update records in the related Table and then return to the Form, these controls are not showing. When I go into the properties, the events and conditional stuff is still there, and then after...

I think I am not gonna get this to work perfectly. The best I think I can do is to have the dropdown to always be there - but to not show any values in the dropdown - if field1 not = "Customer" - as was demonstrated for me before by DBguy. Unfortunately, as was the case in the fully...

"If this is continuous view then you cannot hide the combo. You must use conditional formatting to enable/disable it. You can modify the colors as well." YES. It is continuous and I do know how to change colors/shading, but cannot get the code down which will enable/hide the combo -...

Take a BREAK, my man! U have helped me much already in the recent past, and for U to give your time and skills to help others is an awesome thing!

If I have a form based on a table with 2 fields. If field1 = "Customer", then I want field2 to show a dropdown list from another table with 1 field in it, else no dropdown list should apply. Not quite sure best way to approach ?

TOPIC: Re: Conditionally present a Drop down list

"I have an idea. See what happens if you take the file I gave you and bind the dropdown to field2 in your table. What do you see?" This was an improvement as there are no entries appearing in the dropdown on rows where field1 is not = Customer. Best wud be to not even reference a dropdown on...

The dropdown on field2 only applies on rows when the field1 = "Customer"

I appreciate that U have spent much time trying to help me. My hope is that, since this is a worldwide forum, someone else can maybe point me in a helpful direction - aimed directly at my question.

This is not about me knowing anything more about normalization. If it is simply not possible to do/simulate any of the things I have asked about, then so be it! There is no need for anyone to dig any deeper into what my fully comprehensive working Database looks like.

The table is the normalized next step after the compact data entry form. This again is only a temporary "work" file ...

All of the entire Database is all set and normalized, etc. All that is needed is a Data Entry Form which simply emulates the Excel in the format I previewed. I can program the data entry into the normalized and existing Tables from that. Obviously, the normalized table (the next step after...

I am fully aware of that, and that's how it works now (Excel is transferred over to Access Tables). However, I do see advantages to NOT have to have anything "to do" with the Excel side at all - So that's why the search for a "nearly" comparable solution - wholly within Access.

This is what Excel is: .... used for spacing Field1.............Field2........Field3......etc., etc. Rich...............SAT .....................08/06/19 .....................IN.............OUT Customer........Conery-1 Am................700............800 Pm Customer Am Pm etc. etc.

Alas, I guess it is simply not possible to turn on or off a dropdown list in the same column of a form field ON A ROW BY ROW BASIS - based on the value of another field.

That example scared me away cause when I entered data in field2 it appeared the same in every row on the form

I guess I do not see a lot of benefit from creating a form in Datasheet view - rather than just going directly to the table itself for data entry ???

Here is the database

That's where I kinda flamed out, trying to set a conditional format rule, which kinda worked cept cud not get to the 2nd table with the dropdown values in it. Also tried setting a CONTROL SOURCE clause for field2 but did not quite "compute". I guess the issue is figuring how to - "referring...