Search results

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

Add 2 command buttons in your form; Forward and Back On click event: 1st CmdButton: AttachmentControlName.Forward 2nd CmdButton: AttachmentControlName.Back

►Create Tables 1. CustomerTable (Fields: CustomerID, CustomerName, Address, ContactNos, ContactPerson, EmailAddress...etc.) 2. ProjectTable (Fields: ProjectID, ProjectType, ProjectDescription... etc.) 3. ProjectEntryTable (Fields: EntryID, ProjectDate, ProjectID, CustomerID, PhaseNo, etc..) ...

Create a form with a Record Source from your Table, set the default view to "Single Form" and Data Entry to "Yes" in form properties.

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

I think you have to include the actual Dates, then add another field that Format(YourDateField,"YYYY"). Group by ContractID and Group by Year

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

Thank you, i found the perfect solution here https://support.microsoft.com/en-us/kb/99938

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!

It works! I reconstruct my vba code to make it shorter/simple and this is it; =============================================== Private Sub Command_Click() Dim CodeBlock As Integer On Error GoTo ErrorHandler Set fso = CreateObject("Scripting.FileSystemObject") CodeBlock = 1 fso.CopyFile...

The actual application of my code is to copy and paste various access database from different locations into one back up folder. Kindly see attached screenshot. I made this so that i can automate file back up in Task Scheduler . I just want to figure out which from the 12 pairs of File paths...

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

Great! Thanks to you pbaldy Private Sub Form_Timer() My code here.. Me.TimerInterval=0 End Sub

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!

Check this one (Attached Database 2007)

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!

I don't know if this is what you are looking for.. Kindly see attached Sample Database