Microsoft Access / VBA Forum

Sincere thanks to Stephen Lebans for sticking with me on this one. I have learned a great deal from this. No more questions at the moment 'cos I'm off to the Carribean for a week. Thanks again Stephen.

Please can anyone advise if it is possible to display the file contents of a hyperlinked file in a report. I have a field in a table for each record which stores a hyperlink address to a picture on a separate PC. (I have done this to prevent the database becoming massive due to the number of pictures it will have to store). My problem is...

I was wondering if anyone could help me out with this. I use Access 2003 to generate certain files and then I convert them to pdf, I was wondering if anyone would know the code I could where I would have the ability to have them automatically emailed after they're converted to different sources? I can be emailed via despairingone@aol.com ...

Windows XP optimizing tricks http://windowsxpsp2pro.blogspot.com

What I would like to do is automate the manual process of copying an image from an excel spreadsheet to the clipboard, and pasting it into an access table with an OLE Object field. I want to do something like rsExcelImport.MoveFirst For Each pic In MySheet.Shapes pic.Copy 'Paste to current record

Hello every one I have a database with a form called "frmOrders" on that for I need to create a sequential number for each city apart from the original autonumber. So the table "tblorders" would look something like this: OrderID (Autonumber) SeqNo City 1 1 London 2 ...

"HumanJHawkins" <JHawkins@HumanitiesSoftware.Com> wrote in message news:i9nac.8030$Dv2.2242@newsread2.news.pas.earthlink.net... > (The SQL Group suggested I post this here... Sorry for the disconnected > cross-post) > > Hi, > > I am trying to connect a form in an access data project to a stored > procedure on our SQL server. >

Hi there, Could anyone tell me the best way to identify the current version of the jet engine on my installation of Access 2000? The reason for me asking about this is because I want to connect an HTML front end to a back end database, using ADO. Sometimes, I may want to use a jet engine, at other times, I may want to use MSDE. Is there...

Hi, I am very new to access and have been trying to create a query that searches a table for a certain time range, that being from yesterday at 8:00 AM to today at 8:00 AM. I have been able to get it to work by day but, not day and time. Is there some way to take the Date() or Now() functions and set their time to 8:00AM for example? Thank...

I've got an A2K database with a link to a table in another A2K database. This linked table contains SSN formatted with the SSN input mask. I'm trying to use a dlookup using this linked table. The criteria is matching this linked SSN with an SSN that the user will input. I have an input mask on the SSN field (on the form only) but the...

Can anyone explain me the joy of let and get. Once more, I read the explanation in the help, but did not get much wiser. I seem to learn best from examples, but I did not come across any good ones... Thank you Nicolaas ---

I am testing Win2pdf and am somewhat impressed with its capabilities with printing Access reports via VBA. HOWEVER, it does not seem capable of printing the text of my reports in their true color, no matter what the color text I tested it always prints to the pdf file in a grey color. Is there something I can do to resolve this problem? ...

In continous form is there a way to tell the name of the currently highlighted control and its value?

Hi - I am trying to hyperlink to an email address from the fields in my access table. I am sure this must be simple but I can't find it anywhere. If I set the properties of the field to Hyperlink, it just liks to a webpage. If I prefix the email address with mailto: it works, but I can't expect my users to remember to do that (and I have...

Hi, I am designing a database for a client in which It has a client table including the followings: 1-Table Client 2-Table lookupcategory 3-Table Ctegory

Here's today's quotes, from our good friend Voltaire! "Anything that is too stupid to be spoken is sung." "He was a great patriot, a humanitarian, a loyal friend; provided, of course, he really is dead." "Froth at the top, dregs at bottom, but the middle excellent." "Ice-cream is exquisite - what a pity it isn't illegal."

I am designing a simple application which has school records in one table. In a related table, I store school's comments, which essentially are feedback gathered about the school. This table has a memo field which stores the actual feedback. To display the data, I created a form, with a subform containing the feedbacks, I displayed the...

Hi, I'm using ASP to connect to an ACCESS database (db1) via ODBC. The table that I connect to (table1) in db1 is an ACCESS query linked to data in another database (db2). When I try the connection from a web browser I get the following message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) The Microsoft Jet...

Hey folks - I have a field that is a number. For new records, I want it to default to the highest value of that field +1. What is the syntax for the default value? Steve Lefevre

Given BackColor of BGC = RGB(x,y,z) is there a function, procedure or rule of thumb based on the values of x,y and z which will indicate which of black or white is likely to stand out more as a ForeColor?

Hi NG I have got an database which generates some reports. Now I want to be able to automatically generate an adobefile from access Can anyone help? Thanks in advance

1. Overview- Every Product (tbl_Product) has a single licensor (tbl_Licensor). Tricky part is, each licensor may have a sublicensor. So, a product could have a licensor or a sublicensor. 2. Examples- a. Product: Star Wars Licensor: Fox Sublicensor: Lucas b. Product: X-Men

Hello all, Currently we are implementing an Access database which has to send some (not much) data over a WAN. We are using an Access front end and an Access back end. Basicly the front end runs local, but at the end of the session the front end needs to write the data to the back end on the WAN. The responsible IT manager asked me to use a...

Hi, I have some more complicated things (for me) that I want to do in an Access survey database. I'm totally new to VBA-syntax and I don't have time to dig into it to much. I would appreciate any advice on the following things that I want to do: 1. Run an external Java-progam with control of that it must be ready before executing more...

I am working in an Access project (.adp). I have a subform that displays the data in datasheet view. When I am logged onto a computer (Win 2000) with my username, the datasheet has the correct column widths. When I logon to a computer with a different username the datasheet columns are more narrow than what they should be. I have verified...