Good day. I still need assistance with this
"After installing .NET Framework 4.6.2 in Windows8.1, I keep receiving the message 'Can't Complete Update' then it rolls back to the last configurations after the computer reboots. I stopped and restarted the service numerous times but to no avail. As...
Good day,
After installing .NET Framework 4.6.2 in Windows8.1, I keep receiving the message 'Can't Complete Update' then it rolls back to the last configurations after the computer reboots. I stopped and restarted the service numerous times but to no avail. As well as reinstalling.
Please...
Hello,
What happened is that I used a later version of MS Office (2013) on my pc to revise the macros. Then I attempted to run it on the network at my job which is using 2010. The DLL, that is was looking for was pointing to a directory on the C: drive that didn't exist at work. I tried to...
Hello TheAceMan1 and everyone else.
No, I haven't compiled first. I never went into much VBA in Excel. Funny though, when I was in school for VBA, I knew better to compile first. I guess It can compile under the version and computer that it's currently on. I let you know the results.
I'm having an issue in VBA. I have macros that have been working fine in MS Excel 2010. However, when I made minor changes such as change the path of a file location which I used MS Excel 2013, then ran it back on another computer with 2010, it worked for a little while. But now I receive errors...
Unfortunately, I'm not as knowledgeable with VBA. I'm learning as I go. This was assigned to me after the other person left the department I'm in. I have no one to assist there.
Here is a sample of the code and table.
MACRO CODE
Sub Macro1p()
'
' Macro1p Macro
'
'...
Good day,
I would like to do the following using a macro in Excel.
Read the values in column "A", find the matching values in column "E". Copy columns E -F then paste it on another sheet. For example;
Under column "A", 10032, find this value under column "E" then copy column ranges E-F and...
Good day,
I'm trying to figure out how to look up the zip code under ZipA with the other headers where the second Zip lines up next to the ZipA records. In other words similar to Zip 10474 for WK 31 & WK 30. That just happened to be a coincidence, but I would like for example 10470 to line up...
Good day,
I created a survey with several questions. I would like to query the highest number of responses from the 3 questions and display only the one with the highest. This is what I have in MYSQL;
Fields: Total:
RESPONSE 1 8
RESPONSE 2 6
RESPONSE 3 10
The fields have 'Y' for...
Hello there,
I have a question regarding charts in Excel 2010. I have data that updates weekly. I simply want to have a dividing line which separates between week 21 and week 22. The line is to always remain between week 21 and week 22 as the chart updates.
for example are the following weeks...
I have one basic question about date format. As we know mysql uses yyyy-mm-dd format. I'm trying to get the correct format using the echo command so the date reads mm-dd-yyyy.
Everything else works fine. Here's my code for the DATE field. The print date command works fine but this is in a...
Hello everyone. Sorry it too me long but I got it to work. It's so strange. For some odd reason, something told me to change the names of the last two fields. Why? I don;t know. But now it works fine. I changed the 'DESC' field to 'Details' and 'Event_Name' to 'Eventname'. Perhaps, the old field...
I'm having trouble inserting records into a MYSQL database using PHP 5 (don't have the exact version. I can insert records directly in the table itself. What makes this strange is that the code below already exists from prior coding and works fine. I used the same exact syntax for the new...
Hello all, I have a strange situation. I currently use Firefox as ny default webrowser. I embeded some code from a website for a video clip that I uploaded to my webpage. It's not a problem viewing it. However, Internet Explorer users are telling me that the video does not load and it's simply...
Hello there,
I receive a BSOD 'Process_Has_Locked_Pages'. When I run BlueScreenView, it reports that ntkrnlpa.exe is causing the error. What should I do to correct this as it happens often? I'm using Windows 7 Ultimate. I upgraded from Vista.
This happens sometimes when I'm on Youtube or MS...
Hi. Okay, here's the whole picture. The top of the report is a zip code '10013' Everything is under this zip code. The numbers on the left represent a delivery route number for couriers. So let's say zip code 10013 has route numbers 1 - 10, each time a transaction is none on a route, it is...
Hello everyone,
I'm having a tough time trying to figure out how to print across then down. What I'm trying to do is have access create a log sheet. Please see attachment. The attachment shows what I'm talking about. All new records for number 41 goes across by date then wraps to the next row...
I have a question about the warning prompts in Access. I have a make table query. Each time this query is run, it overwrites the current table. This is what I want to do. However, I receive the following;
‘The existing table ‘rmtable’ will be deleted before you run the query.
Do you want to...
Yes, I tried a multi-column report. The problem is that it does not go across the page. Basically, this is based on a query. The user makes entries in a form daily. The dates are the dates when these entries were entered. So here is an example;
Zip_Code Date
10451 9/20/2010
11238...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.