Search results

I have an Excel report. It is updated from Access and an email is generated. Now my boss wants the report in the body of the email. I do this manually now but I would like to add it to the VBA so it is added when the report is updated and email created. It can be either an Excel range or print...

That worked. I guess I didn't know that because I also try to avoid Excel imports. This time the data is already in Excel so I was importing from there. Thanks

The advanced button in the lower left is missing.

Attached is a picture of what I have available on my ribbon. Also attached are the options for the ribbon. I don't have a wizard option.

I am in the process of creating a new database application. When I first import the data I will be using I cannot find the Import Wizard to create the needed import specifications. The advanced button that used to show up in the lower left corner is no longer there. I am using Office 2010. I...

I originally had a value for the second argument. I tried acSpreadsheetTypeExcel12Xml and 10 as arguments before taking them out altogether. I have tried changing Transferspreadsheet to OutputTo but it does not give .xlsm as an available format. Is there a way to transfer a query straight...

I have a database I converted from Access 2003 to Access 2010. In this Db I have a Sub that uses Transferspreadsheet for exporting a query into an existing Excel workbook. Recently I have been trying to use Sub to export into an .xlsm workbook. I changed code so .xls(default) and any other...

I haven't tried this from a macro, but in VB if you let access create the worksheet the first time, it will overwrite the worksheet each time after that.

Thanks to everyone who gave advice on this problem. 100% guarantee on the order of the csv. I suspect the original data is kept to the thousandth of an hour in the Oracle db but is not available to that precision in the canned queries. To sum up: Csv will be imported with autonumber to temp...

I have no way to do this. Oracle db is at national level. I'm at district level. I can only get data through canned queries. If I could query the Oracle db myself, I wouldn't need to do it this way to begin with. Right now, I use 5 different queries that do not provide as much data as this one...

I can't edit it from where it came (query from company mainframe through an oracle user interface), but I could edit it before importing, if that is possible. Or could a link work?

My problem is that an employee can have two clock rings with the same Date and Time (two separate fields) with nothing in the record itself that shows which of the two were first. The only way to determine this is by the order in the csv file. Time is kept in hundreths of an hour (not minutes)...

The operation the employee rings on may be different. The type of ring may be different. But the time is the same. The last one is the live ring. Need to know what operation for the calculation with the next record. I came about mine honestly-it used to be my actual job!:cool:

Link to Bob's quote:

99.9% of the time I can. But employees sometimes do hit the clock twice in the same time period and there is nothing in the record itself to show which happened first. Only the order within the file itself shows this. If it will work with a csv file that is fine with me. I don't want to go...

How do you link to a message?

According to what I have read on this forum, autonumbers should never be used for anything except as an index. Bob Larson writes: "Do not use autonumbers for meaningful purposes. You WILL get burned at some point. Autonumbers are guaranteed to give you a UNIQUE number. They are not guaranteed...

Is there a way to import a csv file and include the row order of the file? I have a csv file that includes employee clock rings where I need to be able to identify which clock ring was first. While the clock time will usually provide this, sometimes an employee will hit the clock twice in the...

I just encountered the "Subscript out of Range" error. It ended up being a relationship to a link in another database. When I deleted the relationship, the database split no problem. Once it split, I reestablished the relationship in the FE.

Trend Function The following function works when called from VB: Function TrendFunction(yRange(), xRange(), xNew, tLine As Boolean) Dim TrendArray TrendArray = Excel.WorksheetFunction.Trend(yRange, xRange, xNew, tLine) TrendFunction = TrendArray(1) End Function