Microsoft Access / VBA Forum

Hi All, I got really good help here last time so i thought i'd try again !. I'd like to have a command button on my form which does the following - 1. Downloads a file from a url 2. Saves the file in a particular folder 3. Renames the file as Suppliers.xlsx 4. Imports the data into an existing table (overwriting current records) It...

Ok I am not good at forming my questions. I am attempting to check for existing records from a table (Client) specifically from (CAccount) field on that table. The form I am working in is based on another table (DoSService). The txtfiels on the form is (DoSLocation). I keep getting an error at the .findfirst line. What am I forgetting or...

Scenario : i have a table tblOne - SCID , BoxSetNo , BoxesInBoxSet --------------1----------1------------5 --------------1----------2------------7 --------------1----------3------------9 --------------2----------1------------3 --------------2----------2------------7 so what i want is , in a form i need to have a textbox where the sum of...

I have Developed a Small Business Inventory System for my own business, But the system is not complete i have made progress halfway and i use that system at my business to do Data Entry so i wont loose any of my current data... My Problem is : i do changes and modification to my Database in my resident but i am currently using that in my work...

Hi I have one combo box (cboMASTER) What I would love to do is select a name from this combo box and I would like about 20 text boxes to populate based on the value of column 0 in the combo box, that is the record ID cboMASTER = 1,FullName What the form will show is a family tree. And will show relatives based on who I select in a combo...

I am using openargs to transfer 2 variables to a form. However I am missing something when I sent the request through. The second variable goes through without problem, but the first one is not. The system is seeing the Var name and sending that. Im sure it is just a formatting problem. Code in Parent I Need it to pull the variable Accessionz...

Hi and thank you in advance everyone! I want to add +1 to a value in a field by clicking on a button in a form. My table called "Requests" has a field called "Request#". I want to add a button in the form called "TblRequests" so that when it is clicked, it will add +1 to the highest number in the field. I am using this VBA code (please see...

In a Clients table ("tblClients"), I have a ComboBox "Employee" to select from a list of Employees contained in tblEmployees. I only to display / allow employees who are "Active" in the system, however, if any employee was already selected, but is now "Inactive", I would still like them to show up / display. Scenario: Tom is the salesperson...

What has happened to the Access query editor? Sometime in the last 6 months or so I lost the ability to simply assign an alias to a table in the query editor. The rectangle representing a table in the query editor now has a yellow border around it. And when I click on a table, instead of getting a property box for field list properties, I get...

I am very new at this and working on creating a macro for calculation the tipping angle of a bottle. For the I need to assign an off set value for each different bottle types and this value will later be used in the calculation. I am not sure how to go about implementing case statement to the combobox. Thank you in advance.

Right now I can generate a report that groups data per each sub group. I then export them to individual PDF files by a VBA code. So the report with group ID 555 generates with group 555’s data and so on. I need to add generic full pages to each group document. I tried a few things but it doesn’t really work. I’ve ran into random problems/glitches...

I am working on patients' record database, which I made using Access 2010. when I open it in Access 2016, its theme gets changed altogether. I fixed it by saving 2010 theme by using 'SaveToFile' method and then updating theme in Access 2016 by using Themes > Browse for Theme.. in 'Themes' portion of 'Design' Tab. I Want to open that Browser...

Im trying to restict user from certain groups and only allowing them to fill in certain fields. but it seems that the code i have allows all user to enter data can some one help me. the code < Option Compare Database Private Sub Form_Load() 'dim the control Dim ctl As Control 'If the user is in admin do not lock the fields. If...

I have a report that needs to track the total time spent on a project daily. I have converted the hours to minutes, and am using the Format( Mod, "\:00") to convert them to hours & minutes. One person has 360 min +420+420+450+270 = 1920 total minutes which divided by 60 = 32 hours --- the report shows a subtotal of 32.30 hours?? There are no...

Need some help/pointer. I am attempting to search a table/field to see if it matches a field in a form. This is not working for me. I am just looking to hard, but reaching out. If Me.Txt_field = DLookup("", "Table", Preset_variable) Then 'found it Else 'didnt find it

Hi. New to Access and would appreciate any help! I'm working on a Multiple Items form and want to populate the date field in the 2nd, 3rd, 4th, etc. line with the date selected in the 1st line. Example: 1st line = 7/25/20 2nd, 3rd, 4th, and on = same date

I have three tables and would like to export them into one excel sheet. One table will be from column a to e and second will start from column g and third table from k. Please let me know if it is possible.

i am beginner dont understand coding very well, i saw a post in which i get code but i dont know it will work or now and i dont know how to use it in VBA. can anybody teach me ? Option Compare Database Option Explicit Sub Test() Dim TestDate As Date TestDate = CDate("11.04.2013") Dim dtString As String dtString =...

Hey buddies i create a form and a report i am using signature image on report through form i made a checkbox ... now anyone tell me please how to VBA code to hide or unhide the signature image in report ............. not in form......

I have a Form Where i Need to see Values from a another table's field so i have created a lookup field, that works perfectly but i wish to filter that lookup list with values which are not yet Added?? Table -- TblSup Field -- SCID Table -- TblRec Field -- LPSCID i have a lookup list from TblRec!LPSCID field so i can view values...

I have a fixed with txt file that has multiple data specifications in it. I am using MS access 2013 to parse out the data. Is there an easy way to apply the different specifications to the file without having to build separate queries in Access to parse it out?

suppose i need only to validate year range for period that is 2014-2016 like this format. it shouldnot accept the value period 2020-2016. how can i give my period first given year should be greater than second given year. kindly help!

I have an Excel file that uses VBA to open an Access database in the background and run a macro that refreshed tables in the database. Once this is complete, then there are steps done in the Excel to refresh data linked to the Access table, copy, paste, etc. The Access has slowed a bit with a server change and now the macro takes a little...

Hi, I am using Access 2013 to do this. I am trying to come up with a way to export multiple tables/queries to different excel or text files automatically when a user pushes a button on a form (one file per Table/Query) I would need the user to be able to choose the file layout and the destination Location for the exports. An example...