Search results

I have a report that sorts the data based on a linked sort table. But there are records that are not linked to the sort table. Is there a way to sort those entries that are not in the sort table list to the bottom?

WOW - I can't believe that worked!! I have to admit, the structure is horrible (I lied - I had to drop the contact table into the query 10 times!!) . But it looks great in a PDF report!! I may end up going to the better table design, but I'm so grateful for this forum and folks like you...

Yes you are correct, I am able to add another column to the tblTeamContacts and call it "Function" or something like that. And I'll be able to assign functions to each team. But it just doesn't look good on a form or report where each function is in a specific slot on the page. Some slots are...

Well I tried and it works, but I don't like it. If forgot to mention, that I'm using the Labels "Team 1", "Team 2" as actual placeholders with real function names. I really should have used this example instead of the in the original thread TeamID, ProgMgr, Sales, Coordinator 01, 02, 03, 04...

Thanks - I'll give it a shot. But that will mean re-structuring the tables...

I have two tables. tblContacts and tblTeams. Each record in tblTeam has 3 contacts. And I use a drop down to populate the ContactID from the tblContacts table in each of those 3 team contacts. So the tblTeams table looks like this: TeamID, Team1, Team2, Team3 01, 02, 03, 04 (These are the...

Thanks for catching that. I've been working with various versions of this same code for so long (since 2003 days) that I didn't think to re-examine it again. This was used for workbooks where I needed to always create new temporary workbook and then have a formatted workbook update links to...

Here you go. This was working fine with Office 2010, 2013 and 2016. Can't figure out why Excel is opening and closing. Unless there was something else (like security software) that was also installed... Private Sub cmdExport_Click() Dim Excel As Excel.Application Dim ExcelOpened As...

My company recently moved to Office 365 and now I'm having issues using DoCmd.TransferSpreadsheet This VBA used to transfer a query to a Worksheet and then open the Workbook DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, WbSheet, CurrentProject.Path & "\" & WbName, True Now...

I have several buttons on a ribbon like switchboard form that will open forms below. The forms open one on top of another just below the switchboard form. When a user selects a form to open, it is in focus and the corresponding button on the switchboard form changes color to the form that is...

I get the full location and name of the backend database name. \\<network>\<folder>\<BackEndName.mdb> So I figured out how to get it working with "MSysObjects" Just created a simple string for the backend and called it up on a button click. Dim strBackEnd As String strBackEnd =...

Hi arnelgp This module is giving me a Compile error: Sub or Function not defined. The notes in the module state that it's for Access 97 or earlier. I'm using Access 2016. Could that be the problem? I'm using a button to populate a text box with this code. Dim strBackEnd As String...

In the front end of my database, I added an unbound text box with a click event to show the last modified date of the database Me.txtLastModified = Format(FileDateTime(CurrentProject.FullName), "ddd, mmm dd yyyy, hh:mm AM/PM") This works fine, but only for the front end. The backend is...

Thanks for that isladogs. I may try it but I still need to figure out what's wrong with my Access program. I did some more testing and now am convinced that the Access software in my work laptop is the problem. I took the simple database that I created, saved it to a thumb drive and opened it...

There really isnt anything for me to post as a sample. I created a brand new database with only one form and created one button on that form that doesn't do anything. Then I just added a short message in the "Control tip text" property for that button. That's it. And yet it does not display...

I think my Access 2010 is broken. I can not get the ControlTip Text to show anything on any database. Even a brand new database with nothing in it except a button on a form. The Access Option in the General tab for ScreenTip style is set to "Show feature descriptions in ScreenTips" Anyone...

No it's a single form that opens another single form

I tried that but it unfortunately also restores the underlying form which I need to keep maximized. In the end I think I found a simple way of doing it by simply getting rid of all move and sizing code and then just manually resizing it and moving it to where I'd like to see it on the screen...

Thanks, yes that works. But then my form goes off the screen. I have two monitors. So setting the popup to Yes keeps it the right size, but it puts in on the wrong monitor. I'm still playing around with it, but it seems to work by putting the AutoCenter to Yes and getting rid of the...

I have a form that is set to Max on open (DoCmd.Maximize) Inside that form is a command button that opens another form that I do not want maximized. So on open event for that form, I have DoCmd.MoveSize 5000, 3000, 6000, 2500 But this is getting ignored and that form opens maximized as well...