I've set the 'Font Italic' method to 'True' for my 'scientific_name' text box control in a datasheet form. It does not render in italics. I've gone so far as to create an On-Load sub with a single command:
Me.scientific_name.FontItalic = True
The control still does not render in italics.
Im creating an update form for users that arent particularly tech-savvy, so i want them to be able to insert page breaks without having to manually insert "<br />" into the form field as it saves into the access database. is there a script or maybe just an option within access to render the field as plain text (with page breaks whenever the return key is pressed)? thanks!
View 1 Replies View RelatedI want to print text based upon the content of the field but need more than the IIF statement. For example, if the field contains an "A" I want to print "Active", "C" I want to print "Closed", "N" I want to print "New", etc.
Thanks in advance for any help. You guys have always had an answer in the past!
I am trying to view the contents of a text field in a form. The field can only be a limited size in the form, but I want to store a lot of text in the field and have it visible without having to enter the field and use the arrow keys to view the contents. Is it possible to programme a function that shows the contents of a field when I roll the mouse over it or something like that? The "Control Tip Text" is the principal of what I am trying to do except this gives a fixed value. When used in web page development I think this function is refered to as "Alt tag"
View 3 Replies View RelatedI can select memo field (configured as RichText) as rendered html:
select somehtmlfield from sometable
And have rendered html output:
"normal bold"
Or select it as html string
select Cstr(somehtmlfield) from sometable
And get
"<div>normal <b>bold</b></div>
Is there any way to produce rendered html from string?
I would like to:
select SomeConvertingFunc("<div>something <b>bold</b></div>") from sometable
And have it rendered to "something bold".
I'm trying to include some text and the contents of a date field but having trouble with the syntax.
It wont display the contents of the date variable
I have
"Effective Date = " & #" & Me.DebtPrincipalDateFld & "#
I've tried a number of combinations and searched all over but to no avail
I know how to put things on to the clipboard, DoCmd.RunCommand acCmdCopy
I just want to view the current contents of the clipboard in access 2003 using vba.
I Found this code whilst searching for a solution:-
Dim DataObj As New MSForms.DataObject
DataObj.GetFromClipboard
MyString = DataObj.GetText
But it needs the Microsoft Forms2 Object Library
This is not in the list of references, how to get it?
Or how to read the clipboard a different way.
I have a ms access table with two fields...tablename is ..."Addresses"..
Field1:= Employee_mail_id
Field2:= Leave_balance
What I need to do is that,I need to send individual mail (in Bulk) two each employee intimating their leave balances.
Is it possible to do it in vb .I want it to assign the codes in a button.
Below iss the code.
Dim r As Recordset
Dim email As String
Set r = CurrentDb.OpenRecordset("select * from Addresses")
Do While Not r.EOF
email = email & r(2) & ";"
r.MoveNext
Loop
r.Close
DoCmd.SendObject acSendNoObject, Null, Null, email, Null, Null, "Test subject", "Message body of the test letter", False, Null
I am using Access 2007 and 2010. I would like a text box (or label) on a report to autofil using fixed text from a label on a different (closed) form.
View 8 Replies View RelatedI have a form that is displaying a subform (of which source is a query). I have got the data from one of the columns in the subform going into a text box (entered in the control source) however when the field is empty it comes with a #Error in the textbox.I want the textbox is display some text is the subform value is null.
View 11 Replies View RelatedIs there a way of searching a rich text box for any text which is highlighted and then deleting that text? I cannot find an answer to this anywhere..
View 2 Replies View RelatedHi,
I'm making a form where the contents of a field is determined on the contents of another field in another form. I thought an IIF function would work, but when I tried it the contents says #NAME.
I put it in the control source.
IIF([Forms]![Frm_NewBusiness]![Page4]![Child51]="NTU",NewBusiness_Date_Issued="NTU",NewBusiness_Date_Issued)
Any ideas?
Cheers,
Ben
I have a text box in a form (unbound) and when I go to add text into it, the text carries over from one record to another but I want it to be exclusively for that record.
View 8 Replies View RelatedI go to open my Access 2000 database this morning and the contents: tables, queries, forms, reports, macros...all gone! The database file is still there, and when I go to view it's properties, I verified that it is the database that I created back in April and not somebody that overwrote my database using the same filename.
Is there any technical explanation as to how this could have happened? Or is it undoubtedly the result of human intervention?
I placed it on a network drive here at work.
I kept a copy thank god, but the copy is a couple weeks old and I'll lose alot of recent data. I've put in a request to have them restore the file from when it was last used Friday.
Just wondering what could have happened so I can prevent this from happening again.
Thanks!
sorry for the title. i didnt know what to write.
this is the situation:
i have a form where it populates a table in access (ssmdata) from an oracle table w_ssm_data). this works perfectly.
Then the form read the hole new table in access (ssmdata) to update a specific field.
Problem:
If i open the access table (ssmdata) it is sorted by the flight fields. However, when the form reads the table in order to update the specific field the table seems to not to be sorted by the flight field.
More info:
The ssmdata table in access has many primary keys (flight, departure,arrival,caterer,frequency and aircraft).
If i take a look to the W_ssm_data table in oracle it is not sorted by flight and it is sorted in the same way the form is reading the ssmdata table in access.
example:
table in access:
flight dep arr caterer aircraft frequency
1 a b a 111 67
1 a b a 222 134
2 c s c 111 5
table in oracle:
flight dep arr caterer aircraft frequency
2 c s c 111 5
1 a b a 111 67
65 t h t 252 1
when the update step starts it reads the access table as it looks in oracle. but if i open the table in access it looks sorted by flight.
thx 4 your hlp again, max
I have a new job at a company that had someone else develop their Access application. My boss has asked me to print out all of the options in several comboboxes so he can have me either add to or delete some of the items in the list.
Is there a way I can copy all of the items in the list of a combobox? :confused: These comboboxes are not bound to any tables.
I hope I have explained this well enough for everyone to understand what I am asking.
Thank you in advance for your help.
I have a group of part number doesn't come with a standard format. It is very tricky since some does come with some regular flow but some are not. Therefore i try to take 2 different sample category.
My idea is to split the LPN into 3 column eg. CIVUS (Type), 0.13(SIZE), BR (COLOR)
TRA_LPN TYPE SIZE COLOR
CIVUS-0.13-BR
AVS3.0G-B
AVSSH-2.0F-G
TRA_LPN
AGP0219-2.5-GY-O
FLRYY-4X0.75-B
V-R2-0.75-W
V-R2-0.75-Y
I want to know how to create a test box one or more than one and can search with a button. I did that but I have to fill all the text box to have a result and i want to know how to search even if i did not fill all the text box ...
View 2 Replies View RelatedCode:
Public Enum Test
a=0
end enum
How can I return a instead of 0?
I've now got my database firing off SMS text message.The only thing I'd like to improve would be the body of the text.Right now my code for my message is
Message = "Hi"
I'd like to incorporate some fields to speed things up so I could have things like..
Message = "Hi" [Customer Name]".
Hello all,
I had just created a startup screen which I wanted my access database
application to open automatically in.
On the tools menu I selected the startup option and specified the file I
wanted to appear in the startup. I used a form for this but noticed that a
forward and backwards navigation box appeared on this form, which I didn't
want. As such I went back into the startup option and unselected all the
checkboxes (hoping that one of them might correspond to the navigation box - I didn't reallt read them). I then closed down the database and opend it up again.
However, now, upon starting I only get the startup form I specified, and when
I close it I can't see my other forms and tables anywhere? I want to undo my
actions but only File Window and Help are available in the menu bar above.
Arrggghhh!!!!. I've searched for them everywhere but they all seem gone? Seems like a disaster.
Any help on recovering my work would be greatly appreciated.
thanks
Adam
Does anyone know if it's possible to edit the contents of the "Enter Parameter Value" Box...for starters, I'd like to delete the phrase "Please Enter Parameter Value" as it means nothing to most users of Access; also, I'd like to format the text that I've entered in the query itself, i.e. make it bold, increase the size of it.
Incidentally, I did go down the route of linking my query to a form but this caused problems as I want more that one user to be able to view their particular parameter value at the same time.
Many thanks
Hi.
I have created a database for an old office filing system in work.
There are 2 tables – Files & File Contents.
Table ‘Files’ has 5 fields: ID; Number (e.g. 1/03); Title; Status (e.g. Live/Closed – created a list on the relevant form using the Lookup wizard when creating the table) and Referenced To – at some point in the future all these files will be closed and this last field will show what all future correspondence is filed on.
Table ‘File Contents’ basically lists all correspondence on every file. But, some of the files have categories exclusive to them.
In the form ‘File Contents’ if someone was inputting new correspondence I would like the category lists to show just the relevant category for that file, i.e. if File 1/03 Training is selected then the 3 Training Categories will show and if File 5/03 is selected then the 2 categories relevant to it are shown.
But I don’t know how to do that…..
Should I create new tables for each of the ‘Files’ showing the categories or would one category table do?
I would be grateful of any help/advice you can give me.
Thanks.
Philip
Hi,
I am trying to copy the contents of a table with 11 fields into a new table which is the same except for an additional two fields at the end.
Any advice would be appreciated..
Thanks..
I have two tables that have the exact same structure. They both started with the same data, but each were changed separately. (Two copies of the same DB, editted separately). I need to review the data in each record and determine what has changed or if records have been added. Is there an easy way for me to do this? (Note: Each record does have a primary key)
View 1 Replies View RelatedGreetings to All,
I have one table (tblLink) that resides on an SQL Server quite a distance from me. I have another table (tblLink_r) that resides in a local .mdb file. The tables are identical except for the data they contain and where they are located. Only one index (LinkIdx=autonumber) exists. I am making sure there are no duplicate indicies in the LinkIdx fields because I started the LinkIdx field in tblLink_r at 2100000000.
When I open tblLink (remote), I can scroll to the end of the 21,000 records relatively quickly - read: little latency. Queries performed on this table similarly show little latency.
When I open tblLink_r, I also have little latency. This table has 100 records.
I need a single object which contains the contents of tblLink and tblLink_r. I have tried a UNION ALL, but this query takes upwards of 4 minutes to complete which I can't understand since either of the constituent tables only take ~.5 seconds to call up.
I am hoping someone can provide a way to speed up the UNION ALL query or provide an alternate means to combine the contents of these tables.