Microsoft Access / VBA Forum

Please can you help? I am trying to duplicate a form from a button using vba. This has worked for years using Allen Browne's "Duplicate the record in form and subform." http://allenbrowne.com/ser-57.html Now I want to change one of the fields to multivalue. I understand the difficulties with multivalued fields, but this is a 10 year old...

Dear all, I am unable to calculate running Dsum of opening balance of ledger accounts (above 200 ledgers) =Nz(DSum("-","qry_OpeningBalance"),0) this works very well only for single ledger account, but not working for all ledger accounts in report, for example, i want to see ledgers of 2 accounts i.e Capital and Assets 1-Capital Opening...

Hi, I read How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION! and I can not really find an answer by searching as some articles or other forums threads talk about parts of my needs but no one yet places a full roadmap to learn ms access. Is MS Access worth learning still in 2021? If YES then please suggest a roadmap. I mean in...

This thread is a response to a very popular thread (How to convert Text dates to Date format?) which is locked down now so I thought I'd reply separately. This should be considered as a continuation of the topic where, hopefully, I can clarify any confusion. Always bear in mind that date values and date literals are completely different...

Hi. I'm running win 10 (updated to most recent). I've recently rebuilt my computer and have reinstalled Access 2007 and a split database. In the front-end there is a script to email a message to multiple recipients. I select the recipients from a list and click a "send" button, intending to send it as an email in Thunderbird. I'm using the...

I have a Form that has a query and in the "Split Form" Default View that can be edited the main table. I am selecting the values that I want to include in printing using Checkbox. If you save it and close the form, the selected values will not show if ever the form will be opened again. I want to disable the print button if there is no values on...

Hi all, I have a problem with an Access database, I do not see any VBA Compile-errors or Runtime Errors (ie. 3011 when the filepath is too long). See attached image where I have a Button in a Form with a deliberately error in the VBA-code. When I click the Button, nothing happens, I have to open the VBA-windows and go to Debug->Compile to...

Good Day Friends Thanks a lot for the Guidance through Questions answered Well, am working on a Customer Database and in my Developments I would Like to Guide on how to I can Develop a Function that can Enable me Sum up a Particular Customer Deposits for a period of 60 days , which installments are paid for a Good once the Whole amount is...

Access 2016/Windows 10 I have a pop-up subform where I input numeric values. In my main Form, I calculate the Average, SDev and Count of the values from subform (table) by using an aggregate query. What is the proper syntax for VB code to refresh/requery the aggregate query? I want it updated following each data value is entered. I assume I...

Background: I have slowly and painfully been working on creating an Access database for sports cards. Database Needs: For the purpose of this post, a user (me) will need to be able to search for cards by Sport, Location, or Team Name (or a combination thereof). Problem/confusion: Could someone kindly look at my screenshot to see if I am...

Background: I am building a sports card database (or trying to). (In MS Access) Situation: The sports card database necessarily will require a lot of many to many table relationships. Problem: Me. I am have trouble grasping some instances of the many to many concept. Example1: Student to Classes (I understand this)

I've tried this on both a report and form and have had no luck. I have 7 fields and am trying to group my form by 'Part Number' and then sort by 'Date Added' I have multiple of the same part number (intentionally). Right now I have the 'Part Number' grouped together and my form/reports are sorted by 'Date Added' date first. However, my problem...

I have great difficulty getting to grips with Access VBA. I have copied the example given on this subject into a standard module (I assume it is a Function) and have tried several others. The code will not run, I get an 'Expected: end of Statement' error. It seems I have left out something basic and would be grateful for any advice. Regards

The UK AUG seminar originally scheduled for 4 Nov 2021 was unfortunately cancelled due to issues related to COVID. This has now been rescheduled for 8 Feb 2022 - hopefully as a live event.... The agenda is as follows: 0915 START • Steve Girling, Case Study of a Live Project Using an Access/SQL Database • Donna Landy, The Lazy Coder –...

I've got a form with a custom right click menu, called via the Mouse_Up event on one of the textboxes. The strange behavior is that if I right click (getting my custom menu) and then just click out of it (click somewhere else to get rid of it), then my form loses its filter. If I click one of the items in the custom menu, then the filter stays...

I first wrote about this back in Jan 2018 at another forum. It appears that the following info is not widely known, even amongst experienced developers, so I'm mentioning it again in other places. In fact, after hearing about it from me, Mike Wolfe has just written an article on the subject Hidden Feature: Drag and Drop Access Objects Between...

I have a database for Employees and I have the employee ID prefixes in different format in combobox for which they will be given according to the project. For example: I have few employees under Transportation project and they are given the Prefix of "LSB" and for construction project "TDN" and the four digit employee ID No is given manually...

Hi, I can not connect my access database to share point site. I am using MS access 2007. Whenever I try to connect my database "Testdata" to share point site an error appears (Testdata could not connect to the site you specified. Verify the address of the site or contact your site administrator). Is there any other settings required in MS...

I have a ComboBox and, at the Change event I update RowSource and then use the Dropdown command. But I realize that the ComboBox list is not updating (refreshing). I've already done several searches on the Internet about it, but I did not find a solution. Any tip?

Hi I have a continuous form based on crosstab query results. The fields in the form is from the crosstab column headings. I am looking for updating the records directly from the form such as on click of that item in the record need to be updated from a pop up/or values placed on the form header (as textbox or command buttons) The structure of...

My DBMS has a main switchboard which is opened by autoexec and remains open for the life of the session; it contains an "Exit Database" button which performs some housekeeping such as logging the event, before executing the Application.Quit. The problem is that some users are closing the application by using the "X" close button on the...

I now have a very tricky problem. I have a form in my Access application which sometimes - perhaps once every 5 to 10 times, though it is not consistent - does not open completely. Specifically, when opened it displays the header section and a skeletal version of the footer section (i.e. text boxes but no data), but the detail section is...

Intro: I am still (painfully) trying to create a sportscard database. I have other questions related to this endeavor in other threads in this forum. Background: I need to database to be able to store Order data (items I buy) and Sales data (items I sell). One Order can later be part of many Sales (i.e. many items can be bought in one...

Hi guys, How do I go about opening balance (Previous total balance) for my various accounts in my cash flow. I am open to all suggestions

I used your format and Rick's =Sum(nz(VAL(!!)))+(nz(VAL(!subCalendar]!))) but I still keep getting #Name? in my textbox.