Search results

This combo box is like cascading, you choose Area, then it narrows it down to only specific Area you chose Location, and the same way going down on the list. My Data table only stores Location Code, that is assigned to Location Name and that's it. Once I bring it back to get data or location...

Reason to have so many combo boxes is based on the fact that I have 10 Areas and each Area has about 5-15 Locations and each of them about the same amount of subLocations (LocationName) and only then they have a 1-1 link to Location Code. Also if it's based only on one table it doesn't display...

Hello, I have Form ALLDataUpdate based on query from two tables: tblData and tblArea. My Query works nicely until I need to update info. tblData needs to be updated based on what user inputs, but tblArea should not be updated. tblArea is only there to provided 3 combo boxes to choose Area...

ReadTextFileline throwns an error. Error code 5.

It was xlsm file, but it was just to trial it out. Maybe there is a way to put Report into a body of the email?

It opens in browser. As far as I understand if I want to open it in windows explorer it will have to be mapped.

Hello, I am trying to write VBA code in Access to check if folder exists on Sharepoint site and if it doesn't the create it, if it does then just open a location of it. I managed to get it to open existing ones using some of my old codes, but can't figure out how to make it work to create and...

I just want report to be displayed in the body of the email. Text of report.

Hello, I have generated report from form and I need it to be dent in the body of the email. Is it possible? I have read loads of threads and put together this, see below. Currently it sends an attachment from my computer, but not report. I know there is a lot wrong, but I just figure it out...

Thank you for your help, it works

Hello, I have created a text box, that automatically draws name of user from system. If I am logged in on my computer it draws my internal company ID. The requirement is to display not just my internal ID, but my name too. I have created a table where I have added all IDs and Names of all...

Update: I changed Area, Location and Location Name to unbound. I have tried different ways of getting it to display info before update and it's not working. Can anyone advise on how to solve this?

yes, but I have no idea how to do it any different way when I change them to unbound, it works, but doesn't display them when I open this form any idea how I can get them to be displayed?

Is there any other way? I am using SELECT DISTINCT on them combo boxes, so it filters it based on previous selection and when I open info up, so it shows me the info in them otherwise they stay blank if they are unbound. Can Save button command be modified to only save info to table ALLGaugeDB...

Hello, I have created a form called Update info, see attached file. Majority of this information is stored in table ALLGaugeDB, but Area, Location, Location Name and Location Code are stored in second table AREA. Data is linked using Location Code (that is on both tables)...

Hello, I have created Form based on 2 tables that allows user to update information. One has all the equipment information and the other one contains all the areas that equipment can be found with additional information about area and responsible people. I linked both tables using Location...

Thank you to everyone's help. I have finally got it all sorted and it is working :) My final code looks like this Private Sub cmdFilterSearch_Click() Dim strFilter As String Dim strDBType As String Dim strGaugeN As String Dim strGaugeSN As String Dim strGaugeT As String...

Spent a day trying to figure it all out, now it is returning results only when I type something in DB type. For example if I search for DB type = Internal, it returns the list with only Internal gauges, when I search for DB Type = Internal and Gauge Num = 03000, it returns the list with both...

Tank you for your help, but it is only returning results for DBtype, nothing esle works for some reason.

With DB type I have no issues, as this consists only from letters, GaugeNum is 9 digit number and GaugeSerialNum can be numbers and letters. The idea is to allow user to type in information into relevant boxes and search for records by typing info fully, partially or leaving some of the fields...