Search results

Thanks very much! :-]

Hope you don't mind if I ask one more question. In enterprise systems its quite common to have various levels of user read/write permissions. And a system having tables that contain critical values such as would be presented in a data-entry forms drop-down list - would perhaps be good...

Excellent! Thanks very much!! :-]

OH I see! So its not the use of a drop-down list that problematic - because this is a recommended solution within the environment of a data entry form. So the there must be something about developing a list via the lookup wizard - that is avoided due to some kind of risk. I can understand...

Thanks very much! Since it is not recommended to use the Lookup Wizard - and since it would at least seem logical that data integrity would be increased by forcing end users to select values from a list rather than manually entering them - (risking differently spelled instances) is there...

Hi All, A lookup in a table for data-entry can be created from a table or a query. In the case the lookup is created from a table, it establishes a relationship link between the two tables. And the lookup-wizard gives the developer the option of selecting referential integrity for that link...

Awesome! Thank you very much!

Thanks, yes - I noticed that is for the tab itself. I was hoping the sheet or body below the tab might have an option for back color. But so far I haven't found it.

Thanks All! I am now experimenting with adding tabs to a form. I'm not finding a way to make the background color of the each tab section like I would normally be able to do in the header/group/detail section of a form. With my forms I typically like to have a grey back ground color and have...

Yup! I went into the options and turned off the Tab-Document option. And then started the DB up again and the form width is now equal to the design setting. Thanks!

AH! I didn't know this. Yes I'm using the default tabbed form.

Ok, I've played with a few parameters that now allow me to change the width parameter. I have to confirm by I think the one that I had to change was AutoResize. So I am able to change the width in the design view. But when I switch to Form View - the form width expands to the complete right...

Hi All, I'm having trouble with changing the width of a form. There is the width parameter and in one case set to 8.1514" When I try to change this number - it reverts back to what it is. Can anyone tell me how to control this parameter? Thanks!

AH! I should have looked there! Yes that's exactly what is going on here. And thanks very much for the best practices page on this also! :)

Hi All, I have a sample db for learning purposes. It has 3 tables. Customer Orders Products The Customer table has a CustomerID field and it also has a "CompanyName" field The Orders table also has a CustomerID field which is used to link to the Customer table. The strange thing is - when I...

Thank very much! I'll check out Steve Bishop - I believe I've seen a couple of his videos. My thanks

Yes! rst.moveNext did work! Thank you very much! Can you recommend a source of information I can use to get more details on this? Also - if I understand another thing you stated - performing ACTION queries like updates to values or inserting values into tables would entail an SQL statement...

Thanks! Lets say I simply want to learn how to pull values from tables into the VBA environment so I can look at them and do things with them. Your example here worked: Debug.Print DCount("VideoName", "tblVideos") It did acquire the correct number. The VBA course material example didn't...

Ok - to back up a little bit - here is the VBA script from my course material on Access 2013 VBA The script opens the db - specific to a specific table and queries two fields from that table - and then returns the results to the immediate window. The course I'm reviewing is in video format and...

Ok here is a query Dim sqlquery As String sqlquery = "SELECT Count(tblVIDEOS.VideoName) AS CountOfVideoName FROM tblVIDEOS;" How would I run this in VBA and see the results in the VB editor immediate window?