Search results

Did you check if the text box that contains the barcode is wide enough to show the full barcode? Another possibility is that the barcode is too close to other text or lines at it's ends. Peter

Hi Kila, Could you show us more specificly the structure of your table? As Lan said it's a bit difficult to suggest a solution without looking at the data. Peter

I have a report with Page Header a full page wide and the Detail spanned 1/3 of the page width. In the Page Setup I have the following settings: Number of Columns: 3 Row Spacing: 0cm Column Spacing: 0.5cm Column Size: Width 6cm, Height 2.5cm The report shows a page-wide header and the details...

Would it be easier to export you tables to Excel, re-arrange the data, then import them back to Access to new tables? Just a suggestion before you find other better way. Peter

In my report I put in a text box, set the Control source to =1, Running Sum set to Yes. This text box will serve as a row number if it is put inside the detail section. If it is put inside a group section it will show the occurance of the group. It applies to the rows in the report only, not...

I just tried it again and it's working fine now. I remember I had updated my Office2K with service pack once, and had once cleaned out Office with Eraser2K then re-installed it again. But I didn't try the input mask for a long time, so I don't know if that would cure the input-mask problem too.

I am using english A2K and Windows 2K with eastern asian language turned on. Do you mean it's Win2K's language problem?

Hi John, My mystery is still unsolved. Finally I had dropped the input mask and put a small note beside the text box instead. I also make use of the Status Bar to show comments to every input text box. Peter

Could it be the cause of some security settings? Certain antivirus or firewall software might prevent you from downloading executable files even when zipped, mdb files are executable files. Peter

Hi morlan, Did you try setting the "Hide Duplicates" Property of those text boxes to Yes? Peter

I had the same problem before, especially with summed fields in union queries. It is said to be a floating point problem with Access. I finally used used a different name for the text box in the report and set the control source to a Round() function: eg: Control Source of txtAmount as...

There are 2 ways (as far as I know, as a novice Access addict) to hide 0 values in reports: 1. Using the Text Box's Format Property - eg.: $#,##0.00;($#,##0.00); 0 [White];"Null" for full explanation search Access Help for Format Property — Number and Currency Data Types 2...

Hi Tony, Yes, I had created new buttons and they work fine, for the time being. But now one more of the old buttons has the Control Tip "disabled". I have been modifying my mdb file but don't know what I did could disable the Control Tip. I tried restarting Access, Windows, and re-build the...

See if you can get any idea from this sample. Here is a link to some information that might help too: http://support.microsoft.com/default.aspx?scid=kb;en-us;210004 Peter

I have in a form 8 command buttons, all have ControlTip Text. 4 of them show Contol Tips when mouse stays over the button, others don't. Anybdy have any idea why this happens? Peter

Create a new field in your query: WeekNo: Format([YourDate], "ww", 2) This will return the week number (in the year) with Monday as the first day of the week. Peter

I have been using a barcode scanner with my Access (and Excel) applications for a long time. The one I use is a hand-held laser scanner with built-in decoder which can decode several types of barcodes. It comes with an adaptor cable (like a 2-headed snake!) which connects to the keyboard port...

I had searched several forums but could not find any Inut Mask question similar to mine. Could it be problem in my system only? I am running Access2000 in Windows2000. Here is what's happening, and I don't think it is normal: When I enter data in the text box with Input Mask the cursor stays...

In your 2 column query (as mentioned in your first post) add a third column, in the first row enter this line in whole Percent: [RegionOfCount]/DCount("*","YourTableName") Total is set to Expression In Field Property set the Format to Percentage Note: "YourTableName" means the name of your...

One query will do: Region - Group By Entries: Region - Count Pcntge: [RegionOfCount]/DCount("*","YourTableName")*100 - Expression Field Format set to Percentage Peter