Search results

Hi, I looked at your project history and felt that this is something I would like to support. So I would like to help you get started with your database!~)

Do you have the mda file and/or do you know what functionality it holds? You probably have to remove the reference in vba and build the function yourself. You can try and upload the database here if it's less than 2mb otherwise you could upload it somewhere else and "write" the link here (you...

...or get somebody to remote to your pc... How big is the db can't you upload and share it on a drive in the cloud somewhere?

This should be right: SELECT [Food Fact Sheets].[Title] & " " & [Food Fact Sheets].[Next review due] as NewColumn, [Food Fact Sheets].[Title], [Food Fact Sheets].[Next review due] FROM [Food Fact Sheets];

SELECT [Food Fact Sheets].[Title] & " " & [Food Fact Sheets].[Next review due] as NewColumn, [Food Fact Sheets].[Title], [Food Fact Sheets].[Next review due] FROM [Food Fact Sheets]; Bound Column 3 column count 3 and column widths: 0.01;2;2

When you click on the combobox in question all relevant code is showed in the box on the right!~) The trick to that specific combo is to have a field in your query that combines the 2 columns. Then you set the column width to a very small number. Access doesn't show columns in the dropdown if...

Is it possible for you to upload the accdb file?~)

When you use the concatenate module you need to add all the levels to the where clause in the call!~) I believe in this instance you only got job number, you need to add seq.

If you upload an example spreadsheet I will have a look and try and give you some recommendations and maybe even a datastructure!~)

It only shows the first column that's not 0 in width. There's different solutions to that. I have made a db with examples of various uses of comboboxes. Check out the download section!~)

What functionality do you need?~)

Is it possible for you to upload the db?~)

Hi, here's a bit to work on... just to show a quick way of getting up and running. Without any data I can't be sure of your structure or you work flow... If you want to go behind the scenes you need to hold down shift when you open the database.

Just a comment... This is an excellent opportunity to show the difference between data in Excel and data in Access... This is how you would use the data in Excel: Person Year 1 Year 2 Year 3 Person1 a b c Person2 x y z This is how you would do it...

Between Date() and Date() + [Enter days:] You have to use Date() and not Now(). From now is 02/12/2012 21:28:00 (where I am!~) but the date is actually 02/12/2012 00:00:00 so you would miss today in the result!~)

Here's an example that's very simple an keeps all the data in a de-normalized form which I think is the best for this little project!~) ..if you want to do any changes then remember to hold down shift when you open the database.

If you have left the standard naming of the navigation control subforms then: Forms!frmNavigationLeft!NavigationSubform!NavigationSubform!Cnam

You say you have to maintain Milk collection database... does this mean you have a database you could upload? I have developed a lot for the dairy industry, so I would like to see if I can help!~)

Hi, It's hard to know where to start because there's a lot of issues that needs to be sorted for the database to function. You have done lots of work on your db, so for people to help maybe you should present a problem at a time. When one is solved you can go on to the next.

...sorry you need this one: Private Sub Form_Current() Me.cboProducts.Requery End Sub