Search results

I was just curious if anyone here has ever tried to program an app for an Android phone. I have recently found out that I will need to do this and am having a lot of trouble with it. I downloaded the eclipse software and the SDK available from Android. I have also tried to follow the...

I'm trying to create a form in Visual Studio and have run into something I can't get to work. I'm trying to set up a label to reference all the results in one query. I have everything set up, but I have to put Rows() in my variable and I have to put a number in the parenthesis or it won't run...

Does anyone know if there is a way in Access to create a text cloud? I currently have a database that contains service calls for one month and the call texts that go along with them. I would like to create a text cloud that will display the phrases that are used most often in call texts. Is...

I have two questions. The main question is this: Is there a way to prevent users from making a shortcut to a database? I have my database split and I want users to copy the front end and paste it on their desktop. However, there is a high turnover rate among the people who will be using this...

Okay, thanks so much for the information. I appreciate it.

Is there a way to set the control source for an entire form through VBA? I have a database that was set up just as an archive file, not intending to have any forms or reports in it. It was simply to house tables containing data from previous years. My main database just copies the table over...

Thank you for the advice.

I hadn't thought of that. Thank you for the suggestion.

I got it to work :) This is what I have. If there is a better way to do this, please let me know. Dim r As Recordset Dim email As String Dim rd As Recordset Dim ActionsDue As String CurrentDb.QueryDefs("PeopleToEmail_qry").SQL = "SELECT DISTINCT tblPM_Equipment.PrimaryAssignee...

This is what I have come up with so far. However, I keep get the "too few parameters" error message. When I hit Debug on that message, it highlights the line of code where I try to set my second record set. I'm trying to limit the second record set to the current record in the first record...

I have a question for you. I am setting up a database to track preventative maintenance required for testing equipment in our repair shop. Some of my associates would like to be able to send e-mail notifications via the database when maintenance is due. I set up a query to show the people who...

That worked great. Thank you so much.

I have inherited a database that is used to track equipment that comes in for repair. One of the fields in this database is a memo field that lists the parts that are replaced on a piece of equipment. It has been requested that I leave this field as it is. However, I would like to regulate...

Unfortunately, there are a few records where the part numbers is listed as 123456789 A. Most of the time they list the parts this way 123-456789-000-A, but there are a few occasions where they used spaces instead of dashes.

I have inherited a database where technicians track equipment that has been repaired. In this database, there is a memo field where the technician lists all the part numbers he / she uses to repair the piece of equipment. This field was never reported against and was strictly used for...

That works great. Thank you so much for your assistance. I sort of got the multiple select to work with SharePoint. I wound up saving the SharePoint directory like I would map to a regular network drive. Then when I use this function, I just click on that directory and the multiple select...

I had a question about the ExcelFunctions module. I currently have it set up to import every other line starting from line 2 from the Excel sheet into the database. The reason for this is that the people who generate the Excel files show the column headings above each row of data. I just...

I'm working on a database that will be used when maintenance needs to be performed on our test equipment. So far, I have a form set up for the associates to track when a maintenance action has been performed. The top section of the form contains basic data about the part and there is a subform...

I have an Excel spreadsheet that is being used to create a query file for a program called DataQuant (which I can open using this command: Call Shell("C:\Program Files\Rocket Software\Rocket Shuttle\Rocket Shuttle for Workstation\eclipse.exe", 1)). I am using the below code to create the Query...

It originally took me 22 minutes to completely run through this process as it was written originally. When I made the modifications you suggested, the process ran in 14 minutes. I just heard back from my co-worker and yesterday this process took her at least 3 hours. Today, after I made the...