I am in the process of creating a 'how to' knowledge database using MS Access. I would like to create an input form that has a large field capable of entering both text and graphics.For example, the data inside Field1 would say...
How do I change the resolution of a monitor?
Step 1: Right click in the middle of the screen
<Display picture>
Step 2: Select Screen Resolution
<Display picture>
Step 3: Etc.
The total number of steps and pictures for each knowledge article would be different for each item. There could be 1 picture in the article, or there could be 50.
Sadly however, I don't see any field types that could support what I would like to do. So far I've only seen examples where the pictures and texts are separate and static. I'm open to using links to point to the pictures inside the text field to a remote folder. I'm even open to creating a report that takes all of the information on the input form and organizes it in a way so it looks like the example given above. Are there any scripts, controls, or template examples I could look at?
I have a text field in a form that combines a whole lot of text and a field name to create something like: "Hello [MemberName], my name is [username], how are you?"
Is there a way to put formatting in front of and behind the fieldname (similar to the way html works) that turns on bold then turns it off after the fieldname? I would also like to know if you can change colors using this same method. So the end result would be:
"Hello [MemberName], my name is [username], how are you?"
and the code would look something like: Code:= "Hello " & [red] [bold] [MemberName] [/red] [bold] & ", my name is " & [username] & ", how are you?"
I am currently using INNER JOIN and GROUP BY to narrow down the RowSource of a combo box based on the value selected in the active combo box where the code is located "onClick".
The value being selected is a StoreID, This ID is matched against the AssetRegister to find all group names, The GroupID and GroupName are then retrieved from the AssetGroup table, then finally the list is grouped on the Group ID and Group Name.
I have tested this query in SQL Server Management Studio and it works without any issues, however when I use it as an inline query to adjust the row source of the combo box it returns no values.
Here is the SQL query:
Code: SELECT AssetGroup.ID, AssetGroup.GroupName FROM AssetGroup INNER JOIN (SELECT AssetRegister.AssetGroup, AssetRegister.Store FROM AssetRegister WHERE AssetRegister.Store=7) AS ar ON (ar.AssetGroup = AssetGroup.ID) INNER JOIN Store ON Store.ID = ar.Store GROUP BY AssetGroup.ID, AssetGroup.GroupName ORDER BY AssetGroup.GroupName
And here is the inline query applied to the RowSource:
Code: AssetGroup.RowSource = "SELECT AssetGroup.ID, AssetGroup.GroupName FROM AssetGroup INNER JOIN " _ & "(SELECT AssetRegister.AssetGroup, AssetRegister.Store FROM AssetRegister WHERE AssetRegister.Store=" & StoreID & ") AS ar ON (ar.AssetGroup = AssetGroup.ID) " _ & "INNER JOIN Store ON Store.ID = ar.Store GROUP BY AssetGroup.ID, AssetGroup.GroupName ORDER BY AssetGroup.GroupName" AssetGroup.Requery
Just wondered what was everyones opinion on how I should best included a graphic file (just for the eye it has no functional purpose). At the moment i have just pasted it in but it increases the size from 1mb to 17mb.
I have read, mostly understood, and abandoned most of the KB and WWF suggestions on using images in forms. I am _this_ close to having it my way, but I can't seem to get there.
The paper form I am emulating has a medical diagram of the human body, and the interviewer circles, crosses, or otherwise marks a particular part (say head or foot) that the interviewee indicates is giving him/her pain. In order to do this on a form, I need to load a blank medical image into a field, and let the interviewer edit the image as they would on paper, by leaving cirlcles or X's.
One of the Northwind examples uses embedded images in an OLE field, and when I double-click the image is brought up in 'Paint', and I can edit. Close to what I want. I can also copy the employee photo from one record to a new record, and still edit. Closer yet. But when I try to put in a new image, I'm back to the icon-with-file-name, or 'package', or varous other ways of not seeing a picture.
Hello, does anyone know if is possible to create some forms with different graphics like round edges etc. Does Access allow this kind of utility or are we stuck to simple ones? THanks.
I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use.
In order to retrieve the information from the harddisk, I got a cable between this computer and another one.
This is my plan:
When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this?
second question:
If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer?
I have a form that is bound to a table of chemicals. On the form I have a combobox that displays records from another table of chromatograms for each chemical. There may be none, one, or multiple chromatograms for each chemical.
On the form I also have a graphic to display the chromatogram (.jpg file).
I want to have the graphic of the chromatogram update upon the change of chemical on the form. At the present time, I have the graphic display from the after_update event of the combobox. This works fine.
Is this the best way to proceed, or should I use a subform for what I'm trying to do.
I've got Form with some drawings on it and I'd like it change depending on what the user has entered in certain fields on the same form. For Example: when the user selects a certain type of item in the "Item1" field, I'd like the graphic to change (or another one appear) in the form. Basically an "If this is true, show this picture" type thing. I've been trying a few things to make this happen, but to no avail... :( Any incite anyone could give would be most appreciated.
Does anyone try to play with graphics? I use a form with 3 tabs and tree forms ..in the second form (tab) I get some numbers from a customer and in the 3rd form I got a graphics with these two numbers but there not working ..i try to get these numbers from the form direct .. I get it but I can see only the numbers and not the graphic… I try it with a query I get the numbers (Like CustomerId= forms!frm_customers!id or forms!frm_customers.id or what ever workd) I get the numbers but again when I try to see in my tab the form or the form only I can’t see the graphic// Does enyone know what happen?
how can i disable a textfield or two in a form when the textbox is unchecked also how do i add a default value for it while the textbox itself is disabled, can i get away with it by adding a default value on the textbox?
I have many rows of information i am entering in access. I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row.
I have been given the task of cleaning up an old db. One thing I'd like to do is combine 3 text fields into 1 new field. In the old db there was a form that included 3 memo text boxes, when the first one was full the user then started using the second and then the third. The relating Table fields are message, overflow message & overflow message extended.
I'd like to combine the fields into 1 and then design a new form to suit so that the memo text in the new db goes into 1 field only.
I have many rows of information i am entering in access. I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
sorry cannot explain very well
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer) If txtFireType = "N/A" Then txtFireType.Visable = False End If End Sub
Just say I want to summarise in a text box the options given in three option groups. For instance I have chosen A then B and then C and then in a text box I want to put ABC. Do I need to set up a query to do this? or do I need to write some code?
Can anyone tell me how to count (sum) text fields. My current query will search for:
1) Name
2) Ticket Number (ww*, beginning of one type of ticket)
And it works fine except that after running the query I have to manually add up how many of the ww tickets each person wrote. Is there a way to make it change the ww* tickets to a number, like 1, so that it can be added up or to add up by the persons name how many tickets they wrote. I'm using Access 2000. Thanks
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer) If txtFireType = "N/A" Then txtFireType.Visable = False End If End Sub
and so on and so forth. Is there a way Acess can break the fields out? I want 1 field with CAN, 1 field with the year, 1 field with US, and 1 field with the number (4 different fields broken by the hyphen).
I can do text to column in excel before I import, but just wondering if it can be done in Access. Thanks in advance, guys...
I have text boxes that combine two fields into one, for example the control source is =IIf(IsNull([BuckC])=True And IsNull([BoostC])=True,"",[BuckC] & " , " & [BoostC]) . For simple its just =[Buckc] + ": "+[BoostC]. I am trying to set a condition that if one of them exceeds a certain number the background color will change to yellow. I know how to do this if its only for one field but I am wondering if it is possible to do it with multiple fields?
Is it possible to use <enters> in text or varchar fields?? In this way users can easily switch to the next line instead of typing everything all together
