Search results

Hi Bob! I am still having a big headache with the blank forms.All the forms that I have hidden are facing the same problems. I have to close the blank form and click on the button again. Only then the data appears in the form. This is not acceptable by the users. You mentioned that you don't...

Thanks Bob! Just sent....

Hi Bob! Yes I did but the file is still 2.81MB. I tried again to attach but withou success.... What can I do? Thanks and regards!

Hi All! I have a form with the following: A combo textbox with Category A and Category B. An Amount texbox. In the form footer, I have a textbox calculating the sum of the Amount. This works fine but how do I create a textbox that calculates just the Category A or Category B?? Anyone please...

Hi bob! Thanks for your prompt response. Kindly find attached db as per your request. Login in as user, password is user. click on cash management,then click on input sales. when you do that a blank form appears.when you close it and click again, then the form with the data appears. I still...

Hi Bob! My data entry was already set to no. My arguments are openform, form name, view form, window mode hidden in the macro.. I used another button in another form to open this form again. Just open form normal. I tried requerying, etc but nothing seems to be working... Thanks for helping out...

I have a button using a macro to open a form in Hidden mode. Then I have another button on another form to open this form that was hidden. When I open the form, the form is virtually blank apart from the form caption name. But when I close this and press the button again the form opens as...

Thanks CJ and Bob! managed to et it working finally by using the same query based on the 2 textboxes from the form. You guys are great!

Hi Ed! Thanks for your help! After trying various options, I managed to accomplish the task by using the conditional item from the ribbon menu. Thanks!

Here's the query as per your request CJ! Thanks for helping out!

Hi Ed! Thanks for your prompt response! I had actually created the setvalue in a macro. the item for the set value is [Forms]![frmEditTasks]![frmsubEditTasks].[Form]![Notes]. The date is actually in the main form. If someone changes the date, the expression will appear in the notes textbox in...

Thanks CJ! I actually have this criteria in my query under the date field. This works on its own but when I have another criteria under the username field to select the chosen user for the report, the query does not work. Does that mean that I cannot put two criterias in the query? Please advise!

I managed to create a report by user using a combo box. When an user selects a name from the combo box, it generates a report showing all the records by that name. However, now I need to be able to generate a report as above but between 2 dates. How?? I am having two sets of criteria. 1) by user...

Hi All! I have setvalue to an item when the date is changed, an expression " You cannot change!" appears in another textbox. This is working fine. But i need the text in this expression to appear in RED! How can I do it? Help please! Thanks!

Hi big Pat! Maybe you can further assist me in this as you managed to help me greatly with the wk. number thingy.... Now I have a few weeks record showing when I open my form. I want to see just the current week so what is the best method to adopt? Basically, every week when I open my form I...

the date is set in the control source. I just need to automatically change this date to today's date once I have edited or created a new record from the subform. The date is in the main form. Thanks!

The users do not want to use a zoom box. They want to see all the records as they open up the task form. if one or two records are large, they dont mind scrolling down to see the rest of the records. I know we can use the can grow property in the reports but why dont Access provide this facility...

Is there a way you can auto expand a textbox in a form? E.G. you have 1 sentence in the textbox field, and this can stays as it is but when you have 5 sentences or more than the textbox automatically adjust itself to cater for the data. when i see the form with all these rows of fields, some may...

Thanks for your prompt response! Tried it but afraid it is not working....I am using MS Access 2007. ??

Hi all! I have a subform with a notes field. Upon creating a new note in the subform, I like to update a Date field in the main form to today. The date field consists of an old date which needs to be automatically updated upon creating the new note. How can one do this? Anyone help please??? Thanks!