Search results

First of all I would like to thank administrators/moderators of this site. When i was new to access database, i find best answers and solutions here most of the time. Now, i try C# programming language and have to find access database codes counterparts. Inserting record in C# i think is 10...

This is really on access, please see attached screenshots. The downsides: 1. Form should always be active 2. Every time i update/save the record, need to execute delete and append query. Maybe i will try to use DLookup? Iif([EntrySide]="Debit",Dlookup("FieldName","JournalTable","JournalID="...

Eval() works! Another piece of magic code to add on my favorite lists. Thank you! In case there is a better work around in my case, kindly see the attached picture for more detailed explanation

Kindly see the attached picture for more detailed explanation. Many thanks!

Kindly see the attached picture for more detailed explanation. Many thanks!

Hello access programmers! Need some help please.. Problem explained in attached picture, sorry i cant explain it without illustration.

Good day! I 'm using access database as front-end of SQL Server tables and can't find exact solution to my problem on how to attach Word, Excel, PDF, JPEG, etc.. I am partially moving from access to sql server due to data capacity issue. Thank you!

I am thinking on how to organize the form/menu navigation in my home screen and will use it as standard arrangement or grouping in my upcoming projects. I break them down first in 5 major groups: 1. Transaction Entries 2. Reports 3. Set up 4. Masterfiles 5. Database Maintenance I would like...

This is just a suppliers quote and the terms being compared. On the Suppliers_Quote_Header_Table fields are; Supplier_ID Note Terms Warranty Delivery On the Suppliers_Quote_Line_Table fields are; Item Price Amount Then i make some basic queries to come up with this output (please see...

I try this one but not really satisfied with the result. Item, price and amounts is on Pivot Table. Note, warranty etc. is on the subform. This is just a suppliers quote and the terms being compared.

Greetings! I'm looking for a solution regarding this type of report (please see picture attachment). My data had been normalized already, the only problem is on how I am going to generate the report. I tried pivot table but i could not insert the Terms and Warranty per Supplier as it could not...

Hello Colleen, I think union query is the one you are looking for. If you can attach your database, maybe i can give specific solution for your question.

Please take a look on attachments for specific solution in your question.

Database is designed for managing your files/documents so later on you can easily find the files you're looking for. This is just a presentation, you can make your own design to meet all your requirements.

Greetings to all access database fans out there! I'm still using Access Database 2007. Every time i have a database project, i use lot of macros and assigned it in every command button to: 1. To open a form in Add data mode 2. To open a form in Read Only data mode 3. To open a form in Edit...

Thank you! Problem solved. I could really use this one on my database programming.

Hello Access Database Programmers!!! I just cant figure out how to fix this problem, I need your help please. Here's the scenario: Date Amount ------------------------ Jan-01-2017 100.00 Jan-01-2017 100.00 Jan-03-2017 100.00 Jan-03-2017 100.00 Jan-05-2017 100.00 Jan-05-2017 100.00...

Please see attached picture for my problem illustration. Thank you!

if i put it directly to query criteria "18 or 19 or 20", i've got three results 18,19 and 20 which is what i am looking for. If i do it in textbox, i got no result.

I have a number_field in a query with a criteria passed through a text box. Criteria: [Forms]![MyForm]![MyTextBox] Textbox input: 18 or 19 or 20 I think access read it as a string and i dont have any idea how to do it right.