anoble1
Last Activity: Apr 2 '24, 03:51 PM
Joined: Jul 22 '08
Location: Alabama
-
MS Access Linking to SharePoint not showing all columns
I have a blank Access DB where I am adding a data source link to SharePoint. After I link I choose everything I want to bring over. However, when I do that I see all the items from the site with exception of a few columns. When I open the design of the SharePoint Table in MS Access I can see the column is there, but it is skipped when I look at it in data view. What can cause this? -
How to format multiple sheets in Excel?
Hello - I have made something that opens an excel document that was just exported. The workbook has 10 tabs. I wish there was someway to edit all the tabs instead of doing it tab by tab in the code. Is there a way to do that? Right now I am only able to do "Sheet1" of course.
...Code:Private Sub OpenAndFormatExcel() Dim filePath As String filePath = "C:\Users\Andy\Documents\Andy\Test.xlsx" -
Not able to paste full string from database into excel
When I am copying and pasting into excel from MS Access I am only getting a portion on what is in the table. I think it has to do with the large space/spaces is why it won't paste. When I doorCode:Replace([Field],Chr(9),"")
it does nothing. Here is what I get when I paste in excel. This is about 41 words. The whole string is 101 words.Code:Replace([Field]," ","")
"I gave the Persons the road numnber and street... -
My fault there. Later once I get this figured out I need to add another field and do the same type thing beside the “Type” field -
Please see the attached. Right now I am having to separate in the Group By in the Crosstab query with the criteria Car or Truck.
On the right in the attachment you will see Proposed where I would like to Sum those 2 selections in the "Type" field.
...Code:TRANSFORM Count(tblInformation.[Dealer Name]) AS [CountOfDealer Name] SELECT tblInformation.[State] FROM tblInformation WHERE (((tblInformation.[Type])="Car"
Leave a comment:
-
How do you combine 2 items in a Group By while doing a Crosstab query?
I have a Crosstab query that I am working on. So, for my Column Heading I want to use this 1 Field that has 5 options in it. Right now if I put in the Criteria "Car" or "Truck" I get 2 columns, 1 column for car and 1 column for truck. Is there a way I can just total those both up in 1 column. So the Field will show a total of Car & Truck instead of separating it? -
How to Export a Linked Table to Excel
This is something that was needed that I will post on here in case others have use for it.
Code will create a new folder with Today's date and file name, then export the table to excel. Then it will open and format the excel file after it is exported by freezing the top row, and will autofit the column width.
Probably not the best written but works for me.
...Code:Option Compare Database Public Function exportToXl()
-
With the 2 tables I can see there are 2 records that are extra on one table and 2 blank spaces on the other table. But after that on the append, I get zero.
I need 2 tables because one of them is going to be a table to put notes in that stays. The other table will be updated daily with new records. Am going to tie that field to both tables so I can add notes to the new records if I need to. I don't want to lose by notes I put in and don't...Leave a comment:
-
Hmm. Are you referring to line 3 on the equal sign?...Leave a comment:
-
Append Query trying not to add duplicate records to new table
I am throwing a blank on an easy one.
tblHours has 2 less records than Machine Hours table.
I would like to say if [Machine Hours].[MODSER#] has a record not in tblNotes.[MODSERIAL#] then add it. I don't want any dulicates. Keeps saying there are zero records to add when there should be 2.
...Code:INSERT INTO tblNotes ( [MODSERIAL#] ) SELECT [Machine Hours].[MODSER#] FROM tblNotes RIGHT JOIN [Machine Hours]
-
Is there a way to do a Date Difference with a Date Serial?
I have a table that I am using the run a query. The date format is yyyymmdd. I can't get the DateAdd function to work. I am doing aand comes back blank with records from 3 years ago till today.Code:=DateAdd("d",-100,Now())
My question - Is there a better way to do this? If you have a date that is in yyyymmdd how do you tell the query you want to only see records that are older than 100 days from today? -
anoble1 started a topic Trying to import csv to excel - why isn't it looking for column names instead doing F numbers?in AccessTrying to import csv to excel - why isn't it looking for column names instead doing F numbers?
When I am trying to import a .csv into a table in access somehow it is wanting to match my columns not by name but by F1-F41 or the excel sheet. How can I get it to only match on column names that are defined in the excel sheet on the first row? This is a .csv file I am trying to import.
So right now I am just having excel create it's own table so I can see how it is importing.
...Code:Dim strfilename As String
-
Export Single Query to 25 Tabs in workbook
I have a query I would like to put into 25 tabs.
QS36F_TOPCUSTS. F2 is the employee number. Each employee has about 75 companies assigned to them. I would like each (F2 "Employee") to have their own tab of companies. How...Code:SELECT QS36F_TOPCUSTS.F1, QS36F_CMASTR.CU_NME, QS36F_TOPCUSTS.F2 FROM QS36F_CMASTR INNER JOIN QS36F_TOPCUSTS ON QS36F_CMASTR.CU_CUS = QS36F_TOPCUSTS.F1; -
DateDiff will not return anything?
Hi guys,
I am trying to return the number of days from a start date and an End Date. my data source has the format yyyymmdd or 20190101. I get a #Error when I run the query.
Is it because my source is in that format and won't work?Code:Expr1: DateDiff("d",[QS36F_PARTHIST]![PH_DTR],[QS36F_PURORD]![PO_DTR]) -
MS Outlook - VBA on Inbox and new emails
I need some help. I have never done VBA in Outlook but wanted to delete new emails based on the subject line.
I would like to look for email subject with "*MISSING PART*" in the subject line to be deleted.
I don't even know where to start. Different than Access. Ideas? -
Query - How to filter criteria from tables
See picture.
I have some fields under criteria I would like to show. Example I would like this query to pull all part numbers in these 3 tables on this main query. What am I missing or how can this be done?
How can i make this query show all the records in all those tables? Each table has about 15 records (15 part numbers)
... -
Not an update-able query error with subquery
Getting this error when trying to do an update query.
I have 3 tables that I...Code:UPDATE tblNames INNER JOIN (qryBatteryBonus INNER JOIN tblEntrys ON (qryBatteryBonus.Month = tblEntrys.Month) AND (qryBatteryBonus.Year = tblEntrys.Year)) ON (tblNames.Salesman = qryBatteryBonus.BH_SMN) AND (tblNames.NameID = tblEntrys.Name) AND (tblNames.NameID = tblEntrys.Name) SET tblEntrys.InterstateBatteries = [qryBatteryBonus].[Test];
-
Found an error that popped up today that could be the issue.
What does that mean?...Leave a comment:
-
Field cannot be updated error
I have been trying to trace this error for a couple of days but have not had any luck. I suspect it has to do with the recordsource of the form. I tried to debug it from the combobox but it happens before it does anything. As soon as you type the first letter in the box it throws the error. If you click Ok it continues and works.
Here is my recordsource from the form. When I hit run I don't get any errors and I see all the... -
I need to query that table and when I query that GAL it takes like over a minute. If I had a button that could be ran every few days to update that Local table from an end user than that would be nice.Leave a comment:
No activity results to display
Leave a comment: