Recent content by SiE

I am creating a text file using vba. I want the numbers that i am outputting to always show 2 decimal places but they are always 2 or less, for instance 5 will output as 5 rather than 5.00. My field type is double and I am using the round function to get my numbers to 2dp. Anyone got any ideas?

I am trying to copy some forms from a password protected database and it will not let me without providing a password. How do I take the VBA password protection off a database so that I can copy objects?

Is anybody aware of any senior access roles going in their workplace in the UK? Im getting bored of using agencies. simonellershaw@hotmail.com

By setting the display format to text box you output the field as "YES" or "NO". If you leave the field to its default settings it displays the field as a box with a tick in. Its the lookup control that I have set not the field type. Anybody got any ideas?

I have created a query in Access which I use as a source for a mail merge in word. I have set the fields up in the query so that any yes no fields have the format of yes\no and that there lookup display control is text box. When I come to display my records in the merge yes no's appear as -1...

The function basically returns the last day of a given month. It takes any date in and gives back the last date of that month. I just put days worked as an example. Public Function LastDayMonth(today As Date) As Date Dim lastday As Date lastday = DateAdd("m", 1, today)...

I have just noticed something : On the machines that dont work, when debugging if you pass the mouse over the date type on the function declaration ie public function daysworked (indate as date) as date it displays todays date when it shouldnt display anything as it is supposed to be...

Ive tried entering the format as dd/mm/yy and the problem reoccurs. The thing that mystify's me is that it works on some machines but not on others. All machines in the office have had there shortdate changed to dd/mm/yy in control panel from install. I have also double checked it. Its so...

I have a form which contains a few fields two of which hold dates and have the short date format selected. I then have a function which is called along with one of these dates. working_date_func(start_date_1). The function then does some calculations and returns a value, all pretty simple...

Ive created a pie chart in one of my reports. The chart can contain between 1 and 21 different categories within the pie. The problem I have is that I cant set the legend up so that it shrinks or grows depending on how many categorys there are. In a lot of cases I have a legend 15 cm's tall...

Im trying to create a pass through query to sql server using vba in access 2000. The only trouble is every example ive come across including the one with access 2000 uses old dao syntax. Anybody got an example of a pass through query with a parameter that they could post here. Much appreciated

create your update query and save it. use the on close event for the report and just do a docmd.openquery "query name of update query"

in the format for the cell on the report enter :- 0.00;;;0 the first option is the format of the field displaying. The end option is what appears if the field is null in this case 0. It could be 0.00% or even a string like N/A. hope this helps

I have generated a report that gives me the top 100 products sold in the company it also states what qty and part code plus the position in regards to the 100. I want to be able to put a combo box on a form and use it to decide what field to sort on ie top 100 by spend or top 100 by qty sold...

go to options and turn auto correct off. this should solve your problem. This is a known bug in access. Gave me a load of hassle a couple of months ago.