I dont know VBA. Is there a way for me have the macro to send the email where the report would be in the body of the email and not as an attachment? I currently use the "send-object" command and send it in html format , Please advse. thank you very much ...
Here's what I want to do: The user should be able to enter a new "sale" record with some basic information (who's buying, etc.), and then add items to that sale (like a shopping cart). There's one master "Sales" table and one "SaleContents" table, that look like: Sales: int ID, name of person buying, etc. SaleContents: FK SaleID, Ite...
This appears to be .NET framework code. ByteImage = System.IO.File.ReadAllBytes("C:\my folder\my file") Since I am not using .NET, is there equivalent code in VBA (Access 2007) that will do the same thing? ...
Supporting users who use MS Access as a front-end for viewing some Oracle tables at our intstitution. Typical use is to write ad-hoc queries with the Access querybuilder, and also they LOVE Access because it lets them build printable reports without having to submit to the lengthy & expensive programming-request process through our tech...
hi my C# winforms program work's on database access 2007 this database became swollen. is there any way for compress and fix this database by C# code ? if i do it manual (through access) it became less swollen thank's in advance ...
Is there a way to view A PDF file in access? I am storing the path to the file in the database and am able to open it from a button in the database, but I'd like to be able to show a preview of it as well. ...
I am about to release some reports in Access 2007 and I need to lock down the Queries so that no one can change the queries does any one know how I can do this in Access 2007? Please Note: Simply adding a GUI and hiding the "database window" is not enough as people can still get in with the right key stroke etc. ...
Guys...if I want to run a button click event that takes a list box and uses the ID field that is in the listbox in a SQL statement in VB, then is it me.MyListbox.selected or me.MyListbox.value to get that value? for some reason I have tried both and neither seem to be working. .value returns an empty value, and .selected generates ...
I have a database that is used in a mixed 2003, 2007 environment. I have some minor functionality that uses 2007's new TempVars feature. If it is a 2003 user, it isn't a problem for them to not have those features. How do I write my code so that it will compile and run on Access 2003. I have tried on error resume next but this doesn't w...
I have been importing the same type of excel file into MS Access 2007 and have had not problem until recently. The message says I have a key violation when I am overwriting a table. There were duplicates in the excel file (primary key field) which I deleted and I checked the excel file meticulously. I have reimported and its still show...
Hi there, I can successfully create folder directories with commas included in the name using the FileSystemObject The problem that I am having is if a comma is included in the directory name I cant then use 'CopyFile' with this path name. The sub routine I use is below Sub CopyFiles(sDoc As String, dDoc As String) Dim fso As New File...
I have a MS-Access 2007 client using a MS-Access 2003 MDB frontend and backend files. Disabling the ribbon bar shuts out some unwanted behavior (such as navigating records... even though I have 'Record Selector' set to false, it still persists in the Ribbon bar), but when I do this, then the printing options are lost when in the print p...
Consider the following table: ID nonUniqueID value total -------------------------- 1 12345 5 x 2 12345 10 x 3 789 20 x 4 789 5 x I need to make a query something like this (psuedo SQL), which will work within Access 2007: UPDATE table SET total = SUM(value) WHERE nonUniqueID IS SAM...
I am working with a fairly large database of information. I need to use a distinct set of values in one saved query as the parameter in the 'where' clause for another query. What is the best way to iterate through the result set of distinct values? I am fairly new to Access and VBA. ...
I am importing data (Pdf, Xls, Doc, Txt) into an Access 2007 Database....then I convert it to Base64 (called strData below). If the original was about 150K or less then I can save the converted file (about 250K characters) into a memo field. However, if the original is larger than that then the code gives me "run-time error '2498': An ex...
I'm trying to LEFT OUTER JOIN two tables and then INNER JOIN another table together in Access 2007. SELECT RestaurantName, StreetAddress, City, State, Zip, RestaurantWebsite, MenuLink, RestaurantTimes, PhoneNumber, PictureTi...
I have a table where I need to get the top n highest amount items for each Category. Category Item InventoryCount ------- ----- ------------- Beverage milk 3 Beverage water 2 Beverage beer 9 Utensil fork 7 Utensil spoon 2 Utensil knife 1 Utensil spork 4 My desired output is the highest Inventory...
Is it possible to have an ODBC connection to a MS Access 2007 database on Windows XP without having any other database engine (i.e. Microsoft.ACE.OLEDB.12.0) installed? I am using the following connection string which works on Windows 7 but not on Windows XP. (There is only *.mdb option in Data Sources (ODBC) control panel in Windows XP...
I have a access database that has customers, products with different product lines, prices etc., and each customer has their own specialized price sheet. I'm trying to make a way to do invoices based on this database, so that when you select a customer it fills out the rest of the customer info; city, state, zip, etc., and know what pric...
I know that you can make a add-in to communicate with web services but is there one built that you can download and go? ...