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

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

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

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

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!

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.

Hello! I'm having trouble with a query right now From this scenario: ------------------------------------- ID SeqNo Value ------------------------------------- 1 1 A 1 2 C 1 3 E 2 1 B 2 2 D 2 3 F...

Greetings! I have learned and able to develop MS Access program from Tables, Table Relationships, Normalization, Forms, Queries, Reports, Data Outputs and so on.. I can get what I want on Ms Access so far, but this time I am interested to try MySQL Database. Creating tables and some basic...

Fields: Date PumpNo PreviousReading CurrentReading Jul 1 101 0 100 Jul 2 101 100 200 Jul 3 101 200 300 PumpNo Afterupdate event...

Hello! I just want to know what is the best way and good practice in limiting user's access in form or report. For example, i have 2 users in my UserTable, one is Administrator and the other is just ordinary user. In case i want the ordinary user to open the form in "Read Only" mode, and the...

Hello access programmers! [MyField] contains for example A1B2C3 or ABC123 or 1E2F3ABCD ... I want to see a result of 123 using Replace Function Is it possible?

Access 2007 I have a main form with 4 subforms Each subform contains combo box that requery itself On Got Focus When I enter the data in the first subform's combo box, an information message pops out saying "There is no field named '2nd/3rd/4thSubformsComboBox' in the current record" and...

Hello access-programmers! I just want to share this "Processing..." animation in Access 2007 form. Hope you'll like it! Thank you!

Hello access-programmers! As I moved on, vba codes seems so interesting. I have no formal education or training in microsoft access, just did self-study. And I'm so thankful that I've found and joined this site. *** Here's my VBA code *** Private Sub CommandButton_Click() On Error GoTo...

Hello access-programmers! Got a problem here: Timer Interval = 5 Seconds Private Sub Form_Timer() My code here.. End Sub The code repeats every 5 seconds, what I want to do is to execute it only once. I have no idea how to solve this one.. Thank you in advance!

Hello Access-Programmers! I need your help regarding on how to manage attachments (Document or File Links). Kindly see attached screenshot for the details. Thank you!