Microsoft Access / VBA Forum

Admin: This thread was created as a hijack from How to bring a ms access form on top of all windows application. We do not tolerate hijacks. I am very dumb with ACCESS right now. I created a module called module1 with the following codes. Private Sub Command16_Click() Call Module1 MsgBox "Hello" End Sub...

Hey I am new to this forum. I want to set up combo box on a split form to filter the record in the Datasheet. I want to filter either by selecting the value or type which will filter the record as you type (partial match). Can someone tell me how I can achieve this.? I don’t know abcd about vba programming. Thanks in advance .

I have a form that contains 6 textboxes, a combo box and 3 checkboxes. The first textbox is used for a unique id; if the user starts to enter this ID, I need to disable the other 5 texboxes, combo box and 3 checkboxes or enable them if the user removes entered numerics. I have attempted to this under every option under the textbox control that...

My Access table query lists names multiple times where each record shows another sale. Some sellers sold multiple times. I want to COUNT the number of sellers who sold, not every time they had a sale. For example, Seller X sold 4 times (4 records showing their sales), Seller Y sold 2 times (2 records showing their sales), I want ACCESS to COUNT...

Is it possible to send a picture on WhatsApp through base access. when you press the button and you can send the selected photo on whatsapp

Hi there, Is there any way I can change mouse cursor in ms access form using code. If i get get some code which will change mouse cursor with some text that will be great. Thanks, Yogesh

I saw previous solutions to convert a month number (1) to a month name (January). I have a database with 200+ dates. In a query, I use the "Part" function DatePart("m",), to extract the month (number) and all month extracts worked correctly (they returned the correct numerical month). However, when I attempted adding a field in the query to...

i have two queries I want to join so i can get the percentages from each department of completed work orders but not sure how to go about it. I know i want a join and a crosstab query so i can display the results in a report. The first query calculates the numerator, SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder, ...

Hi, Just joined and also a fairly new geriatric programmer to the land of MS ACCESS VBA :( I have a table called 'transactions' and a query called qryTransactions. This query selects all records based on whether or not a flag called 'Sold' is set to 'No'. Working fine. I have a list box (Multi Columns) which has a RowSource set to...

I was looking for some mail delivered event in Outlook with which I can figure out whether the mail has been delivered to a specific person or not. Any help will be appreciated!Thank you in advance!

I have custom login interface. When the user logs in I want to show something like "Welcome John Doe" on my switchboard form? How to do it? Hint please!! Also, when the user selects "Open data entry form", the field called ModUserID should be populated with the person who is logged in right now. Open Data Entry form : frmOpendataentry is bound...

I've been away from coding for a while. I have a movie database of personal movies to which I've added IMDB cinematographers and composers. So I have a join on main table MoviesXBMC with qryCinematographers and qryComposers. I highlight / filter to see other movies by same composer. When I unfilter, the view is reset to record one. I...

Hopefully this can be accomplished. Here is what I need to be able to accomplish..... I need to use an access database to input data on a laptop. Then upload that data to storage. After uploading to NAS i need to use a front end from desktop to output reports. Can this be accomplished?The intent is to collect data and then store and manipulate...

Question: I have looked everywhere and even paid someone to look at the issue I am having. 1. I have a routine that deletes the table data and loads new datatable that is download from an SAP application. the issue i am having is that when i run the old data in the queries i get the correct calculations and percentages. But when i input or import...

Hi - I haven't built a report in years and may have lost the basics.... I am creating a report for a single contract I send to a single customer. Portrait .25" margins all around so I have 8" width and 10.5" height. I am having trouble printing in order the way I need, and am looking for instruction how to set that up in VBA. Record source...

Let me preface this by saying I completely understand and acknowledge that the way this database was built is not efficient. However, my office wants to keep this setup. I have a reports form (frmReports2) to generate reports based on information selected by the user. frmReports2 also contains a multi-value field list box to choose among...

I got a Table with vehicle registrations. I specified the data type as short text. My registration numbers is HDM100MP,HDM200MP,HDM300MP etc. When I run a query my criteria is example HDM100MP, I get a message Data Type mismatch in criteria expression, MS Access 2019

I have a long report to print in Access. Sales groups are to be printed separately, double sided. Most sales groups have enough lines to print on the second page (therefore print front and back). Some sales groups do not have enough lines to require a second page. I need to insert a second page for those shorter groups in order to print each sales...

I have had a solid access database for some time now. Yet suddenly it will crash as soon as any button that invokes an event procedure is pressed. However if I edit any form, and open the VBA window, then when I go back to access everything runs fine. I am using Office 365

I have a form that contains 3 sub forms with the names sub1, sub2 and sub3. Each sub form has a button that pops up the same form. When the user clicks on the sub form button, the name of the sub form that called the popup form is stored in a hidden textbox so that the name of the sub form can be used to requery the sub form once the popup form is...

I'd like to seek help with my access database. i would like to distribute value (format on currency) into multiple field base on date start and date end. for example on: if field Spend Amount value is - $10,000 if field start date is - Jan-2018 if Field end date is - April-2018 then the Jan field will be $2,500 and Feb field should be...

This is NOT a question regarding coding, it is a question concerning methodology. I need to encrypt a database. The database being used does not contain any encryption abilities like TDE for SQL Server. I have therefore worked out a method to do symetric encryption and key storage etc. My question is which method should I use for the...

My code (below) is giving me an "End if without block if" Error. I'm trying to highlight a row in a table according to the first cell. Can anyone help me? Sub colorrowcellone() With aTable For r = 2 To .Rows.Count If .Cell(r, 1).Range.Text <> "W5" Then colorit = Not colorit End If 'then determine color to use...

I have a database that a user will upload several excel sheets the database works except when i add new dates to the database. When I created the code to import the Excel data, we added a column called ‘WeekImport’. I think this field might be able to be used as criteria in queries to only pull the data from a given import. The only tricky part...

I'm using MS Office 2016 Desktop App on Windows 10 and looking for some functionality which I didn't find any success after searching online a lot and also contacted MS Outlook Support to only find that there is no easy way to achieve it except VBA script. Here's what I'm looking for: I'm sending individual mail to a huge bulk of people having...