Search results

Hello fellow Access users, I have a listbox with 2 columns that populates from a query depending on a drop down that the user selects. I need to capture all the results from the list box which can range from 1 to 100. I thought I had an idea on how to do it, but it does not work. Below is what...

Hi Everyone, I am trying to get a DLookup to work in a query. I have the following: Expr1:Left([Phone],3) The first part takes the 11 string phone column and gets just the area code. Then I have an area code table and I want to associate the state with the area code. So here is what I...

Happy Friday Everyone, So I was searching the web and came across some code that I would like to implement in a future project. So I made a test table in a new access database and started to play with it. I do not understand a few items and was hoping someone could help me out to get it to...

Hey guys, I received such great help yesterday with another DLookup issue so I am hoping someone can help with this one. I have a table with account notes and I am trying to find one code and the date it happened. Then find another code that is a date less than or equal to the first...

Hey guys, I am trying to do a DLookup, but instead of using AND use the OR in a where clause. Below is the is the string and I cannot get it to work Me.txtdemand = DLookup("NIIN", "tblaccountnotes", "[acctnumber]= '" & Me.txtacctnum & "' AND [code]= 'Serve' OR 'XAServe'") The table...

Hello Everyone and Happy Monday, I am trying to export a form and it is basic now, but in the end it will be populating a table with data from Access. I am trying to highlight one sentence when it exports to Word. I cannot figure it out after many Google searches. This is my first time trying...

Hey everyone, I have a table that has vendors and managers associated to that vendor. I am trying to create a recordset with an SQL statement that picks the vendors based on manager and then group by. I need this because the table can house the same vendor multiple times. I have it working...

Hey guys, I built a form that exports a table to Word. I am using Bookmarks in the Word Template and one of the fields is Currency. I am having a hard time trying to get the value sent over to word with currency. I have tried the below: .formfields("Cost").result = Me.txtcourt =...

Hey Everyone, I just started to mess around with recordsets and I am having a bit of trouble. I have a combo box linked to a query and that works great. I have a textbox labeled txtid and the rowsource for that field is =[cmbvendor].[columns](1). The combo box is labeled cmbvendor. I...

Hello everyone, I am stuck on a SQL statement with my where clause being a number field. I created a similar table to test and changed that number field to a text field and the statement works fine then. When I use the original table with the field being a number it gives me a data type...

Hello Everyone, I am trying to write an IF statement that will break apart one drop down list by using the MID Function. Here is the code that I have: If Mid(Me.List23, 5, 3) = "CNT" Then NetworkDate_Click ElseIf Mid(Me.List23, 5, 3) = "CNW" Then NetworkDate_Click...

Good Evening, I am trying to construct a subform on a navigation form that pulls in a criteria on an SQL SELECT Statement. I am having a hard time with pulling in "Is Null". I want the query to return based on the username and if the other column is blank (no date entered), then have it...

Hey Everyone, I created a subform based on a few columns. I then created a new form based on a query. I would like to click on one of the columns in the subform and have it open the form based on the item they clicked. Here is what I have done so far in attempts to get it to work...

Hello everyone, I am stuck on an update query within VBA. I debug.print window and it shows all the data correctly, but not updating to the table. The table name is travelcalendar and the fields I would like to update are: updated (short text) newclosingcall (date/time) newfinalreport...

Hey guys!! Hi Everyone, first great forum! I have posted a lot and always get wonderful help, but as usual my users want to push me to do things I have no idea about. So the latest request was to have a form with columns listed and let the user select which columns they want to display in...

Happy Superbowl Sunday everyone!! I have a navigation form and on one of the forms within the navigation form is a subform. I was asked if I could have that subform which is based off of a query display only the results back specific to that user. The form that is attached to the...

Hello Everyone, So I have a project where I wrote a macro and saved it as AutoExec. I want it to run a few items before the database opens. The first part of the macro is to check if the user has macros enabled so the code works. The second part is to check if the user has permissions to...

I am starting a new project and I would like to use the AutoExec Macro for this one. I have the following function and when calling the function I keep getting the error "The expression you entered has a function name that Microsoft access can't find". Here is the function code Option...

Hey Everyone, So I have Access 2013 32Bit and the majority of my team has 2010. Recently they have been seeing an compile error on one of the forms. Below is the code and it highlights Me.txtuser = Environ("username") - All the code is doing is just looking up the name of the user and stating...

Hello everyone, I am trying to take a form and send it in the background using outlook. It basically sends a table to the user when an update has been made. Below is the code <code> Private Sub cmdsend_Click() Dim oApp As New Outlook.Application Dim oEmail As Outlook.MailItem Set oApp =...