Search results

Hi There, I have a documentation control system that I wrote in Access many years ago for my company. It has always workd very well, with a table populated with hyperlinks to a server drive that opens the documents when the user clicks on the button in the forms views. Today I have had a user...

sorry, don't need gotocontrol , just use REQUERY and put the name of your subform as it appears on your form, not it's actual name i.e. right click on the subform in your form's design and look at the name it's called, then use this

sorry - I can do most things with databases, but never learned VB so I do it using macros, hopefully someone else out there can help with the VB code !! Good luck

use GOTOCONTROL to select the second subform then use REQUERY to refresh the data in it

I do this using a macro - but you may know how to do it in VB choose the record in form one, then, on click of a button, run a macro that opens the second form, then in the actions column of the macro use GOTO CONTROL to go to the appropriate field on the second form, then FIND RECORD to go to...

In the settings of the first subform, use the 'on change' setting to point to some VB code or a macro that requeries the second macro, and Bobs your uncle !

you could have some code attached to the form so that, on change of the record, or initial load, it looks at each combo box and only makes it visible if the value is not null. You would also need to have settings for making it invisible if the value is null. That way, when you move between...

Just tried your suggestion and it works perfectly. Cheers !!!

your right - that sounds easier. Thanks for all of your help Steve

Sorry FoFa, the big penny just dropped. I suddenly realised what you meant by adding a day and taking a second off. I'll try that. Is this the only way, it seems a bit of a complicated way of looking at the date value of a date/time field?? Thanks

Thanks for the info FoFa. Adding one day would not normally cause a problem, but the data I'm working with is the quantitiy of failures within a production environment. The last thing I want to do is panic the management team by double counting failures when two consecutive weeks are reported...

ok - next question - FoFa kindly explained that it's the time stamp I have that is casuing the problem with my query. How do I extract just the date part of the date/time field and still leave the result as a date? Thanks

Thanks FoFa, I'm with a colleague at the moment and we just realised it was the time stamp causing the problem but didn;t know why - your reply explains why Thanks for you help Steve

Hi There, I'm gettng really frustrated with a query that should be quite simple. I have a query that pulls out data from a table based on user inputs for 'start date' and 'end date'. This is done using the "between [Start Date[ and [End Date]" function in the query. This sounds simple enough...

A simple way to do it would be to make all forms pop-up, these just open on top of each other. Then, when you close the top form down, the one below it will show.

What I've done on my databases is to use a list box which shows the user which record they are sitting on (it highlights the line in black). Then on the properties of the list box, on the 'on click' setting, update a sub-form on the form which shows the data you want to show for the active...

Thanks for all you're help with this. I've managed to do it a different way. As there will be up to 5 pieces of info captured at each manufacturing step, I have 5 unbound text boxes on the main form. These are populated from vb from a query pulling the info required for that particular step...

but there could be up to 5 items of information that need to be captured for each record, so the number of combo boxes is not static, and the values change. For example, this database captures information during a manufacturing run, so at one operation you may need to capture operator name, at...

Thanks David, but I already am doing that. I think I've got a bit further - let me explain: Looking through the posts for hours yesterday, I've found out that Access maintains only one recordset for a combo box rather than one recordset for each combo box in each record (thanks to poulsotw for...

but the PK is two fields in the table that the combo box is based on. I can't have 2 bound columns??