Search results

Hi its a MSCAL.Calendar.7 Calendar Control 12.0 and it stop working for date picking with no code behind the event at all ? Can you download better controls ? It is Access 2007.

Hi I have a Sum Query called SumQuery [sumquery]. I want a text box [Text10] on a form [MainFrm]to fill with the result of the sum query [SumQuery] (one value only) when I click on a control on the form. The SumQuery uses a value off the form, a text box called [weekofyeartxt] as criteria to...

Hi I have a date control and on the Click event I run the following code. Trouble is the Date Control stops working, ie you can't change the date after one click ? CODE. Private Sub Calendar7_Click() weekofyeartxt.Value = DatePart("ww", Calendar7.Value) End Sub Thanks.

Hi I am trying to create query that will show the "total number of visitors we have each month". Just now each visit creates a record with the time and date of the visit e.g. 11/12/2010 10:05:33 I need to extract the month and year from each record and total the number for each month, (so i...

Hi do you get voice recognition software for access ? I know you get it for Word. gregor.

i have a report, and have a sub form on the report, i have made the box equal almost the whole page, but if the data for the report sub form is greater than the size of the sub-report form, it just cuts off the data? I need the sub-form on the report to expand to equal the size of the data it...

Can i ask, why you have the cancelEvent in there ?

---THANKS--- Gregor.

Hi I want to set the focus to a text box when i press "Ctrl X" on the form. What event should I use ? What is the code to let me do this ? Can you help ? Gregor.

Thanks very much.

Question for access forum Hi i have a database for a vets, and i have to print labels for them for the medicine. The main form has all the patient details and drug details. I have tp produce a report i guess and populate it with details from the main form and from an inputbox (drug amount). So...

could try reposting the thread.

hi i have to say that I dont know how to do this, can only suggest. I dont know how you open a web page in access. I normally use Visual Basic and open a webbrowser object in that at a certain page, using the url property. As for logining on automatically, is there no way you can use the url...

Thanks will look for toggle

hi i have 2 front ends and one back end with linked tables, that is working well, but over a wireless hub. I am going to use wires from the hub to the 2 computers so it is safer and less likely to corrupt. my question is will the router start sending the infomation down the wires, rather than...

but the ark floated and the titanic sank :)

question - because the parameter is off the form ?

i think rich is right.

Dont know, can you try to msgbox me.per_id ????? or mgsbox "[Person ID] = '" & Me.[per_id]"'" ????

DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = '" & Me.[per_id]"'" so if person id is 4 it looks like this to the report [Person ID] = '4'