Search results

In word form, how to copy the field name labels and bookmarks to various child records.. I have a word form eg with a Supplier information and different products the supplier supplied A supplier might supply one or more products. Rather than having #1, #2, #3, #4 sections for different...

excel program when run second time from MS Access - fails giving object failed or method global row failed etc different error each time while stepping through code... I think the cause is because of instance of excel is still seen in task manager process section. Not able to figure out - what...

Solution to parse the strings below and get number of months 1) 10 years 5 months 5 days - Should give 5 2) 6 years 10 months 22 days - Should give 10

from the given query results which include 3 date fields, 1) Intake date 2) Rec Date 3) Closed Date I have to generate a report like, from date range 8/28/05 - now(whatever date the report is generated), the format of the report to be. Toatal number of records for each date between begin to...

I have a query that groups by 2 fieds application type and outcome. There are only 2 application type = "Access" and "Return" Where as the Outcomes are many.( Prevention, mediation, Attysecured, Withdrawn, Unfounded ) For a given date range lists entries to display the total and categorize...

I got it to work thanks. I got it to work thanks.

Hi I have a small database with 4 tables that I am using for the current problem. The tables are call, parents, mailman, orders. Call and parents are related by the call ID (a primary key in the Call table.). Mailman and orders are related by a Unique Id (a primary key in the mailman table.)...

I am still testing it.... I am still testing the audit trail, hence asking the feedback from people who have been really using it in production. Thanks

Hi, I I use the audit trail feature to track changes, since we store the information in the memo field in the table, wont the record size increase and ultimately created a problem to database size. Has anyone used Audit trailing feature succesfully and sofar did'nt encounter any problems. let...

Thanks All.

OK thanks for reply, may be I did'nt put it in right way. OK, how to give the user that option of setting a password. When as a developer, I have added a new user to the related group with PID. Where can the user set his or her password. Thanks

Once a workgroup file is created, and security is established using user security level wizard, how can I add new user to the system. How can I set the password for the user. Thanks

How can the backup be done in a database which is secured with workgroup file through access security level wizard. Any user once the security is done must login and identify themselves. So what does backup really mean in such scenario, do they have to copy all the 3 files, mdb,mdw and .bak...

After reading the document which every one is pointing too, the one that is available in Microfsoft. I have used the user level security wizard, added two users, primarily first to test it. I saved the userid and pwd information in snapshot format. I gave myself adiministrator previlage, other...

Thanks a lot Jon. thanks, That did it.

I have a parent form with unique record with 3 fields, business id, journal id and journal date. Each journal entry in the parent form has, several account details records in subform with amount field. I am trying to say for each journal entry, sum up all the amounts in amount field, if it is...

thanks a lot.

I have 2 fields Credit and Debit created just in the query design, They are just alias fields, not fields in the table. I have a amount (field name amt_mntry) in the table gen_ledge_cct_details. The logic is as follows...

Thanks Alot.

Hi, I have a main form, frmmain, and subform accdetails subform. The main form has a unique record combination of 3 fields. 1)Business unit, 2) GL Journal ID 3) Journal Date. Right now for every record the business unit is same, Only the combination of GL Journal ID and Journal Date are...