Problem: I want to be able to scroll multiple messages across the top of a form. I have a table (tbl_Messages) with a field called (Message). The table has multiple records. I want to start with the first record, scroll it across the screen and then move to the next message, scroll and continue through all messages in the table. I can get the first message to work but can't move to the next record?
My message starts at (message.left=700) and should end and load the next message when (message.left>14400) TimerInterval=45
I have got the following code off another thread which works great!
I was just wondering if there was any way I can link the scrolling messages to a table so rather than having to go into the code to alter the messages the user can change them through a form or in the table.
Option Compare Database Option Explicit
Public txtScrollStatus As String ' Needed for Status Bar
Private Sub Form_Load() DoCmd.Maximize ' Text for Caption of Form Me.Caption = " CAPTION MESSAGE " & Space(25)
' Text for Label on Form Me.lblScrollingLabel.Caption = " SCROLLING LABEL MESSAGE " & Space(100)
' Text for Status Bar txtScrollStatus = " STATUS BAR MESSAGE " & Space(25)
End Sub
Private Sub Form_Timer()
' Produce the Scrolling Text in Caption on the Form Me.Caption = Mid(Me.Caption, 2, _ (Len(Me.Caption) - 1)) & Left(Me.Caption, 1)
' Produce the Scrolling Text in Label on the Form Me.lblScrollingLabel.Caption = Mid(Me.lblScrollingLabel.Caption, 2, _ (Len(Me.lblScrollingLabel.Caption) - 1)) & Left(Me.lblScrollingLabel.Caption, 1)
' Produce the Scrolling Text in Status Bar of Access SysCmd acSysCmdSetStatus, txtScrollStatus txtScrollStatus = Mid(txtScrollStatus, 2, (Len(txtScrollStatus) - 1)) & Left(txtScrollStatus, 1)
how to change Access default error messages with custom messages? Like, if I enter some data in a sub form where the parent form is empty new record, default error message says that 'You must enter a value in the 'column name' field'.
I want to disable this default message and display my own error message. Now I know MessageBox and MsgBox fuctions to display custom messages, but how to disable the default message.
I have made a query with the name "Confirmation" and it is setup like this:
Name trainee Email Training John John@mail.com Tr one Mary Mary@mail.com Tr two
I also made a button in a report with the title "Send Mail" now is my goal that if i press that button automatically multiple e-mail message's will be generated with data from people in that query. So if click on that "Send Email" button i want two different mails messages generated that will be send to John@mail.com and Mary@mail.com with in the mail body their data.
I have built a report but it only displays one record. I am not using a filter. The records are being pulled from a query that should display 26 records. If I change the sort criteria, i get a different one of these records each time, but i cant get them all to display on the report at the same time. Any ideas?
:confused: I have 3 identical fe be database running each with a table called cars that has identical form values just obviously different data. I want to create a table or query to display all the results from these but whenever i try and make a query i cannot seem to work it out. Anyone got any ideas? :confused:
:rolleyes: Hmm how should I put it? I want like to create a form so I can show 8 to 10 records at a time on a single page (instead of using continuous form); so when I press the next button, the next set of 8 records will be show on the next page.
I have a subform within a form called orders and the subform gets its information from a field of item ID but i cannot enter another item if i change the information in the form it replaces the info in the subform so i lose the first item ordered i need it to be able to display orders of more than one item
Combo boxes cboTN and cboSB are on my main form. cboTN is a search combo box that updates combo box cboSB with one of 3 values (ID, IDC, or MC).
I would like to do the following:
1: If the after-update value of cboSB is ID, subform sf1 will be visible. If the after-update value of cboSB is IDC, subform sf2 will be visible. If the after-update value of cboSB is MC, subform sf3 will be visible. (only one subform visible at a time since they are stacked in one place on my main form)
2: Once the appropriate subform is displayed, is it possible to use option buttons to set the property of the subform to either Add-only mode or Edit-only mode? If so, how? (perhaps some sort of Case A, Case B scenario with the option buttons?)
If you can help with either of the above; example codes would help my novice skills greatly!
I want to make a form or report that acts similar to a "bookshelf" view showing around 4 or so images in each row. When an image is clicked on it takes you to that record. I know a report can be used to make rows but how do I get the images to display? They are stored in a folder and not actually embedded into the database. I have a VB code that displays the image on my forms but this doesn't work when it's a continuous form or report. It shows the same image until I click on that record then the image changes.
Most of my customers can use multiple addresses eg. Head office/delivery and invoice etc.
I am looking for a way to display them easily without using the nasty Record selectors in the subform (see attached "current.jpg"). Datasheet mode looks poor too so if I can avoid this I will.
Ideally would like a subform with tabs labelled Delivery/invoice etc. (see attached "ideal.jpg").
All the addresses are form the smae table, how can I display one specific record on 1 tab and another record on another tab? Am I even thinking along the right lines? Any advice welcome
Picture datatype is Attachment and it is multi-valued field so I created a query to extract picture per ProjectID and to be used as a Subreport. Query results shown below:
Now, I have created the sub report and linked it Project table. Result is the pictures add up vertically or downward where there is a big space on the right side, I want to have it from left to right or horizontally.
I have a combo box that takes its record source is a Query, this all works fine and when i click on the Combo box, I see 4 columns of data but when i select the record, only the first column displays, is there a way that I can display all 4 columns in the selected combo box, or will I have to have 1 combo box and 3 text boxes to display the data, is so how would I do that.
Does anyone know why with some combo boxes, when I grab the scroll bar and haul it to the bottom of the records, after I let go of the mouse button, the scroll jumps back up to around the middle of the combo box? Then, I have to keep pulling it to the bottom several times before it finally gets to the last record. Thanks
I have a result for a query made from four different tables for which I would like to refine the result of this query grouping multiple rows into columns.
Attached is a pdf file showing the results being obtained by my query and underneath is how the result would like it be after running the query.
Is it possible to display, in either a form, multiple images that are dynamically linked? Can they all be displayed at once 1 to many images, either by using navigation bars or scrolling through a subform? The links would be stored in another table within the same database and not as hyperlinks.
Conceptually it would be like scrolling through multiple records on a subform with images rather than alphanumeric data in fields.
Would like to know if this is possible and if so in what versions of ACCESS.
Is there add-on software that would make this possible.
I have a table which contains a number of records, each with a load of different columns. However, the new way of doing H&S splits Risk Assessments into Short and Long COSHH forms. Each experiment only has one Short form, but can have from 0-20 (or more Long). I need a way of adding a box to the form that will return all the associated Long forms for that particular record. I have tried using List Boxes and Combo boxes as well as creating a separate table for the Long Forms, but it isn't doing what I had envisioned.
List boxes appear to do what I want, however they just dump all of the results from the selected columns into the table. I only want the data for the specific record in question. For example, my first record has 6 Long forms, but a list box basically just pusts a snapshot of the table in there rather than the specific results.
All the Short and Long Forms have to be hyperlinked to the associated documents. I have successfully done this for the Short.
I have a table that contains the following;Company name, PositionID, Firstname1, Lastname1, title1, gender1, Firstname2, Lastname2, title2, gender2, Firstname3, Lastname3, title3, gender3 [...up to 50 names]
The data is uploaded to my table from a 3rd party database source via .csv file.I can capture up to 50 names, titles and gender per record. I would like to display this data in a table/array like format. I'm not too good at VBA but I can use expressions for unbound fields.I have attached a file that shows the data in a format I would like to see in Access displayed in a form.
This is not an other post about disabling the mouse wheel in access application but an other issue that is starting to really bug me... Some of my forms have a continuous subform, I can normally use the scroll wheel to go up and down the different record in the subform BUT i have noticed that if there is just a small amount of record in the subform (let's say three for example) when I scroll down the different records, they disapear in the detail header frame of the subform and only the last record is visible which I guess I don't mind to much. What annoys me is that if I scroll back up nothing happens the 2 records stay hidden behind the frame and the only way to put it back to normal is to use the scrolling bar on the right of the subform!??? I was wondering if anybody had a similar problem and if there is any solution to it?
In Access (2003) I was able to (by default?) scroll through records with the mouse scroll wheel. That no longer works. How can I have the form scroll backwords and forwards with the mouse wheel?
I've been reading threads and it sounds like MS "fixed" a feature that I was relying on heavily to move through records. I can't find a way to enable it again......
how can i stop wheel mouse scrolling on certain forms? it is ok on some forms but others where specific data is viewed can be scrolled to a blank space.
I'm using access 2000, and have built a long form. My users would like to be able to use their mouse wheel to scroll down the length of the form rather than having to click the scrollbar. is there a way to do this? (I'm sorry if I missed this being answered in another thread, I looked but did not find.)
This is kind of ridiculous, but I'd like to get to the bottom of it.
I have a form with a tab control on it, which holds all my controls on several pages. The tab control takes up almost the entire form; there's only a small area of the underlying form visible around it. For some strange reason, every time I open the form or switch from design mode to form mode, the form scrolls down a bit, on its own, so that my tabs are hidden and I have to manually scroll back up to see them. Apart from being very annoying, this may also hide the fact from some unsuspecting future user, that there are any tabs at all.
Can somebody explain this, and, hopefully, suggest a solution?
