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

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...

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

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...

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...

Occassionally I get an overflow message when sending emails out from an access app. all i am doing is taking numbers from a form and assigning them to variables then building up a message as a string then sending them out as an E-Mail. The weird thing is that I will get an overflow error, go...

I need to generate a report concerning sales. I have a table with orders in related to a table with order contents. all orders are related to salespeople. I want to work out what customers have spent over the last 3 months by salesperson so i thought of a crosstab. I used a query first of...