Search results

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.

It sounds like you have your tel no field set as a number you would probably be better off having telephone numbers stored as strings. You should never need to perform a calculation on a telephone number.

I did actually try that but it still comes up with the error. You still have to step through the code. My work around in the end was to produce two graphs with different rowsources behind them. Then made one visible and the other invisible depending on what condition was met. Works a treat...

Ive just searched through the forum and it seems like a lot of people have come across this problem before and no one has suggested a way to solve it. Come on people there must be a solution to this. Or is this just another known bug!

I have produced a report with a chart in. I wanted to be able to be able to change the rowsource for the chart using code. I used the on open event for the report and changed the rowsource property for the chart embedded within the report to sql A if one condition was met or sql B if second...

Im trying to create a line graph which plots how many orders/Quotes are made each day in regards to salespeople. It plots fine but any dates that are missing are not included so im getting no gaps at weekends which i do actually want to show. The only solution I can think of is to create a...