Microsoft Access / VBA Forum

Hi There is a simple task, you need to run the access 2003 database on access 2019. After the conversion, before starting the application, I get 2 errors 5: CM_replicator.Class_Initialize: Invalid procedure call or argument and 91: CM_replicator.Get_replication: Object variable or With block variable not set. The question is how to fix them?...

In recent weeks Access 365 (and I believe earlier versions) has become unable in certain circumstances to create a backup (File>Save As>Back up database>Save As) or create a .accde file (File>Save As>Make ACCDE>Save As). The symptoms vary depending on whether the FE has a password or not, and whether you are making a backup or a compiled version,...

My end user is using a filter on a sub-form (SearchQSubform) then pressing the "PrintPDF" button that is located on the form (SearchForms). However, all the searched data in the sub-form is printing. I only wish to print the user's filtered data. I tried putting the following code in the "On Click" event procedure for the "PrintPDF" button: ...

Currently I have a report created from a query with a filter based on a single unbound listbox which is working. I tried to add a second unbound listbox for additional filtering but it is not functioning - no errors just literally seems to do nothing. The code that does nothing is a replica of the posted working code with exception of the control...

Hello, I'm trying to set the visibility of controls in a subform with a combobox in the main form. I had it working but i needed to move some table fields from the sub to the main. Ive tried researching but Ive had no luck in finding an answer that is related to the controls directly. This is what previously worked when the combobox was on the...

Access Europe (AE) is a new online chapter of AccessUserGroups.org. Further details are available from https://accessusergroups.org/europe/ All meetings will be on the first Wednesday of each month from 18:00-19:00 (UK time – currently UTC/GMT) and will be co-chaired by Alessandro Grimaldi & Colin Riddington. Whilst Access Europe is...

How to add a word "Continued...." or any other indicator if some of the rows go to next page or column on a report? Can anybody help me? Thanks in advance.

Hello I have an access database for transactions I want to prevent duplicate entry against any account Suppose i have an account (4422A) and i want it to pay only one in a month If i enter this account twice access don't allow this entry. please help me Thanks

Hello experts: I came across a 10+year old posting in this forum (https://bytes.com/topic/access/answers/911063-how-create-automatic-dynamic-union-query). The solution offered by @Steward Ross is fabulous and perfectly fits my current need. However, I need to slightly tweak the VBA in order to NOT process *string* values vs. *integers*...

I am throwing a blank on an easy one. tblHours has 2 less records than Machine Hours table. I would like to say if . has a record not in tblNotes. then add it. I don't want any dulicates. Keeps saying there are zero records to add when there should be 2. INSERT INTO tblNotes ( ) SELECT . FROM tblNotes RIGHT JOIN ON tblNotes. = ....

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

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

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

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

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

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

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

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

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

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