Computer Support Forum

MS Access text field orientation

Question: MS Access text field orientation

I am currently building myself a stock database system in MS Access 2000. On one of my forms and reports. I want my text in a textbox element to flow vertically. I have found a method to do this, but the text runs the wrong way. Would it be possible for my to correct this in anyway? If so how would I do it?

Relevance 100%
Preferred Solution: MS Access text field orientation

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: MS Access text field orientation

Help! Anyone? Please.

2 more replies
Relevance 77.49%

I know the Include Field will include part of the text from an Include File if it is in a bookmark. The format is {IncludeText "File Path" Bookmark}. I have 2 files: Source and Target.

Source is a form template. I included a Text Form Field and gave it the bookmark AA. I also included other text in a "normal" bookmark, BB.

In Target I have 2 fields: {IncludeText "C:\\" AA} and {IncludeText "C:\\" BB}. The text from BB shows up, but the one for AA is blank.

If I go into Source and look under Bookmarks, both AA and BB are there.

BTW, I have tried it with the Source form both "Protected" and "Unprotected" and it didn't make any difference.

Any idea why this is happening, and more importantly, any idea on how to make this work? If not, it seems like a real bug in Word 2003 as they are both definitely considered to be bookmarks.

Thank you,


Answer:Word 2003 - Include Text Field - Not Including Bookmark Text if in Form Field

Thread reopened for user to post solution.

3 more replies
Relevance 72.57%

Hi all, been away for a long time.My problem is this :I have an MS Access 2000 database listing song titles. I have built a form and added control buttons for "First Title", "Last Title","Next Title" and "Previous Title"These four controls work successfully, going to the denoted record as required with no problems.THE PROBLEM:I have tried to add a combo box using the "TITLE" field only from my form data. Song titles often include the character apostrophe ('), example...."Don't Cry For Me Argentina"When I click in the combo box and select a title with the ' in it I get a runtime error 3077 and cannot go to that record. Titles without the ' in them display in the form with no problem.MY QUESTION:Is there any way to display the song title correctly (including the ') without the combo box treating it as a rem and thus throwing up the runtime error?My db has a number of fields giving info on the song and display on the form.Operating System Windows 98SEProcessor Intel 600E CoppermineRAM = 256 MbHDD 40 GbMS Access 2000 is the db.Grateful for any advice.btw....I only have a very limited idea of Visual and Access Basic !!!

Answer:MS Access 2000 text field characters.

I would do a search of the MS knowledge base, refining it to searching Access 2000.

3 more replies
Relevance 72.57%


Help, I am a novice at Access 2010 and am attempting to write a custom [COLOR=green !important][COLOR=green !important]database[/COLOR][/COLOR] from scratch.
How do I get data from multiple text fields to show up combined in a seperate text field. I want to combine the First, Middle Initial, and Last Name fields so they will be combined in a seperate field I named Complete Name.

I typed the following into the Validation Rule of the Property section for the Complete Name text field however, the Complete Name text field remains blank in Form as well as Table.

Trim$([FirstName] & " " & [MI] & " " & [LastName])

I hope I explained this correctly as I am relatively new to Access. Can you give me any advice or suggestions? Thank You


Answer:MS Access 2010 Text Field Question

There are 3 ways to do this.
1. This method uses a query to combine the data, but it will not store the combined data and it will not refresh on it's own if you add or change the data.
2. This method combines the data in and Unbound field by making it the Control Source of the Field. This will not save the data to a table but will automatically update.
3. This method uses VBA in the After Update Event Procedures of the 3 fields and will automatically update the data and also save it to a table if required.
The choice is yours.

1 more replies
Relevance 72.57%

I want to combine a text field and a date field into one field to use as a reference number. IE 'Mil - 05/11'.

I have got a field with the standard short date format 29/05/2011 (that I have to keep) and I have created a second field with the same date but formatted to a "mm/yy". When I concatenate the Operater Ref field "Mil" to the Date Ref field "05/11" I still get the full date format IE Mil - 29/05/2011.

Answer:MS Access Concatenate a date and text field


If you are creating the second field in your table, go to design view and change the Data Type to Text then try your concatenation. I built a mini-table and queried it and this worked for me... hope this works for you!

19 more replies
Relevance 72.57%

I am trying to insert an address and slide the text up so I do not have to see the blank lines plus extra space.

Answer:Access - slide text up if blank field

7 more replies
Relevance 72.57%

I have a memo field in my application that the user needs to put a lot of text in with numbered items that require indentint. The finished report looks awful because she is forced to space between the numbers and the text instead of a clean indent. I am using the runtime version of Access 2007 field. I need find a text editor that will hold formatting and keep it in the field for the report.

Answer:Text Editor for Access 2007 Field

8 more replies
Relevance 72.57%

My Access 2007 database contains records with a text field of up to 255 characters. these records are being imported into a system that allows up to 39 characters for this data. I'm seeking help to create a query(queries) or macro(s) that will create additional records with each one containing the next 39 characters in the text field. For example, a record contains 125 characters in its text field. I need to end up with 4 records such that record #1 contains the first 39 characters, record #2 contains the next 39 characters, and so forth.

Answer:Parsing text field in Access 2007

6 more replies
Relevance 71.75%

Is there a way in Access to have a report with data like BB900, 10/1/2006 behind a barcode? Then have a form with two columns. The user would scan barcode. The first column would hold the information to the left of the comma, and the second column would hold information to the right of the comma.

Answer:Access Database Text Field Seperated By A Comma

6 more replies
Relevance 71.34%

I created a form letter as an Access 2007 report. The only field is [first_name] from a query. The first line reads, "Dear Joe (or whatever [first_name] is). I want a comma after each name. I tried =Trim([first_name] & ","), =Trim([first_name) & "," and every combination I can think of. Every permutation returns Dear #Type!. How can I get Dear followed by the name and a comma? Thanks!

Answer:Solved: Access 2007 Trim and field text addition

14 more replies
Relevance 71.34%

In Access I have a field "Age" which is formatted as text.

I import a txt file from Excel where the Age data contains some ages and some txt such as "Staff".



How can I force the ages to have a leading zero so that they appear in sequence in reports?

I know if I format the Age field as Number they appear correctly sorted in reports, but then I can't use text as well in that field.

Thanks for your help,

Answer:Importing txt file into Access text field with leading zeros

It might be simpler to modify the input data from Excel, so they are correct, or perhaps a little bit of vba code might be useful to whip through that field's data to modify those records which have a number to have leading zeros.

2 more replies
Relevance 71.34%


For a 'Yes/No' data type, my MS Access 2013 does not allow me to change from the default 'check box' to the 'text box' option under lookup field properties - display control. It was originally able to but I think something has happened to it.

The problem is not table or database specific as I have tried other tables and databases. I even reinstalled MS Access to make sure it was not the application's fault. It still exists and I don't know what went wrong.
Could someone please advise?

Thanks a lot.

Answer:MS Access 2013 Yes/No Lookup field properties can't select Text box

lycen, welcome to the Forum.
I am not sure how you managed to change it to a text field, as you can't do it in Access 2007, only to other types of "On/Off" type fields

3 more replies
Relevance 70.52%

This is for the database:
I am trying to use the tct codes in a combo field on the Form and have a different field backcolor for each one. So I missing something just not sure what. Thanks Alan

More replies
Relevance 70.52%

Hey there, long time reader first time poster!

(If you know of a great advanced tutorial on Access, please let me know. I know how to set up the basics, now I'd like to know how the program really runs)

I'm currently working on a form that allows users to search for equipment. The category of the equipment is slectable through a combo box, and the searched text is entered in a text field. The results are displayed in a list box.

What've I've tried is using a 'Find' button to enter this sql query into the RowSource of the list box:

Private Sub Equipment_Find_Click()

Me.Equipment_List.RowSource = "SELECT Equipment.Type, Equipment.Manufacturer, Equipment.Model FROM Equipment WHERE (((Equipment." & strQuote & Me.Equipment_Search_Category.Column(0) & strQuote & ")=" & strQuote & Me.Equipment_Find_Text & strQuote & "))ORDER BY Equipment.Type DESC;"

End Sub

The result i get is a pop up window with a text field. If i re-enter the text in that feild the info pops up nicely. What am I doing wrong, and how do i get rid of that popup?

Answer:Access 2003: Search criteria based on combo box and text field

12 more replies
Relevance 68.06%

I support a software program that has a proprietary menu item when you right-click a calculated field. It has been this way for 10-15years and has worked in WinXP through Win10 with never an issue. This past week I had 3 different customers tell me that when they right-click one of these fields to access what is normally the Cut/Copy/Paste/ menu that also includes our menu item, they are now getting the Windows default cut/copy/paste/Right to Left Reading order/Show Unicode control characters/ etc menu. The only thing I can think of that they all have in common besides these are all Window 10 64bit pc's, is that they all have one update to Adobe Acrobat (17.012.20098).
I was able to resolve for a moment on two of these workstations by having the user go into Language/Advanced settings and actually selected "English (Unites States) from the "Override for Windows display language" even though that settings is implied by the "recommended". But after the pc was turned off over night and back to it the next day, the problem is back and that setting is still selected. All language and regional settings on all the pc's are defaulted to English/Unites States. I do not know what other avenue to go in. Could something hae been switched on or off in Windows (by this Adobe update perhaps?) that would make the context text menu switch to Windows text default right-click menu?

Any help is appreciated!

More replies
Relevance 68.06%

I need a date field changed into a text field of YYYYMMDD so for example the date of birth field is 3/17/1953 and I need that converted to 19530317 in the Excel spreadsheet. Thanks.

Answer:I need a date field changed into a text field of YYYYMMDD

under the format options.

5 more replies
Relevance 63.14%

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.

Answer:Solved: Access Auto-Populate a Field using a field from another table

15 more replies
Relevance 63.14%

Hi all, 
I have a matter about placeholder in html. The placeholder will be disappeared when focus
on text filed with IE. But I want to keep hint text of placeholder when do that. Could you give me any suggestion?

More replies
Relevance 62.32%

I am using Microsoft Word [Office XP] and have text created on a page formatted as landscape. I now want to change this to portrait and have clicked on Format and then Text Direction but I only have the option to rotate 90 degrees in one direction. I have ended up with what was the top of the page on landscape at the right hand side of my portrait page but I need the top to be at the left. On the Text Orientation window it looks to give three buttons for vertical text but I can only click on one of them, hence why I can only get it facing one way.Hope this makes sense and that someone can help!ThanksKJ

Answer:Microsoft Word Text Orientation

File > Page Setup

10 more replies
Relevance 58.63%

I am working on a database that stores genus, species, and variety I want to sort the data with genus, then species, then variety.

Now the tricky part. Sometimes there is no species. When this is the case, I want the database to sort that record off of variety.

I have though of a way to do this, but need help with the code.

If I make a species2 field, I could create an expression that would look at the species field. If the species field is empty, it could copy the data from variety. If it is not empty, then copy the data in the species field.

Once the species2 field has the updated data, I could then do a sort

genus, species2, variety

The report would have genus, species and variety showing and species2 would be checked off to not show in the report.

I am using Microsoft Access 2000.

Any help would greatly be appreciated.

Answer:Access - if field is blank, copy field A, if not copy field B

You should not actually need another field to do this, just another column in your report's Query. Something like this as a Field header :-

dummySpecies: iif(isnull([species]), [genus], [species])

this should provide a column with the species in if it there and the genus if it is not, which you can use in place of your actual species field in the report for sorting.

1 more replies
Relevance 56.99%

Hello, The top text is what it looks like when the screen orientation is anyting other than "normal". The bottom text is what it looks like in normal mode. It's running windows 7 Pro 64-bit. The touchscreen input also shifts a few pixels up when the orientation flips 180. I just got two of these (off-lease) and they both have the same issue. Any help would be appreciated.   


Go to Solution.

Answer:X220 orientation problem - pixel shift when orientation flips

It is the ClearType issue on Windows 7. The only solution is to disable it, read this discussion

__________________________________ThinkPad (1992 - 2012): R51, X31, X220, Tablet 8.Do you care about privacy and security ? Leave Google behind

4 more replies
Relevance 56.58%

How do I get Firefox to remember something typed into a specific field? This text box pops up after I select 'Merchant Accept Liability' from the dropdown menu. I have to type 'We accept liability' into the text box at least 200 times a day. If there was some way for Firefox to remember this, it'd be extremely convenient. Attached screenshot.

Answer:Remembering a text field

One of the best rated form fillers is Roboform. It works in Firefox and IE.


Quality Artificial Intelligence
RoboForm is really smart in filling in forms; it is the most precise form filler on the market. We use Artificial Intelligence techniques to achieve this kind of precision and we test RoboForm thoroughly.

Selective Form Filling
You can ask RoboForm to fill just a part of your form, rather than the complete form. Simply select (highlight) the fields that you want RoboForm to fill and click any form filling button -- only the selected fields will be filled.

You could also try one of these Firefox addons:




Automate Firefox. Record and replay repetitious work. If you love the Firefox web browser, but are tired of repetitive tasks like visiting the same sites every days, filling out forms, and remembering passwords, then iMacros for Firefox is the solution you?ve been dreaming of! Whatever you do with Firefox, iMacros can automate it.

3 more replies
Relevance 56.58%
Question: Text Field Issues

While the main reason for this help request is to help me fix the text field problem Im having, there are a couple other problems as well.

It has become an ongoing problem, no clue what causes it. In certain games, so far only Mabinogi and Test Drive Unlimited, when I go to type something in a text field, my computer pauses, and people talking in Ventrilo repeat themselves over and over for a couple seconds. The same thing happens when I exit a text field in said games. No one else I have talked to has this issue, and I am fairly certain they have slower computers than me, so no clue what the issue is.

The other problem is my graphics card. I have an ATI Radeon x800 card, and when I am playing games, I get errors when it does not even seem to be taking up much memory. I was playing Test Drive Unlimited which I just got today, and I was getting a report error window for ccc.exe about every minute in game. If I ignored it, I could keep going, but eventually another error window popped up saying the same thing, so I shut the game down. I meet the minimum requirements, but I have no clue why its doing this. My computer has a history of overheating, but I don't know if its due to that.

Also, is there a program I can use to monitor the heat in my computer? I'd like to know if that is truly the problem here, as I have been told that my card could be damaged by now if it is overheating.

Answer:Text Field Issues

First heer is a link to the site that has a monitor for CPU and Heat along with a few other things. It is called MBM and about the 11th item down. It is Freeware.I would also suggest getting any Driver updates needed. I do not know what system you have but you can go to the manufacturers site and retrieve them from there. Do these two things and then try the game again so we know if it is a heat problem which it sounds like back and let us knowThank you Jitaa

12 more replies
Relevance 56.58%

when I print to Hewlett-Packard 800 series, instead of printing the page number (or other information) I get...
{page} or whatever the instruction is for the field. In print preview, it shows the number, but then when printed, I get the instruction information.

Answer:field text in Office 97

Please let us know which program next time.

If it's Word (I suspect), go to Tools-Options-Print tab. Remove "field codes".

3 more replies
Relevance 55.76%

From a specific text value in one field I need to count that field in multiple other fields. ie: in one column, for each text field marked Trip1, I need to add to a count in a Compartment1 field, a Compartment2 field, and a Compartment3 field.

Answer:How to count text values in another field

Perhaps we could be of some help if we knew what application you are talking about. Even if we know the application, I'm not sure there is enough information in your post for us to answer.Perhaps you could add a few details regarding what it is you are trying to count. Keep in mind that we can't see your computer from where we are sitting, so the more details you provide, the better.Thanks!Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 55.76%

Ok, first, I'm running Windows XP Pro SP2 on an HP Pavilion 8760c. It originally came with Windows 98, but the previous owner upgraded it to the XP sometime before giving the computer to me. I do NOT have any disks, neither the original system disks nor any restore disks, nor does there seem to be any restore partition on the hard drive.

First problem is -- for some reason when I try to type into any text fields in any windows based programs, the cursor goes into hyperblink mode, won't click into any text field, and won't let me type in any of them. I first noticed the problem when I tried to use internet explorer, I went to Google like normal and while it will let me type in the address bar at the top, it won't type into the Google search field. I have since found out it is NOT IE specific, but it won't let me type into the windows help search field, or the field where you enter a name for a restore point when manually setting it, or in the captcha box on a game program I use or pretty much anything windows based. I downloaded Firefox and I can type in Firefox with no problems, which is fine for searching the web, but does not fix the problem.

Second, with the system restore... this computer used to work fine. I used it occasionally at my old house, then we moved and the computer sat idle for about nine months, and I just hooked it back up last week. When I did I found problems with the sound as well as the problem with the text fields I mentione... Read more

More replies
Relevance 55.76%

Recently there's been an annoying little animation pop up whenever I click something. I can't really explain it, but it's similar to the blinking | you see when typing in text fields. Everything I click on something it shows up. It's really annoying. It even happens when I click a picture, except it appears as a HUGE blinking bar. Can someone help?

Answer:Not sure.. text field-like highlights when I click anything

A sometime worth a thousand words, can you post a screenshot?


7 more replies
Relevance 55.76%

when i open yahoo mail ,nd go for composing , the text area does not appear nd so i could not able to wright mails to my friends.the page displays also done with error. pls help me out of this problem

More replies
Relevance 55.76%

When creating, forwarding, or replying an email; the text field does not open automatically. It must be expanded manually. What is my problem? Thank you.

Answer:Outlook Express Text field

Have you tried this.

make Windows Mail or Outlook Express open email messages to windows that make use of all the available screen space automatically:

Open any email in its own window by double-clicking it in its folder.
Make sure the window is not maximized.
Move the window so that its top left corner coincides with the top left corner of your screen.
Grab the handle in the window's bottom right corner with the mouse and drag it to the bottom right corner of the screen.
Close the message window

1 more replies
Relevance 55.76%

Where is the setting to change the color of text fields? The color options in the options menues just change or force colors on the webpages themselves. Im looking to just change the color of the address/google bar, and any text fields that happen to appear on a webpage. Right now they are all a dark ugly grey, where if I open the same page in IE everything is properly colored to the pages defaults or to my light colored xp theme.

More replies
Relevance 55.76%

I have a table consisting of 8 columns by 26 rows. In each cell, I'm adding a Text Form Field. Is there anyway, besides doing it cell by cell, where I can just copy a row, then paste the same Text Form Field with text length maximums in the other 25 rows?

Answer:Word - Text Form Field

Sure, Brian.
Create first row.
In Print Layout view, take your mouse pointer to the left of the left-most cell in the row, and it should turn into a 1:00 pointing arrow. Click to select the whole row, then Ctrl+C to copy. Place your cursor in front of the paragraph return just below the table OR in the left-most cell of the row that you want a new row above, and hit Paste.

3 more replies
Relevance 55.76%

Hello All.
Public Sub AutoExec()
MsgBox ("The Word Startup Folder is: " _
& vbCrLf & Word.Application.StartupPath)
End Sub
First, I want to again thank everyone who helped me with my first question: Text Form Field in Word 2003.

My next question is: Is there a way to automatically tab to the next form field?

End Time
I would like to key in the hour (00), skip over the colon, key in the minutes (01) and have Word or VBA tab to the next field.

Can this be done? Any ideas?

More replies
Relevance 55.35%

I was wondering if the following is possible:

I am using Microsoft Excel currently (on a Windows XP machine) and I have three columns, one is text (name) and the other two columns are MM/DD format (start date) (finish date).

Can I make something that will move the entire row to a new sheet/tab, after the second date is added?

Name Start Date Finish Date
ABC Company 07/11/07 07/15/07
BCF Company 07/15/07 _______

Any guidance with this problem would be greatly appreciated.

Thanks in Advance,

Answer:Solved: Moving text after completing a field

15 more replies
Relevance 55.35%

I have completed a 4 page form in LiveCycle, however, I cannot figure out one important thing. I would like to have a text field repeated on everypage. A job number for example that someone filling out the form would enter, I would like that job number to appear at the top of every page.

How do I do this? Is there an easy "click" I am missing?

More replies
Relevance 55.35%

I am trying to create a worksheet to help me track my business.  In it I need a text field where  I can enter daily information. Is there some type of a text box or table that I can insert and use that will not increase the size of the worksheet when I update?  Thanks, lindee

More replies
Relevance 55.35%

Hello All.

I am attempting to create Text Form Fields in a previously created Word document. It was not created from a form template.

The field is the DAY in the date field: 10//007. I put the insertion point in the DAY field, click on the Text Form Field icon and fill in the field attributes. Type=Number, Max length=2. I type in a Help description, click OK, save the file, and click on the Protect icon.

When I key in a 2-digit num and press tab, the next page comes up. The same thing happens if I try to put in alpha characters. My help message does not appear. I pressed F1.

I would appreciate any help with this issue.

Answer:MS Word 2003 Text Form Field

9 more replies
Relevance 55.35%

i have a access 2007 database and have to print a lot of reports for the client. however when you have calculated field (i am counting the amount of weeks) on the form - and you then put a textbox on the form - which is a memo field in the table - that pulls information from the database(memo field) some of the data gets cut off.
i have set the 'can grow' and 'can shrink' properties to yes for the field.

once you delete the calculated field from the query - the text stretches and all the memo field text shows correctly.
is there away around this?

Answer:calculated field on reports causes text to disappear

Is the calculated field in the Header, Detail or Footer section?

3 more replies
Relevance 55.35%

I create demo files for testing. The way I have it now I have the file laid out with two merge fields. These link back to another docucment where I input a month's worth of dates. The first being Date created and the second column is File Load date.

Once this DateInput doc is updated I go through each record in the merge document and save each one as the DateCreated number as the file name and as a txt file.

Any ideas on how to automate this? I tried using Access to fill in the merge and I was able to have it input today and tomorrow dates using command buttons and these subs

Private Sub cmdToday_Click()
txtFrom = Date
txtTo = DateAdd("d", -1, Date)
End Sub

Private Sub cmdTomorrow_Click()
txtFrom = DateAdd("d", 1, Date)
txtTo = Date
End Sub

But that only gets me two days, I need to see about automating the whole month.

Any help would be appreciated. Thanks

Answer:Whole month of text files with merge field

Any ideas on how to do this? I have tried everything that I know. I tried making a macro in Word, but could not get that to work either.

1 more replies
Relevance 55.35%


i want to update the text box based on the combo box selection based on the user form in excel. I am using the below code but the problem is combo box value is hidden once i selected but text box value is coming.
'Private Sub ComboBox1_Change()
'ComboBox1.Value = Worksheets("OptionPage").Range("Af28").Value
'TextBox7.Value = Worksheets("OptionPage").Range("Ag28").Value
'End Sub

I am assigning the value of combo box into af28 and from there i am doing a vlookup in ag28 to get a value. In the combo box i have row source of particular range in the sheet.

Please help.....

Answer:Solved: Combo box text field updation

Hi, could you just post a sample with dummy data, it makes it easer to 'see' what you need / want.

3 more replies
Relevance 55.35%

I am looking to create a MS Word 2003 document for work that has a text field that has a character limit to it and I can't seem to find anything in Word that does that. I know it is possible, as we have various documents corporate HQ has us use that has text fields with character limits on them. Does anyone know where I can find this in Word 2003?


Answer:Text field w/character limit in MS Word 03

7 more replies
Relevance 55.35%


I have a doc which I have added the many checkboxes by using Check Box Form Field. Now I want to add textbox for others to enter text. I have added a Text Form Field to the doc but it is kind of hard to tell that there is a field in there. How I can make something like this:




so others can enter text above the lines only or making an enclosed box so others can only enter text inside the box?

Thank you for any help,


Answer:How to use the Text Form Field in MS Word 2000?

7 more replies
Relevance 54.94%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?

Answer:Word 2007 dynamically updated text field

See Word Variables etc. Editor which will allow you to easily map content controls to achieve what you want to do.

1 more replies
Relevance 54.94%

When I try to type in my password in the Windows start up screen spurious characters are automatically generated in the input field preventing me from inputting any password. If I do get into the system this effect happens in all accessed text fields. This has rendered my computer useless any suggestion of what the cause may be and how can it be fixed?


Answer:Windows 7 text field spurious character generation

Hello Emmedin and welcome to the Forums,

Could you please provide us with a screenshot from the problem? How to upload screenshots and files at SevenForums.
What anti virus are you currently using? Please run a full scan and report back anything found.
Have you made any recent changes to your system (Installed new software and such)?
Please also fill in your system specs by following this tutorial.
Good luck and keep us posted,

1 more replies
Relevance 54.94%

As I stated in my previous post, I'm creating a survey to send out in Word 2003 using text form fields and check box form fields. When typing comments in the text form fields, if the comments go above a certain word count, it is impossible to see what you are typing.

As it appears there is no way to make these text form fields scrollable, it is possible to make the text form field expandable when typing in it?

More replies
Relevance 54.94%

I'm trying to create a word doc with text form fields. I have them in the doc but I want them to remain the in the same location after I type in each box. Currently when I type enough characters in the box the next text form box moves to the next tab location. How can I make each box "freeze" where it is before I start typing in it? Any Suggestions?

Answer:Word 2007 - Text Form Field Help Needed

Embed the form field inside a frame. You can then set the frames border so that it is invisible so that it can't be seen.


1 more replies
Relevance 54.94%

I have an excel file with a column with values like 100, 200, 500, 500-02, and 500-04.
Access wants the column to be a number because 500-02 is not one of the first records.

If I use the acImport or acLink I get the same results. Which is an error importing (I get all the data just not the text values in the column) or a null value in the link when view from Access (even though you can open the spreadsheet with excel and see the true data). If I use the import Wizard and change the Field to text it that data is fine.

I also tried acImporting to an existing table with the field set a text but it changes it back to numeric and screws up.

I have a vision impared user and I need a button click to get this data into access.

Thanks for reading my post.

Answer:Solved: ACESS: import excel field as text

7 more replies
Relevance 54.94%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?

More replies
Relevance 54.94%

I thought I read somewhere that it was possible to do a search on a reserved character by putting "" around it. I made the mistake of annotating some appended text fields with "**" (without the quotes) so I would know which records had been added. At some point, I want to remove those two asterisks. . . but, of course, I suddenly realized that Access recognizes an "*" as a wild card meaning something/anything, not the "*" character. So a search using Like "***" or "*'**'" either finds nothing or finds every record with anything in the field.

So the question is, is there a way to search for a literal "**" in Access? OBP. . . are you home today?

Answer:Solved: Finding reserved character in text field

16 more replies
Relevance 54.94%

Can anyone help me with this following issue?
I don't really know how I should write the hole thing (receiving errors).

Here is the link

Thanks in advance

PS: VBA 6.3 and Outlook 2003

More replies
Relevance 54.94%

I was in settings today and It gave me a message telling me I had to reset my settings because something or another was corrupt. I did so and most stuff works fine (Had to sign back into a bunch of stuff) but I do have one problem. Text fields no longer seem able to remember anything I've put into them. For example when trying to sign in here I usually just click the username box, "Bad-People" comes up and I click it to enter it automatically. But "Bad-People" doesn't come up anymore.
I figured resetting things just erased the history. That would have been fine but it also doesn't remember anything I enter new. So if I signed in here, then signed out, and then tried to sign in again "Bad-People" STILL wouldn't show up. This is a feature I use A LOT on a number of sites but it no longer works on any site I've tried. 
Vista Home Basic
Chrome Version 43.0.2357.81 dev-m

More replies
Relevance 54.53%


I have currently a form that uses a tab control. The tabs are on top of the form. Some of the pages are too high for the screen, so one must scroll. Is there an easy way to put the tabs on the left of the form instead of on top? Or is there a possibility to "freeze" the tabs so that the tabs continue to be visible when scrolling the page? I've been searching the WWW for an answer, but couldn't find the solution (if there's any).

More replies
Relevance 54.12%

We use Oracle's XML Publisher to generate reports. This is where an XML file is merged with a .rtf template to generate an output (usually PDF). We design our .rtf templates using Microsoft Word 2007. I have a need to print something in the same position on the last page of every report (in this case.. customer invoices). I am placing this logic in the footer so it will print in the same position. I also have logic in there that determines when it is the last page. It isn't working and I need some help. Right now I have { if {NUMPAGES}>{PAGE} "Not Last Page" "Last Page" }. I am getting "Last Page" on every page. (This isn't the wording that I really need to go there, I was just testing this functionality). I read an article from Microsoft Support (Article ID 211755) that says this is supposed to work with version 2000. I'm hoping it is still valid for 2007. If you have accomplished something like this or can help me I would appreciate it.

More replies
Relevance 54.12%

Okay this one is a little freaky. I built a new PC recently and installed a fresh 8.1 . Few days later it starts randomly (maybe 1-2 per day, sometimes never) opening two new tabs. One searches omegle in google but doesn't open it, the other goes to It also sometimes enters the same piece of my Skype history into the text field. This piece of skype history shouldn't be on this computer since the logs are from a few months back, thus left on the old computer. I scanned my computer with Malwarebytes and Kaspersky, also used process explorer and scanned prcocesses with virustotal and got no positives. Any help would be appreciated.
P.S. also affects the mouse, but no movement, just left clicks.

Answer:Odd behavior, 2 new tabs and Skype history typed in text field.

Welcome aboard   Download Security Check from here or here and save it to your Desktop. Double-click SecurityCheck.exe Follow the onscreen instructions inside of the black box. A Notepad document should open automatically called checkup.txt; please post the contents of that document.NOTE 1. If one of your security applications (e.g., third-party firewall) requests permission to allow DIG.EXE access the Internet, allow it to do so.NOTE 2. SecurityCheck may produce some false warning(s), so leave the results reading to me.NOTE 3. If you receive UNSUPPORTED OPERATING SYSTEM! ABORTED! message restart computer and Security Check should run Please download Farbar Service Scanner (FSS) and run it on the computer with the issue.Make sure the following options are checked:
Internet ServicesWindows FirewallSystem RestoreSecurity Center/Action CenterWindows UpdateWindows DefenderOther ServicesPress "Scan".It will create a log (FSS.txt) in the same directory the tool is run.Please copy and paste the log to your reply. Please download MiniToolBox and run it.Checkmark following boxes:Report IE Proxy SettingsReport FF Proxy SettingsList content of HostsList IP configurationList Winsock EntriesList last 10 Event Viewer logList Installed ProgramsList Devices (do NOT change any settings here)List Users, Partitions and Memory sizeList Restore PointsClick Go and post the result. Please download Malwarebytes Anti-Malware (MBAM) to your desktop.NOTE. If you already have MBAM 2.0 installed scr... Read more

10 more replies
Relevance 54.12%

I was wondering if there were text tool format options for adobe professional.

i mean e.g. i want to left and right justify text, how do i do that with adobe professional

Answer:text field tool format options (adobe professional)

Adobe Professional what? Premier, Acrobat...

2 more replies
Relevance 54.12%


I am currently using Word 2003 and have created a template. Within the template are text fields. My current issue is that if I make a change to formatting in one of the text fields, it replicates to all of the text fields. To give an example in the screen shot if I enter text then change the formatting under Point 1 (Project Statement) that change remains with that text field. If I go down to the next form field, and before entering any text, make formatting changes, that replicates to all of the form fields below. Similarly if text is entered first, then a formatting change made i.e. bullet point, that then seems to replicate through to the rest of the text fields. Can someone please explain as to why this is happening? thanks.

More replies
Relevance 54.12%

I'm not sure why... I have a people contact in my phone for person but when I attempt to text that person she doesn't show up in my contact list. I looked at the contact and it shows the email field and the phone number field but it doesn't show a text field where it should say "TEXT" , Does anyone know why this is happening?
Thanks :)

Answer:Why wont the text field show up in Windows 8 people profile?

Are you sure the contact has a mobile number?
In my contacts a "text" field appears if they have a mobile number.
And with contacts which only have a landline the "test" field does not show up.

2 more replies
Relevance 53.71%

Hey folks. This may sound like a minor problem but give it a read please. I noticed that when I happen to hold my left mouse button down on the desktop and slide it all the way up to the upper left hand corner of the desktop, then a two symbol wide invisible textfield is highlighted (see attached image "bluethingy").

I recall that having come across this anomally in the past that it occorred in conjunction with some malware but remember no details. There is something slowing down my computer at the moment but none of the malware seeking programs (ive gone through the list that majorgeeks recommend) that I have run has taken care of the lag, or this blue thingy. Does anybody have any insight into this blue thingy? Ill send the hijack this file if anyones interested, but am mostly curious about the blue field.

*** Curious about another thing: When visiting websites (using IE) with textfields for me to enter text, in some phases of my computers life the cursor when in this field blinks like a mad dog. This usually lets me know that theres some malware doing its thing and that its time for me to clean up a little. My question is if you have seen this happen: What kind of malware is doing it or where does it reside? - is it a helper? - is it unrelated to IE? Or is it not malware at all and just annoying?

Thanks in advance folks :wave ,

Windows XP Pro 2002
IE 6.0

Answer:Little blue text field at upper left hand corner of desktop...

Welcome to, please follow the steps below:

- Run ALL the steps in this Sticky thread READ & RUN ME FIRST Before Asking for Support

Make sure you check version numbers and get all updates.

Very Important: Make sure you tell us the results from running the tutorial...was anything found? Were you unable to complete any of the scans?...Were you unable to download any of the tools?...Did you do the on-line scans as suggested? etc.Click to expand...

After doing ALL of the above you still have a problem make sure you have booted to normal mode and run the steps in the below link to properly use HijackThis:

Downloading, Installing, and Running HijackThis

Make sure you also rename HijackThis.exe as suggested in the procedures. Use analyse.exe for the new name. This is very important due to some new infections going around.

When you return to make your next post, make sure you attach the following logs and that you have run these scans in the following order too:

AVG Antispyware Log - ONLY IF NEEDED you were not able to run CounterSpy
Bitdefender - from step 6
Panda Scan - from step 6
runkeys.txt - the log from GetRunKey.bat
newfiles.txt - the log from ShowNew.bat

NOTE: You can only attach 3 files in a single message so it will require that you use two messages to attach all of these logs!Click to expand...

May be malware related. Anything that usually causes Windows and/or Internet Explorer to behave ab... Read more

1 more replies
Relevance 53.71%

I have an widget which runs on windows 10 tablet (flex 11 next book)in KIOSK problem is when I focus on text fields especially lower part of user view , onscreen keyboard covers input field not possible to view what I am there any solution apart from detaching keyboard and moving it in section not affecting text input field .. TIA

More replies
Relevance 50.84%
Question: Access - Field


I have a database with a field called "Date". But on that field, I just want an automatic date of 10/31/05 meaning when the user goes that field it will be automatically populated with that date. How do I do that?

Answer:Access - Field

6 more replies
Relevance 50.02%


I am stuck with my personal project in Access 2007. Basically I am trying to construct a database for my DVD's based one movies titles and actors. I made three tables, actors, movie info, and a third table to resolve the many to many relationships. Then I made a form with the actor names and a subform for the movies titles that actor is involved in. The form's purpose is to add movies to an existing actor...easy enough.

My problem is when I try to add a movie, I get the message "Field cannot be updated". Very frustrating! I read some posts on this site regarding similar issues but it didn't help me in this case. It's probably something really obvious which I am missing. Any suggestions would be greatly appreciated.


Answer:Access Updating Field

The was a problem with the record source of your sub form.

See the attached

3 more replies
Relevance 50.02%
Question: Access field size

I've got 2 large tables that I have joined by relationship, since having all information in 1 table results in the "more than 255 fields" error. Now I want to create an input form for / based on the 2 tables, but get the same error message when I try to create a query for the form. Since I will also need a report based on all the information, how can I proceed? I've whittled the individual field sizes down as far as they can go, I think. And many of the items in the form are "yes/no." Is there a way I can increase the default field size? Thanks for any help.

Answer:Access field size

6 more replies
Relevance 50.02%

Is there any way of displaying a picture or image as a field in Access 97?For example, a person's photograph in a record of their name, address etc?


look at north wind, they have an example of exactly what you want

1 more replies
Relevance 50.02%

Is it possible?

I have a database which has many Y/N fields. I would like to be able to make a calculation based on:

Is the field checked(true)
If so, What is the value of that field.

Some fields I would assign a value of either 2,10,15,40

How would this be done?


More replies
Relevance 50.02%

In Access, is there a macro or function that can be used or setup via a key combination that will sum the total of any numeric field of a table that I have placed my cursor in and display the total in a little window. I would like to use this instead of having to go through a query process.
For years I have used a DOS database Paradox 3.5. It has a function called "imageCSUM" that I have assigned to a key combination and will do this.
Has anyone done this or something like it that could be adapted.

Answer:Access Sum of field Macro??

7 more replies
Relevance 50.02%

I am an Access newbie that is feeling my way through designing a database. I am trying to compare data from a field in form1 (the data is from table1) to a field in table2. The fields in each of the tables have the same name and are the same data type. If the data displaying in form1 exists in table2, I want to make an image on the form visible, if the data displaying in form1 does not exist in table2, I do not want the image to be visible. I assume this is going to use vb, but I don't know where to begin.

The field in form1 is [CleanResults].[TestID]
The field in table1 is [UpdatedResultsTable].[TestID]
The field in table2 is [DisabledResultsTable].[TestID]
The image is [CleanResults].[AttnImage]

Any help would be greatly appreciated.

Answer:Field comparison in Access

if you create a query that joins table 1 with table two using the same field it should only show the rercords that occur in both. then use that query to populate your forms.

3 more replies
Relevance 50.02%

Well i have an access problems that i need solutions for... The project i am working on deals with the special ed students of my class and it is a database that has all of them in it..

MY problem is when i edit a students information.. The frmEditStudent needs to pop up blank.. and then a button that allows a search field or a search pop up form/window to search for the student by Last Name.. "After that is done i need the record to show up so it is possible to edit the students information again in the frmEditStudent form..
I've tried doing this with a textbox field and that will search for the last name and then the command button set to search for the record.. but all it does is change the record i am working with.. it changes the last name.. i need that field to be independent..

someone please help its the project for my final and its due tomorrow.. -_-''

More replies
Relevance 50.02%
Question: Access Field Size?

How do I adjust the field size for Numbers in microsoft access? I need to setup a field for only numbers that are 15-25 digits long. And only numbers..

More replies
Relevance 50.02%

I want to put in a default entry in a Yes/No data type field in a table that automatically defaults to a 'Yes' if the criteria is "JT" but leaves it at "0" (empty) otherwise. Any ideas?

Answer:MS Access Field Question

You must design a Form for the Table. On the Form VBA Module we can write a small Sub-routine to validate the criteria field value and set the yes/no field's value accordingly.

Immediately after entering the CriteriaField Value as "TJ" or "XY" the following routine can run on the CriteriaField_LostFocus() Event Procedure to validate the user entry and set the yes/no field value:

Sample Code:


Private Sub CriteriaField_LostFocus()
If Me![CriteriaField] = "TJ" Then
Me![YesNo] = True
Me![YesNo] = False
End if

End Sub
The word Me is an Alias Name for the Form where the Code runs. Instead of that you can use the reference like Forms![myForm]![CriteriaField]. Programmers prefer the much shorter reference Me.

3 more replies
Relevance 50.02%

In access 2000 database have designed Form.
Previously able to enter value in a previously designed form.
Designed new form and now cannot enter data or value into one text field. No trouble in other fields of same form.
Unable to figure out the reason.
Tks BobA

More replies
Relevance 50.02%
Question: Access Field Sizes

I am configuring a database, where I am needing to fill in fields that are greater than 255 characters - Closer to several THOUSAND characters...

Can something be constructed to have all data filled in on one field, and if it goes over 255 characters, will automatically cut off at 255 chars and move the remaining characters to another field, and if that one is greater than 255, move the remaining to a third field, and so on....

Or better yet, is there a way to remove the 255 character limitation?

I am using Access 2003.

Thanks for any help!

Answer:Access Field Sizes

Just use a Memo field.

2 more replies
Relevance 50.02%


I've looked at a few forums on this, but none of them seem to highlight the problem in this situation!

I've got an access split DB, and I've been creating some new forms. I've only created them in exactly the same way as previous forms, but these ones are coming up with the above message. The error message appears 3 times before letting me enter data. The query that the form is based on is only based on 1 table.

The wierd thing is that I have 2 forms that are based on the same query - both created this afternoon, and one of them will add data, and the other one wont. I have attached both parts of the DB so you can test it. Just try adding data into a new record on both forms.

The form "Yellow Team KPI Entry" is the one that brings up the error box, but the "Main Data Query 2" Form does work. I've checked all the settings that I can, but can't find anthing wrong there.

I'd be very grateful for your help.

Answer:Access: Field Cannot Be Updated

16 more replies
Relevance 50.02%

I have this Access database, and I want the contents of a particular field to consist of a calculation using values from another table.

I have table1, which contains the field with the calculation.
Table2, contains one of the fields containing the data to be calculated.
Table3, contains the other field with data to be calculated.

So I want a field in table1 to be the value in the field in table2 multiplied by the value in the field in table3.

Does anyone know how to do this? I'm guessing I need to enter some kind of special equation in the field in table 1?

Hope that makes sense!

Thanks in advance.

More replies
Relevance 50.02%

Attention all ace programmers!I have an Access table of contacts containing several fields including phone code and phone number.I also have just started to create an Outlook list of contacts.I would like to join the Access phone fields together to create a new field containing code-space-number so that I can export it to Outlook as a single field for Home Phone.Has anyone any idea how I can join the Access fields in this way without cutting and pasting dozens of numbers one at a time?

Answer:Access field joining

in a query by example grid, where it shows the new field (you will need a new field for the merged data) change the text to PhoneCode & " "Phonenumber(obviously change these to whatever your fields are called)dont know how you would incorporate it into your form as i cant see your form. then you could run a report and grab the full numbers from there (copy and paste) [i hope].if you get stuck, send me an e-mail so i can send back an attachment.good luck

1 more replies
Relevance 50.02%

I am trying to develop a little accounting program in MS Access 2007. I want to take transactions such as a credit card payment and be able to drill down into its component parts. I would enter the credit card invoice and then be able to enter the charges that made up the credit card total. Does anyone know how I might do this?

Answer:Split field in Access

Create separate tables for the Invoice and invoice items associated with that invoice number in a one to many relationship.

3 more replies
Relevance 50.02%


I have developt a database and created a form for so i be able to enter data. I also created a form so i be able to search for the data using (ID, Category and a search field).

I have already used the wizard to create the ID and the Category but how do i create the search field so when i type my text, ID or category in it would show up with the record.


Answer:MS Access Search Field

Yizi, you can do it with a simple "Unbound" Text Box which you can add to the form using the Toolbox Wizard.
However, you should only use that for searching for text, if you want to search for people and other things already in the database it is better to use a Combo box to list them for the user as it saves typing errors messing up the search.

1 more replies
Relevance 50.02%

I have created a subform, and in the subform I have some fields from a table, I added some fields to this table, but when I go into the subform to add the new fields in, they are not in the field list. I did a seach on how to update the field list, but it said to click on some refresh button that I think doesn't exist.


Answer:field list in access

Close all the forms, reports, tables, whatever and reopen.

you can also try closing everything and then go to View>Refresh (f5)

if both of those fail....close the database and reopen it.

2 more replies
Relevance 49.61%

trying to access fields of the table but not able to this....tried these codes..

Sub FieldNames()
Dim Rst As Recordset
Dim f As Field

Set Rst = CurrentDb.OpenRecordset("TableName")

For Each f In Rst.Fields
MsgBox (
End Sub

Sub FieldNames1()
Dim fld As Field
For Each fld In db.TableDefs(tbllist.text).fields
fldlist.AddItem fld.Name
End Sub0

thanx in advance

Answer:Getting Field Names from Tables in MS Access

What was wrong with the first function?

1 more replies
Relevance 49.61%

Hi I am totally new to Access 2007 and have only had a small experience with access 97 and 2000.

I am creating a Data Entry Form, And i am looking for a entry field to become visible when someone ticks a Checkbox above it. Now i think i have done this a long time ago in a previous version, but my memory is not the best and for the life of me i cannot figure out how to do this.

Any help would be appreciated.



Answer:Access 2007 - Field Visibility

KSL, it is best done using VBA, place the VBA in the Check Box's After Update Event Procedure.
The VBA will be something like this
if me.checkbox = -1 then
me.Fieldname.Visible = true
Me.Fieldname.visible = False

where checkbox is the actual name of you checkbox and Fieldname is the actaul name of the field you want to make visible.

1 more replies
Relevance 49.61%

Having some trouble finding the best way to handle this;

I have a table called Apple
This table contains a bunch of fields, i'm trying to make a button in a form which will clear certain fields to Null Value.

What i think is the right way to do this would be with the UPDATE command.

Update Apple
SET base1 = Null
WHERE cnumber = me!.cnumber
Each field in the table apple has a unique Cnumber, and in the form (using the me!.cnumber) i want it to match that row with the cnumber so it only wipes the fields in that row.

I also have a bunch of fields that need to be changed to null value base1,base2,base3...etc

Any tips or advice that could lead me to the right direction for something like this?

Thank you!!

Answer:Access VBA - Update field to Null

Altered33, welcome to the Forum.
I am not sure what it is you want to do, or more to the point why you want to do it.
To set numbers to Null is very difficult because they should be 0 zero.
To set text to null you use
me.base1 =""
Your where does not look quite right either, it would be
Where cnumber = me.cnumber or me!cnumber, ie not both a . and !.
Are you trying to do this in the form, in the table with a query or with a VBA recordset?

The word Set is used to set the Properties of "Objects" or "Variables"
Set rs = Me.Recordset.Clone

2 more replies
Relevance 49.61%

I currently have a button (Command88) on a form that searches a field (FirstPick) for the value that the user enters.
What I need is to edit the VBA so that if it fails to find a record containing that FirstPick value, it goes on to search a second field (SecondPick) on the same form, for the same value.

I'm sure it's really simple, but I don't know how to do it and have limited time to find an answer.

The code behind the button as it stands is as follows:

Private Sub Command88_Click()
On Error GoTo Err_Command88_Click

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit Sub

MsgBox Err.Description
Resume Exit_Command88_Click

End Sub

So... on failing to find the value in the FirstPick field, I need it to check the new SecondPick field. Failure to find the value in either field can go to the error message as usual.


Answer:MS Access: adding a second field to a search using VBA

16 more replies
Relevance 49.61%

Is there an easy way to input a SS# and have the cursor move to the next field without me hitting the tab or enter key? I have looked everywhere.

More replies
Relevance 49.61%

Error - The specified field '[xxx]' could refer to more than one table listed in the FROM clause of your SQL statement - Access 2003

A database was set up in 2000. when it is run now, the message above keeps coming up:
Error - The specified field '[NOISE]' could refer to more than one table listed in the FROM clause of your SQL statement
I have checked the queries and all have the object variable set.
If I post the database and query could someone say where it is going wrong as I am at a loss

Answer:Access 2003 - Error - The specified field '[xxx]'

14 more replies
Relevance 49.61%

Hi, I have a very simple report that I'd like to add a totals field to. The data consists of:

1. Persons name (duplicates within table ie; many John Doe's)
2. Start Date
3. End DAte
4. a calculated field which is =End Date-Start Date +1 (counts # of days traveled)

What I'd like to do is have the report show me each persons name 1 time with the total days traveled: ie:

John Doe 16

Is that enough info? I can't see to accomplish this simple current result is one persons name with each individual day they
John Doe 1

Any help is welcome!

Answer:Access Report-calculated field

AK, there are at least 2 ways to this, the first is to use a Grouping Query with the Person Name & Calculated field on where the calculated field is "Summed". The start and finish date would have to be arranged in the Report header and no in the query as it will mess up the grouping.
The second is to use the Report wizard and add Grouping and "Summary Only".

1 more replies
Relevance 49.61%

i have an report in access and i want to count a field with specify value my filed name is "id wbs" and my value is "construction"

please answer me

i used =Sum(IIf([ID WBS]='construction',1,0))
but it isnt correct
please help

More replies
Relevance 49.61%

Friend of mine is working on making a Bank Database in Microsoft Access.

After trying different validation format, we failed to get exactly what we wanted.

We did the setting for "Account Number" as "AutoNumber" & set the format in the way, that every time the new record gets created, this "Account Number" keeps on increasing by one (which we did by having "New Values as Increment"). However, since account number we want needs to be at least 5 digit long, I wonder how do we go about doing so ???

Furthermore, in another table, we want to set some sort of format for "Credit/Debit Card" in the way, that it has to be 16 digit long with "space" after each of the 4 digit i.e. in the format "0000 0000 0000 0000" & we wish this to be "Auto Number" & New Values as "Random", however, when we tried we kept on getting "-" sign in front of some of these "Credit/Debit Card" number, once we start typing other details. Additionally, what we want is even if we type in say "1000100010001000", some sort of format/validation automatically changing it to "1000 1000 1000 1000" (i.e. space after 4 digits) & we also want validation, which means the digit should NOT go over 16 & should NOT be less than 16.

Can anyone help in getting what we want in both of these cases i.e. the "Account Number" & "Credit/Debit Card".

Answer:Microsoft Access Field Format ?

Account number - maybe this will help: card - sorry, I can't follow what's going on. Does this apply?: the problem that some of the random numbers are negative?I tried it out with 8 digits -Format = fixedDefault Value= Abs(100000000*Rnd(88888888))- and it seemed to work OK.

1 more replies
Relevance 49.61%

Is it possible to return a field name in a Query so that I can use it in a mail merge field in word.

Answer:Return Field Name -Access 2000

9 more replies
Relevance 49.61%


I have a table1 with a lot of fields a,b,c,d,e,f and so forth.
I also have a table2 with just a and b. (because you are not allowed to fill in value a if it is not in table 2.
I have a form that i use to fill in a,b,c,d,e,f
Is it possible to make the form fill in b based on the value of a ?

Answer:Inheriting from another field in access form

The answer to your question is Yes.
However as the data has to be in table 2 then the User should not actually enter the data in the Form for table 1.
Ideally the User would "Select" the data from table 2 and the only thing stored in table 1 is the ID Key value from table 2.
The selection process would be made using a Combo drop down box.
Normally the data from Table 2 would be on display in a Main form and the data to be entered in table 1 would be entered and shown on a Sub Form, usually in continuous forms mode or Datasheet view.

1 more replies
Relevance 49.61%

Hello everyone,

I'm working on an order management database and I'm stuck on one item.

I have a form that users can fill in with purchase order data. One section of the form relates to contract review completion.

I would like to have a checkbox that the user can check when contract review is complete, but I'd also like for a completion date field to be auto-filled when the checkbox is checked.

I've tried a couple of things, both unsuccessful.

Any ideas?


Answer:MS Access - autofill date field

6 more replies
Relevance 49.61%


I have a field that refuses to do what I tell it to do!!

I have a dbase with has a list of items to choose from and then calculates the number of days a job is running. I have two options that have VBA coding to calculate a half day when an option from the list box is selected. The code is identical. One works, one doesn't. I have searched and rewritten and I cannot find a reason why this is happening. The option that works is Descriptive Entry: 1/2 day. The option that doesn't is Hotshot Half Day. In order to calculate the number of days the option from the list box has to be clicked on.

Can you help?? I have uploaded a sample of the dbase. The names have been changed to protect the innocent.

Help me OBP Kinobee, your my only hope!!

Answer:Access, Unable to Update Field, OBP Help!!

12 more replies
Relevance 49.61%

This is probably so obvious that I'll feel embarassed by the answer - sorry.

Building a user interface in Access 2000 connected to SQL Svr 2000. I'm attempting to set an Event Procedure for On Enter a particular Text Box. When I constructed it Access opened the VB environment and I've set the element as below.

Private Sub OperatorName_Enter()
Dim SQL As String

SQL = "SELECT MasterOperatorDetail.MasterOperatorName" & _
"FROM MasterOperatorDetail,CollectedData" & _
"WHERE CollectedData.ClockNumber = MasterOperatorDetail.MasterOperatorClockNo" & _
"AND CollectedData.OperatorPIN = MasterOperatorDetail.MasterOperatorPIN"

' RunSQL SQL 'This is the problem area - unsure of syntax/command

SQL = OperatorName.Value

End Sub

The above tables called in the query were constructed when I set up the Project using new data. The above Select Query functions properly in SQL Server's Query Analyzer and returns expected results.

Where I need help is getting the syntax/command right.

Thoughts and/or direction(s) most appreciated. I've Googled this to no avail so the search entry I'm using must be backwards as well.

Thanks - PC

More replies
Relevance 49.61%

I want to initialize a field to zero when I append it to a table. The append uses the code below:

Set fld = tbl.CreateField("Hasler_PAmt", dbCurrency)
tbl.Fields.Append fld
fld.Properties("Required").Value = False

I tried fld.default = 0 but that only puts zeros in future new records not in the 'appended' ones.

Thanks for reading my post!

Answer:VBA Access initialize appended field

Does this work for you?

Public Sub updatetbl()

Dim strSql

strSql = "UPDATE Table1 SET Table1.Required= '0'"

DoCmd.RunSQL (strSql)

End Sub
but I am not clear if you need to set one record based on criteria or if the entire table in that field is to be reset?

3 more replies