Search results

I almost have my project complete but I need to export a table. I was able to do it the way it needed to be through the export wizard so I think there is a way to specify this in code so that I can tie this to a button but need some help. In the wizard, I select the export to text feature...

Second question of the day, I have been able to find half of my answer. What's killing me is I used to know how to do this. :banghead: Anyways, great minds of the access programming "gods"; I want to create a simple form that allows for someone to input a number and update it to all the records...

I am trying to build a query that will count how many times a song plays and sums the listeners for that song during the month. I currently have this as a live csv worksheet that is linked to the access form. The fields are date, artist, title, listeners. I got the query to work correctly if I...

So I'm working on making an update query for a trouble ticket log (more or less) and I'm trying to set the status based on the ID number of the ticket. My table is set up like this Table name = tlbTSLog first column = ID (pk) second column= Submitted (date/time format) third column= Date...

Hello Everyone, I need some help with something. I was looking on this wonderful forum and I found some code that someone posted which was awesome because it was for creating/plotting locations in Google Earth which is what I"m planning on doing. The one thing that the code didn't have in it...

I have a question about filling null values I don't want them to show up as "0" I want it to say "not available". I have a table that has a whole bunch of licenses and license renewals. If license hasn't expired, it hasn't needed a renewal therefore leaving a blank value in my license renewal...

I have a database with a whole bunch of our out "stations" so to say. Some of those places have equipment that I want displayed on a form that I am making called "BP_cnfg_frm". Not all the stations have the equipment at them so I need some error handling for "what if the user selects something...

Hello everyone. I have a table that has a list of all the people that work for the company. I have a form that I want to use to easily remove people that have the misfortune of getting fired. I have a button that is labeled "remove" and the "on click" event, I used the wizard "delete record"...

I have a query that is ran when I click a button. the result pops up but it comes up behind the form and i need the focus to shift and have it be up front. Private Sub Command11_Click() On Error GoTo Err_Command11_Click Dim stDocName As String stDocName = "system_qry"...

So I have "launched" my application as a "beta" version in our office and the first person that tried to use it (my boss) wanted to be an original and try to "stress" test it. He has enough knowledge of stuff to get him into trouble but needs a true IT like myself to get him out. Well, a few...

Hello everyone, I have a button on my form that will open up outlook and get an email ready to send, but I want it to auto the information that was selected on the form. Essentially it is used as a notification. Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Set olApp...

Is there a way to have a window pop up to confirm whether or not the data is correct that the user is inputting? like an "are you sure you want to write this?"

I have entries in a column named flag that I am using as a "flag" ie 0, 1 or 2. I need to know how to do a query to delete the one's. Any help would be greatly appreciated.

So I have a report of different computer systems and the security updates with it. I currently started my report in design view and pulled the information from a table but it is only putting one entry per page by the name of the security update. I have no filtering and no grouping or sorting. I...

So I am tracking the amount of trouble tickets that come in. I'm tracking what is assigned and what is completed. I am trying to figure out how to make the value that's in the assigned table to be a null value (not included in a count) if it is in the completed table. Basically I have a form...

I have been googling for a few hours now and found out that I can send an email from access so If I can do that, I want to automate sending a pre-made email to an individual with everything that is on a form. For clarification, I am trying to asssign tasks to people. For instance I select...

Hello everyone, It has been a little while since I've posted but I'm running into a problem with a combo box. I have a combo box that is getting the information from a query. the query has 4 columns on it. I have 3 other text boxes that update based off the change of the combo box. Right...

Hello everyone, I am trying to build a database that will make our inventory of machines go a little bit more smoothly/user friendly. I currently have an excel spreadsheet of everything of how it is right now on my network. In this spreadsheet, I have a list of all the spaces of all my network...

I am having trouble setting the focus on my forms... I have a parent form with two labels that are coded like this. Private Sub Advisory Messages_Click() Me![ Advisory Messages].Visible = _ Not Me![Advisory Messages].Visible End Sub Private Sub...

I have a question about hyperlinks. Is there a way that I can create one based off the value in a column on a table? So I have a column in my database, that has the file path to different documents on my network (the document path is for different entries on the table). I am creating a form that...