Hi,
I have been trying to get an image to open from its location.... but it keeps trying to open "C:C:example.bmp" instead of "C:example.bmp" does anyone know how to take out the first directory location tag automatically?
Any help will be great!
Thanks.
Access 2010:
The database I'm working on stores label images, or better stated, it stores file paths where the label images are stored. These paths are used in reports and forms to view the label images within the database. What I'd like to do is to create a "save" or "email" button that will allow the user to select a location to save just a copy of the image in jpg format. I realize that it is possible to imbed the jpg image into a report and export it as a pdf. What I'd really like to do is find a way to save the image (perhaps by copying it from the path in the database and simply relocating it) and preserve the jpg extension if that is possible.
I am also aware that there are third party applications that will convert pdf reports into jpg files however network restrictions keep me pretty limited in my ability to download third party software.
When creating an incoming inspection database, I want to set it up so when I am in a form to add data, I want to have a command button where I can pull up the associated CAD drawing based on part number and drawing number. I would like to enter the directory location into a table so I could change it if I need to.
So basically I want to go something like this:
.tblDirctoryLocation
txtDirectory
.tblProduct
txtProductName
txtProductNumber
txtProductCADNo
These tables would not be related to one another as there will only be one record for the directory location and multiple records for products.
Somehow I want the db to assemble file location like this:
“EQuality_DirectoryIncoming” & “ProductNumber_” & “CADDrawing” & “.pdf”
End result: EQuality_DirectoryIncomingProductNumber_CADDraw ing.pdf
Is there any way this could be done?
I am working on a form as a user interface. I have added an picture to the form and it will change, according to the selection in the combobox. It looks small, and not clear because of the size, and each image has different sizes. I would like to know if there is a a way that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes. I was thinking that it could be something in the on click event.
View 7 Replies View Relatedi had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text
i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.
I have a form that I would like to update a picture on using VBA. The source of the picture path is in part a query that is not bound to the form. So far I have the following code that is pretty much working, but with a couple flaws.
Code:
Private Sub Form_Current()
LoadDefaultPicture
End Sub
Sub LoadDefaultPicture()
Dim db As DAO.Database
[Code] ....
This is working. However, when I change the record the picture flashes the current picture once and then loads the new picture. It is like it reloads the current picture then loads the new one. I'm hoping there is a way to get rid of the flash.
Also, the code fails here:
strDefaultPictureName = rs.Fields("AttachmentName")
When the query does not return a record. I can definitely fix this by adding an if statement to check for a record, but I'm kind of perplexed at why it is failing at that line. I would expect it to assign an empty string to that variable name and then fail on the next command where I try and set the ".Picture" property of the image.
Hi all ,
Can anyone tell me about how to embedd image in image control using imagelist.
I added the 5 images in imagelist at design time and added the following code.
image.picture=imagelist.listimages(1).picture
but iam getting error.error no :2110,cannot open the file .
thank u,
Siva
Hi guys,
I'm in desperate need of help and want to know if it is possible to load an image on a form once a hyper link is created.
For example, I have a form with a hyper link to an image created, currently, when you click on the hyperlink, it opens the picture in the browser, can you change it so that it loads teh image embedded into the form instead of loading it into a browser?
If so, how?
Thanks
I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.
Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub
Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.
Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Hi folks,
I have 50 locations spread over the UK and each site has a red, amber or green status based on several criteria. What i want to do is have a form with a map of the UK and have each location represented on the map with it's red, amber or green status based on coordinates in the country i guess.
Thanks
Mark
How do I find the file location of the current database?
View 2 Replies View RelatedHi all.
I have been working on an Inventory Database over the past few weeks and I have run into a problem.
Currently I am designing the database to use the common way to calculate on-hand inventory levels (Latest Stocktake(cycle count) + Received - Used). The problem comes when I am trying to calculate this value.
A solution that seems to work is to take stocktake for a given product using the ProductID and date. I have a child table linked to this one to show the quantity and locations of the product. However, with this method, I will have to count the inventory for every location the product is in when the stocktake is taken. This method may work, but accidents may happen and an employee may forget to count both locations when taking stock. Then current inventory levels will be way off.
Is there an easier or more efficient way to do this?
Table Design
-=-=-=-=-=-=-
tblStockTake
StockTakeID
ProductID
Date
tblStockTakeDetails
StockTakeDetailsID
StockTakeID
Quantity
Location
Okay trying to get at an mdb that I have copied from the live network drive onto my own machine. Each time I try and look at a table in design or data mode it keeps trying to locate the table on the network drive.
How do I tell access to look at the copy on local drive? Using version 2003, and don't remember this issue from version 97.
There is probably an easy answer to this but I can't find an exact answer searching.
I have an Access 2000 database with the back end stored in a separate location. If I want to move the back end data file to a different location on the computer, how do I change the link (file path)?
The only way I can figure out is to delete all of the old links and relink them from their new location.
Isn't there somewhere that you can just change the path name to the entire back end in one easy step?
Thanks for any help.
Hi all....
Preface: Main table called tblMain. Here are three of the fields that I am interested in setting this up for.
tblMain
Field 1: [IncidentDate]
Field 2: [Address] (actually street numbers)
Field 3: [CityStreet] (actually street name via lookup field off another table)
Query based of the above tables.
What I want to query is this:
If location has an entry on July 4th, 2006 then it counts it, if the same location has has another entry it counts it. If it only has a incident on July 4th, 2006 an no other prior incidents do not display it... Does this make sense.
So it would look something like this in a report generated off of the query.
07/04/06 123 Main St
07/03/06 123 Main St
05/05/06 123 Main St
07/04/06 125 South St
07/02/06 125 South St
06/22/06 125 South St
Thanks
R~
hi everyone,
I have a table with persons age and location and I want to generate a report of all persons by location and age group. The age groups are 0-9, 10 - 19, 20 - 29..., 90-99.
The location codes are 10,20,30,...90,99.
Any suggestions?
Many thanks
Will.
I use the Active X calendar control 10.0 in a number of forms*. The mscal.ocx file is in c:Program FilesMicrosoft OfficeOffice 10.
(*In the calendar's Properties it says it is "MSCAL.Calendar.7", which I think is just MS's way of confusing people.)
After splitting the deploying my app, it appears lots of my users either don't have version 10.0 or it is stored someplace else; for example, in C:WindowsSystem32. Because they don't have the correct version/path, everything crashes.
So, how can I easily determine whether users have the right ActiveX in the correct location?
The Microsoft web site says "To distribute your component as part of a Visual Basic application, you can use Package and Deployment Wizard". I don't have that wizard in my version of Access (2002 SP3 on Windows XP), so that's not an option.
Microsoft also says to "To enter the base address for your component, open the Project Properties dialog box and select the Compile tab. The address is entered in the DLL Base Address box, as an unsigned decimal or hexadecimal integer. The default value is &H11000000 (285,212,672). If you neglect to change this value, your component will conflict with every other in-process component compiled using the default. Staying well away from this address is recommended." It seems to make sense that I put the mscal.ocx in the database's directory on the server to serve as the "base address", but other than that this option scares the heck out of me.
Does someone have any suggestions how to easily ensure users have the right ActiveX version on their computer - and in the correct location? (I'm not a super-coder.)
As always, thanks
Christine
Hello all,
I have a text box that allows users to type a letter to a customer with a listbox next to it. The listbox is filled with data such as the customer's name, address, etc.... When the user double clicks an item from the list box, it should insert the appropriate data into the text box.
The problem is, is there a way to determine the current cursor location in the textbox so I know where to add the data?
For example, the cursor location has been determined before the text box lost the focus and now i am inserting the apporpriate data:
Textbox = left(TextBox, CursorLocation) & DataFromListbox & right(textbox,len(textbox) - CursorLocation)
Thanks for all your help.
hi,
can i set the location of my windowform?
i have created a dummy tabstyle form. It exsist out of 3 forms. Those forms are on top of eachother. is there a way that i can lock the windowlocation. for example: form.left = 0
or someting like that?
thanks
From a command button what would be the code to copy a file from one location to another i.e copy c:datasalesdata.mdb to e:databackupsalesdata.mdb
Jabez
How I can change the database location? I have a split database. THE LOCATION ARE IN CATABASE1 NOW i WANT IN C:dATABASE2. iKNOW DATABASE UTILITY AND LINK TABLES, BUT FORM SOME RESON i CANT CHANGE. THANKS EVERIBODY FOR YOUR HELP.
View 1 Replies View RelatedI use Access 2013, and have an Access Database in which one of my Tables is linked to a SharePoint site (SharePoint 2010). The database is in my computer, but I will be required to shift it into another computer onto a network drive. I want to know if doing this will affect the table's link or data exchange between the table and its linked list on SharePoint
View 4 Replies View RelatedDuring a system upgrade, our database was migrated to a new server. How do I change Access 2007 to link to the new location instead of defaulting to the old location?
View 2 Replies View RelatedI have a list of locations in a sub form where a chart has been and the last record is it's current location. I'm generating a building report which should show a list of charts on that building, but it also shows it on old locations. So in the example, it shows for building 43 and building 83. I just need it to show on 83, how to accomplish this.
View 2 Replies View Related