Access Export issue

When exporting a table from Access as a text file, it keeps adding .00 to the end of the number format records that I am tying to export.

Does anyone know why it is doing that and what I need to do to prevent that from happening?

Access Export issue

Trusted Location

I was wondering, if you send someone a db that is in your trusted location, i.e. a named folder and they place the db in the same folder, will it open enabled or not?

Trusted Location

Get summation of a formula based field

Dear Experts,
Wish you are well. I am new on access. I want to make a register.
where I need a report as attached: 01

I want get a summation of
1. Amount field
2. Charge Field
3. HV filed

I am using following functions where I got only Amount and Charge summation, but did not get any thing for HV field, when I open report its ask me for Parameter of Charge (Picture included)



For Amount : =Sum([Amount])
For Charge: =Sum([IIf([Govt]=Yes,0,IIf([Amount]<50000,0,IIf([Status]="Honor" And ([Amount]>50000 And [Amount]<500000),10,IIf([Status]="Honor" And [Amount]>499999,25)))))

For FV: =Sum([=IIf([Status]="Honor",([Amount]-[Charge]),0))


Please help me.
Your cooperation is highly expected

Attached Images

	sshot-1.jpg (90.1 KB)
	sshot-3.jpg (7.7 KB)

Get summation of a formula based field

Run 2 Queries on "On Click" event

Hi, I have a form with a combo box that is populated by (1) a union query, and (2) a make table query from that union query. The reason I have both is because I want to have an autonumber and I can't do that directly in the first query.

So any time I update any of the tables that are in the union query, then go back to the form, i want the the combo box to update the list which means I have to run (1) and then (2) to repopulate the combo box with the updates.

Does anybody know how to do this? Thanks.

Run 2 Queries on "On Click" event

VBA Project Issue

Hello,

I hope that you can help me (God I hope you Can), my master database had a slight hiccup today and it appears that now the VBA code is corrupt.

I have checked my backups that are taken every day and every backup from Wednesday shows the same error, which I find curious, as I created a new ACCDE yesterday and no issues were highlighted.

I get the following error message:

"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."

If there is no solution I Think I will have to re-do all my work from Wednesday onwards :(

any help would greatly appreciated please.

Thanks
Tom

VBA Project Issue

Limiting Date Values User Can Choose

I have a field that shows dates as quarters. Right now it is just a date/time field, but that posses a problem, as the user can enter any date possible. I want the dates to be limited to March, June, September and December, and any year they choose. Can someone please help me with this. I tried fooling around with the input mask and the validation, but I just couldn't figure it out.

Thanks in advance

Limiting Date Values User Can Choose

Row Number

I know there's no rownumber function native to Access, but does anyone have a good alternative? I have two tables in a union query, and I need to add a sequential Row_ID to the end result. I was hoping to avoid using a report, and just stick to a query that I can quickly export.

Any ideas?

Row Number