Desitech
Last Activity: Oct 18 '10, 08:15 PM
Joined: Apr 9 '09
Location:
-
I already have the label created with BarTender Barcode Software, and the label format already has links to the database. I can pull up the label using bartender and print labels using the data from the database. I want to create a label from the user form of the database. -
How to set up a user to print a label to print in access using bartender
I have an access database with part numbers. I want a user to be able to print a bar code label I crated in bartender to print for the record they choose. The label is connected to the database and will return the part number and description fields on the label. I just need expression code on a toggle button to gather the infor for that record and populate the label then preview the label and then print it. Thanks -
Why does PDFPrinter only work under my administrator account?
I have a new computer with Windows 7 64bit. I loaded Adobe Acrobat 8 Pro onto it. I set up the PDF printer under my administrator account and my user account. Permissions have been set to allow the same rights to both accounts. When I log on as administrator the PDF Printer works as expected. But when I log on as a user, it does not work. No error messages. Nothing in the print cue.
Anyone have any ideas?
Thanks -
User forms
I want the users of my Database to only see the Forms. The way it is now, if they close the form they can see all the tables, forms, queries, etc. How can I set it up so if they close the form they only get a blank screen? -
Thanks the .Column(1) is all I needed. Works great now. Thanks a ton.Leave a comment:
-
I don't understand. Is this located under the properties of the combobox. If so, It isn't there. Or am I misunderstandin g? Could you walk me through this?Leave a comment:
-
Cool that worked. Thanks for all your help. I have one last question.
I am opening a report where the golfer name appears on the report from the value in the combobox from my main form. The Golfer name comes from the table "TblGolfer" , The value that is returned is from the GolferID Field rather than the GolferName Field of that table on the report. How do I get the name to appear instead? I am using this expression in the text...Leave a comment:
-
Do mean, like this.
How do I use the "SPLIT" functionCode:stLinkCriteria = "[GOLFER1],[GOLFER2],[GOLFER3],[GOLFER4]=" & Me![CboGolfer] DoCmd.OpenForm stDocName, , , stLinkCriteriaLeave a comment:
-
Linking a value to multiple records
I am trying to get one value to return more than one linked field. The single link works. This is the code that works.
...Code:Private Sub Command27_Click() If IsNull(CboGolfer) Then MsgBox "MUST SELECT A GOLFER" Exit Sub End If Dim stDocName As String Dim stLinkCriteria As String stDocName = "FrmTeamList" -
Open a Report with a Combo Box
I have a Main Form with a combo box and a command button. The combo box has a list of years for the user to choose from. Once the Year is selected, I want the user to click on the commnd button to run a report preview and only include the data from the year selected. Any Code help to acheive this would be greatly appreciated. -
Code Help
From a Main Form, I have a Combo Box and a Command Button. I want to have the user select a name from the combo box, then click the command button. The result I want is to have a report open only returning the name and the data of the receord on the report. For example: I have a table entitled "TblTeams" each record has a Year, TeamID, Name1, Name2, Name3, & Name 4. I have a Report entitled "RptTeams". The report returns all... -
Value returned from look-up
I have a table that has a field where I use the look-up from another table's field. When I put this into a form or report. It returns an integer in the field rather that the value (text) from the look-up drop down. How can fix this? -
Hiding Items on a Report
I am running a report and I want only the fields that are true to show-up on the report and the ones that are false not to show-up on the report. -
Organizing
I am getting ready to build a new Database for a Golf Tournament I have each year. I am having trouble organizing how I want to build my tables. I have many golfers that golf each year but usually are part of different teams. Some years they golf some they don't. I want to do history reporting. Like What years did they particiate. What championships did they win. Are there any templates for building tables and how to organize the information. Th... -
Great....That did it. Thanks for all your help.Leave a comment:
-
That worked to get my background highlighted. But because I have to change the label to a txtbox, in order to conditianally format it, the label text is gone. How can I gat the label text to come back?Leave a comment:
-
Conditional Formatting of a label on a report
I have a Label on a report with a check box from a table indicating True or False. I would like to have the labels that are true to highlight yellow using conditional foramtting. The False labels to remain unhighlighted. I have tried changing the label to a text box and then conditional formatting "Expresion Is" "BILL"=TRUE . But the formatting is not working. I loose my Label text and BackColor does not change. Any Suggestion... -
I mean't "I am now getting and error that reads."Leave a comment:
-
Very, Very close. I am not getting an error that reads.
The database engine could not lock table 'EXTRUSIONS' because it is already used by another process
The form I have open when running this report is using the same table.Leave a comment:
-
This is the code I am now trying:
...Code:Private Sub WHEREUSED_Click() On Error GoTo Err_WHEREUSED_Click Dim stDocName As String stDocName = "EXTRUWHEREUSED" DoCmd.OpenReport stDocName, acPreview, , "EXTRU DOC = """ & Me.[EXTRU DOC].Value & "" Exit_WHEREUSED_Click: Exit Sub Err_WHEREUSED_Click:Leave a comment:
No activity results to display
Leave a comment: