Search results

Good day All I have a form to input data into a table1. On the form I have a combo box to read from a next table exchange rate to input into the table1. Field in Tablet for the exchange rate is set to Field size double, Format currency, and decimals 6. I am unable to set the field...

I was trying to send an excel spreadsheet in the post put it did not come out as a table

Main Heading Item Code Budget Previous Records Current records 2 2.2.1.1 $4,684.00 372.64 80.37 2 2.2.1.1 $4,684.00 548 80.37 2 2.2.1.1 $4,684.00 1337.11 80.37 2...

Good day, The reason why (with my limited knowledge) I created two table is because the report needs to have the previous records in one column and the current in the next column as shown in TEST QUERY in the attached DBase. Click on OPEN REPORT FORM, choose data from 1/7/14 to 31/12/14. Hope my...

Thanks for responding. This budget has only two levels. I changed the query to read Unique Values, but the data is still duplicated. Please see attached data from the summary query. This reports works well. Let me explain how I get my report. I have one table with expenditure. But after...

I have been unable to get someone to help with this post. Duplicates on report Hi All, I need some help with a report. My budget in the database has three levels. Main Heading 1 Account 1.1 Item 1.1.1 etc From the Dbase, I am supposed...

Duplicates in report Hi All, I need some help with a report. My budget in the database has three levels. Main Heading 1 Account 1.1 Item 1.1.1 etc From the Dbase, I am supposed to run four reports quarterly. One a detail of all transactions by item, account and main heading One a total expense...

Will do. Thanks again Cristina

Thanks soooo much, never knew these things were possible. My budget in the database has three levels. Main Heading 1 Account 1.1 Item 1.1.1 From the Dbase, I am supposed to four reports quarterly. One a detail of all transactions by item, account and main heading One a total...

Thanks very much it worked fine. I was able to update the table. However, let me explain some more. I have this dbase that I created so that I can get some reports, in a specific format that I am unable to get in quickbooks. It is report from a donor agency, and is very specific. I have been...

I think I would be able to create the query and make a form to read from the query. But I need to update the table, but I want my form to only show the ones that have not yet been updated so I can update the field that needs updating. Eg field set automatically No, and I need to update to...

Good night All, I do hope I can get some assistance that I can understand with placing a filter on a form. I have a table that needs updating. I created a form based on the table, but would like to only see the records that need updating, instead of the entire table. I have no SQL knowlegde...

Thanks, I changed that and it works. I will now just have to make changes to my query, which was getting the hourly from the table linked to the subform. Thanks very much.

Yes there are three. NAme, Social Security and Hourly Wage. I can only really do away with the Name is I need to. Thanks

Thanks to you both. The data entry property is set to NO for both the main and sub forms. When I open the subform, where it is not part of the mail form, it entries show up, all 668. But as soon as I drag it onto the main form, it disappears. Any other suggestions. Really appreciate it...

Hi All I need help with a form and subform. I have a main form EMPLOYEE RECORDS with employees information, with a Subform, where pay records are entered. Mysubform always shows record 1 of 1, and I cannot scroll back to see previous records. How can I see the previous entries. Thanks

Thanks denomc It works well and gives the zero cents, but for the fift cents it gives eg. and 50 cents. What I need is fifty cents or any other amount in word for the cents. Can you explain how to run a code in break mode, I was trying to figure it out. Thanks

Hi all, I have this code I got from this forum. It converts dollars in numbers to words for a check. So it converts to Four Hundred Seventy-Three and 21/100 I would like it to read Four hundred and seventy three dollars and twenty one cents. Please for some help Thanks 'This code was...

Thanks for your help. I am still working on the DBase. I have a question : should the file "BE" be stored on the server. Presently it was on another computer in the manager's office, and we were having the same problem. Do you think that is the problem? Thanks

Thank you for your response. I will not be able to try your suggestions as I have to to another office. I would like to know how to set up "trusted sources" Thanks Cristina