Recent content by Wapug

I typically use the F11 key to open the navigation pane in Access, but Im using someone else's laptop. How to I open a navigation pane thats hidden? Everytime I try to use F11 it adjusts the volume. This is very annoying. I dont want to set it to stay open I just want it to openso i can look at...

Not sure I follow what you're saying here.

At the end of every month I, or someone else now, need to export a query named qMonthEndMaintenanceData to an excel workbook with a tab named qMonthEndMaintenanceData. The Excel file is already located in a folder named for the previous month and workbook named for the month. I can do this in...

I think I need to forget about doing this, Im not sure I know how to open the application, let alone begin to enter a user id or password. I can open Excel or word, but that's about it.

Thank you for the information.

So my newest challenge is creating a button from which I can open another application, and then enter a userid and password in the form that pops up for that application. I have an example below of my method to open the application, Im not sure what to do after this. Would this be specific to...

You solved my problem! I had the field on the table I was querying set to the wrong type. Thank you so much for your time!

Yes >=DateAdd("m",-3,Date()) that gives me everything from 12-05-19 back through the earliest data of 2019. When I do this <=DateAdd("m",-3,Date()) it gives me all the way back to October 2019. Im not sure what the heck the deal is

so maybe Im saying it wrong. I want my query to return all the items that have an ADDDATE that is within the last 3 months, not the ones that have an ADDDATE 3 months ago so all items in Nov, Dec and Jan.

wouldn't the past 3 months be <=3

It is February 4 and I am trying to query a table to get all items in my ADDDATE field that have been added in the past three months. When I run this query I get items with an add date all the way back to October. What am I doing wrong? <=DateAdd("m",-3,Date())

The database is only used by one person, it doesn't make sense to have it split. Is it possible to back it up with a command button, or tying a function to a button like I already have? By one person I mean, there are never multiple people accessing it, its always one person using it each day...

I don't have a split database, so IM not sure I can use that. I use this code Public Function fMakeBackup() As Boolean Dim Source As String Dim Target As String Dim retval As Integer Source = CurrentDb.Name Target = "c\backuphere" & " " Target = Target & Format(Date...

Honestly, I'm not sure what it was doing, but once I removed it the problem stopped. Now I have no idea how to backup the database, other than doing a manual backup. I cant even imagine how a function tied to a button that backs up and closes the database would corrupt it in such an odd way. Man...

I deleted my backup code. I was backing up the db at close and something about my code was causing an issue.