I am required to write a code to check the positioning of a text in a string.
E.g.
"~[Admin]~xxxxxxxxx~ACK~" = Acknowledged
"~xxxxxxxxx~[Admin]~ACK~" = Not Acknowledged
"~xxxxxxxxx~ACK~[Admin]~" = Not Acknowledged
As you can see, as long as the string starts with "~[Admin]~", it is counted as acknowledged. If the "~[Admin]~" appears anywhere else except the start, it is counted as not acknowledged.
I know I'll have to use If-else statements and EOF to cycle through my entire column, but how do I check the positioning of "~[Admin]~"?
Are there wildcard statements that Access VBA can use similar to SQL's "*"?
Can anyone help please? Is there a way to position a Msg Box. Something like the MoveSize command maybe? I want a Message box to appear at bottom left of my form.
i have multpile yes/no check box i want if i check on one the name of this check box is written on another one. so i neeed a code for loop of check boxes and i need a code i.e loop all check boxes if any is true then put name field in {new field}
How to I get the screen to show the top of the form? Solid lines and xs show what is shown on the screen.
This is used for bigger resolutions. I am modifying the layout of the forms depending on the screen resolution. Also what is the highest resolution anyone has seen an access database running at?
Auto resize and Auto Centre are both already set to no. Using access 2000. There are no scroll bars on the form.
You probably think what the hell does the title mean? Well, i cant explain it more better.
What i want to achieve is that i can do a fixed position of a form in Access itself.
Example:
I start my DB ==> startup screen follows After the startupscreen ==> login screen After logging in ==> it starts up 2 forms
1 form about the Incidents that are currently running. 1 form is the main menu.
Lets say i want the main menu in the up left corner and that the form of the incidents get right next to it (with some space between it). I hope ive explained this a bit? :)
I have two forms open in access and everything is fine except the positions of the forms in relation to each other. I want the forms to be side by side when I open them but everytime I adjust them they move the next time. I've checked the proporties and they arn't on auto centre or auto anything can someone help please. Thanks!
I have a modal, pop-up Form, that I'm using as a dialog box. But, when it opens, I want it positioned on screen in a certain place, but I'm struggling to work out how to do this. What properties do I need to alter/set, to achieve this?
I'm making a database of (electronics) chips in Access 2010. These have varying amounts of pins - 6, 8, 14, 16, 18, 20, 24, 28, 32 or 40.
On a datasheet, they are drawn as per the following image:
[URL]....
As you can see, the pin numbers run down the left hand side, then up the right hand side.
I have a table, tblPinouts. This has a text field called PinoutName and 40 number fields - Pin01 etc. It also has another number field - PinCount.
On a form - frmPinouts - the pin fields will be entered via combo boxes, which get their data from a table - tlkpSignals. However, I want the form to be visual, as per the picture. I've managed to draw a chip using boxes (as this seems preferable to using pictures), like this:
However, I want to adjust the 'drawing' accordingly for each chip. This means doing several things: Extending the main rectangle downwards Ensuring there are x small rectangles around the main rectangle at set points Ensuring there are x labels inside the main rectangle at set points Ensuring there are x combo boxes around the 'drawing' at set points
How can I ensure that only the first x combo boxes and small rectangles (x=PinCount) are present when a record is loaded, and that they are arranged correctly?
I'm going to need a check box and text box. What it needs to do is if box is checked the text box becomes active and required but if not checked then the box doesn't need to be required? Any help would be appreciated.
I've got a text box that is disabled, and want it to become enabled when the user clicks the required check box.
I've got the following code, and can't see anything wrong with it, but for some reason it doesn't work. No error message appears, but the text box stays disabled regardless of whether I check the check box or not.
Private Sub Successful_Click()
If chkSuccessful = True Then txtDateAppointed.Enabled = True Else txtDateAppointed.Enabled = False
is there a way that once a checkbox is ticked (returns TRUE) can it populate the time, date and current user at the same time. ive got separate fields for this, however, nothing i have tried actually returns any result!
I am trying to use a check box to either grey out certain text field(s). For example If the box is checked true then certain fields would become available to input data. If the box is not checked it stays grayed out.
I have a form that has a remarks textbox. Depending on the options, the form will write something in that textbox. Now I want to have other options (check boxs) that I can click on which will add to that remarks textbox.
Code:
Private Sub Check27_Click() If Me.Check27 Then Me.Remarks = ("Shipping Box/Container") Else Me.Remarks = "" End If End Sub
I was wondering if there was a way to use check boxes in a form to have certain text print out. It's part of an invoice type form and there are 4 different treatments that could have been part of the appointment and the goal is to have a way to check the treatments for that appointment and only have the checked ones print out..
Basically what I'd like to do is to sum the time, and output it in the text box for the valid check box. For instance (in the picture attachment) if the 'Running' check box is ticked, Access will add 15 minutes to the 'Total Running Time' text box. If 'Running' is checked again on the next Record, Access will add an extra 15 minutes (totalling 30 minutes) to the 'Total Running Time'. On the 3rd Record if 'Down' is checked, Access will add 15 minutes to the 'Total Down Time' text box, the same for 'Change Over'.
Is it possible to have a query that will requery value of a check box based on which check box is selected? I have a form that has 5 check boxes and a text field for populating a unit price. When someone clicks a specific check box, the text field should display the unit price. I know how to accomplish this using a combo box and don't want to change the form to setup for a combo box, but rather use what everyone is currently used to. I want to add the check box is from 1 table linked to a form and the unit price is from another table not linked to a form. Both tables have 2 fields in each that will relate.
On my switchboard form, I have a check box which the user can check to make a text box (which appears in several different reports) visible and uncheck to make it invisible. The text box in the reports has the same name on all of them.
I am having trouble making this work.
I can think of two solutions, but haven't had success with either yet.
1. I could simply change the visible property of the report(s) control from the form. This works if the report is open, but throws an error if the report is not open.
Code:Public Sub showNumOrgsInReportCB_AfterUpdate()If Me!showNumOrgsInReportCB.Value = 0 ThenReports![publishZipR]![numOrgsF].Visible = FalseElseReports![publishZipR]![numOrgsF].Visible = TrueEnd IfEnd Sub
Is there a property or function I can use to test whether the report is open before I set the text box visibility?
2. Alternatively, a less elegant solution would be to run an event procedure to close all open reports. This would eliminate that issue, but I haven't gotten the code to work yet:
Code:Public Sub showNumOrgsInReportCB_AfterUpdate() Dim rpt As Report ' Enumerate Reports collection.For Each rpt In ReportsDoCmd.Close rpt.nameNext rptEnd Sub
This line: DoCmd.Close rpt.name throws a Run-time Error '13', Type mismatch.
I have a report base on my table. Here a check box. I wanna show two label text hide/show base on when check is true or false. It will be when report will be open. I have try this but nothing is happened.
Code: If AffecteAc= True Then affected.Visible = True general.Visible = False End If
Sending email using VBA & HTML. I want send email from access. Message in body contains some text and table in HTML format. I need check if email was really sent or cancelled with user.
Code: Set olApp = Outlook.Application Set objMail = olApp.CreateItem(olMailItem) With objMail 'Set body format to HTML
[Code] ...
I need some message (for example):
If error then MsgBox "Email not sent" Else MsgBox "Email sent" End If
I have value in the form call (welder) & based on the other data i will enter in form i need VBA to check if this welder is certified to do the job or not.
We need to move rich text from an Access memo field to a Word text box. So far the best Ive been able to come up with is in the code below. In this code pprs!What is a record set field of a table memo field that is bound to a text box enabled for rich text. The rich text seems to be stored as html as so I can get word to convert it by enclosing it in html tags.
Dim What As Word.Shape Set What = doc.Shapes.AddTextbox(msoTextOrientationHorizontal , doc.PageSetup.LeftMargin, 225, 534, 0) Dim sPath As String sPath = "G:Temp.html" Open sPath For Output As 1 Print #1, "<HTML>" & pprs!What & " </HTML>" Close #1 What.TextFrame.TextRange.InsertFile (sPath)
I have a form on which there is a series of text box controls relating to different frequencies. At the moment I enter a value in to each of these manually.
However, I would like to have an unbound text box where I can paste in all the values (6 or 8 of them) from excel and then press a button and they would be copied in to the individual boxes.
So far I have my design:
I'm not sure where to start with regard to the code as I don't know how to handle delimited text - is it column delimited in excel?
I imagine some sort of loop, such as a do until will be required but again not sure.