Search results

Hello All, Hope someone has had a similar issue to the one that I am having. Using: SQL, VBA in Access, Sharepoint List What I'm trying to do: Update a record in a SQL table with updated data from a Sharepoint List using a button in a form in MS Access. What is happening: When I run the...

Hello All, I'm hoping someone out there can point me in the right direction. I don't know exactly what question to ask, because I don't know the correct terminology to use......I Think! So I will explain a little bit and may be someone can figure out why I mean! Ok, I have an Access Form...

Hello All, I need some help and I'm sure there is a someone out there who know exactly how to solve my issue! I have an Access form, in the form the user enters or picks a date, chooses a project from a combobox and then a report from a combobox. The first two boxes (date and project)...

Hello All, hope there is someone out there who has had a similar issue and can let me know where I went wrong! I have an Access front end using linked tables through a DSN connection to SQL Tables. I have created a form for entering data into a table. The form seems to work great, but after...

Hello All, Need assistance or an idea on how to proceed. Here is my issue: I have a report in Access that prints four columns of time along with names as such. Its a timesheet, some names are big, some are small. In short I have added the code below to the Detail Section On Print Event...

Hello out there, need some advice on a query that has been giving me fits. I have a SQL Backend and an Access 2016 (*.accdb) Front End. I have a table in SQL with 24 rows. I have a table in Access with a few thousand rows. There are two common fields in both tables [HOP1] & [HOPD], both...

Hello All, Another question for the Access Gurus. This is weird problem that I've never seen before and I can't figure out how to fix it. My old machine died so I now have a new Windows 10 machine where I am running Access 2016. The problem is that the size of the boxes for each table name...

Hi All, Thanks in advance for the help everyone here is so great at providing! My issue today is that I am trying to switch the focus between two forms. One form is the main data entry form for a particular task, the second form is a popup type form for reference only. When a user selects...

Hi All, Thanks in advance for any help that you can provide. I have a form with many fields (25+), some with list boxes, some combo boxes and some regular text boxes. What I would like to do is have a label or text box in the form that will display the controltip text for the active control...

Hi All, I need a little bit of help on a form that I am working on. I have attached a sample database so that you can see the code that I am using or trying to use anyway. Here is what I am trying to do: I have a form with a subform in it. What I am trying to do is filter the subform based...

Hi all, :banghead: Stuck again and everyone here is so helpful! Today I am trying to retrieve a subform's name so that I can incorporate it into a piece of code, but I am not having any luck after searching through the forum. I have established a variable like this: Dim currentFormName...

I am working on the data entry forms for a database. I'm confusing myself trying to ask the right question(s) so here goes... I have three forms, Form1, Form2 & Form3. All are for entering data into tables. Form1 and Form2 have a Facility Name Field ComboBox Form3 is for adding New...

Hello, first time posting with the site, so I hope I get this right. I am building a form for entering data into a single table. I referred to another user's VBA code to check for multiple blank fields in the form by using the Other Tag property for the fields I want populated and then set...