Hello,
A quick question to see if anybody can recommend a barcode application which can run through Access 2000 to print UPC-A barcodes on Reports.
Thanks in advance,
Peader
Peader
Last Activity: May 28 '08, 07:46 AM
Joined: Oct 15 '07
Location:
-
UPC Barcodes in Access Reports
-
Hi Rabbit
While 9 out of the 10 times it will be the same. The value will change from time to time (its a part number and we develop new parts monthly). You could say 90% of what we sell is the same however this 90% changes depending on the season.
I've tried to set the default value however I run into problems (I can't confirm exactly why however I suspect its because I use a bound text box), I need to reselect the... -
Repeat (Repetitive) Information Entry Through Access Form.
Hi,
I'm looking for advice on the best way to set up a new database considering the following:
I want to use one form to enter 4 fields
9 out of ten times the information in those fields will be the same.
For the 9 out of ten times the information is the same I only want the user to have to click the command button to enter the new information.
On the 10th time I expect the user to select the alternative... -
Populate a text box in a form with a value from a table on opening
Hi,
I have a table with two columns "Job Order" and "Part Number", I'd like to populate a text field in a form with these values, whats the best way to do it?
There's only ever 1 row in the "Job Order", "Part Number", table (ie. ID number always 1).
Thanks in advance,
Peter -
If it's any interest to anybody I fixed the problem.
As HB1 is always fixed, I simply put HB1 as a label outside the text box I'm typing the search value into (prefix)!! The user should hopefully then only enter the XXXXXX value, and it will appear the complete value is being considered....w ell so I'm guessing :)Leave a comment:
-
Search And Return Record in Form, Access 2002
Hi,
I'm trying to complete a form that will search previous results entered in a table and return the row items based on a ID number. My current code is below:
...Code:Private Sub cmd22_Click() Dim strStudentRef As String Dim strSearch As String DoCmd.ShowAllRecords DoCmd.GoToControl ("ID") DoCmd.FindRecord Me!text1 ID.SetFocus -
Thanks Lads,
Problem solved. I used Lebans method.
PeaderLeave a comment:
-
Lock Form Question Access
Hi,
A quick question here on how to prevent my mouse scroll wheel from being able to track through all previously saved records in my table. Any idea's?
Peader -
PrintOut Function Problem (MS Access)
Hi,
I thought I had this figured out however on more testing it seams not.
I've have the following code connected to a command button in a form:
After a click of the button (in the form), page 1 in a report (called labels) should print....Code:stDocName = "Labels" DoCmd.OpenReport stDocName DoCmd.PrintOut acPages, 1, 1 DoCmd.Close acDefault, stDocName -
I think I've solved my own question!! :)
For other peoples reference in the future
And a more complete description given by the people over at microsoft here:Code:DoCmd.PrintOut(PrintRange, PageFrom, PageTo, PrintQuality, Copies, CollateCopies)
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx...Leave a comment:
-
PrintOut In VB (ms access)
Hi,
Does anybody know the VB code for the PrintOut Action i can use in ms access?
is a no brainer, but how do i go from here to specifying:Code:DoCmd .printout
Print Range
Page From
Page To
Print Quality
Copies
Copies Collated
An example would be nice :)
Thanks -
Oh yes, a thing of amazement, it's working. :)
Nic;o) thanks for the advise and direction. You've really gone out of your way to be more than helpful.
Here's the final IF Statement code for anybody reading this thread in the future.
...Code:If (DCount("printed", "10pkBoxLabels", "printed = False") > 10) Then stDocName = "Open10pkLabelMacro"Leave a comment:
-
Hello Nico
I use the On Click event to run. I also tried the after update event specifically for the IF statement alone however this didn't work!?!?
Thanks,
PeaderLeave a comment:
-
Nico thanks for the advise so far it's been very helpful.
No joy when i inserted the break point and used F8 to skip down the line in the code however it didn't seam to have an effect.
I've created the Dcount function in a query to check it's correct, it worked fine.
I then removed the IF statement and left the macro, my thinking was the macro should have run however it didn't.
Here's the...Leave a comment:
-
I corrected the Dcount statement to:
If (DCount("[printed]", "10pkBoxLabels" , "[printed] = False") > 10) Then
stDocName = "Open10pkLabelM acro"
stDocName = "UpdatePrintedQ uery"
End If
However it still doesn't work. Regardless of the number of printed true's/false's it does not run the macro or update the table, no warnings, appears...Leave a comment:
-
Thanks Nico
I've prepared the table, macro and query's however I'm now having trouble running a IF statement to check the printed files, any idea's on where I'm going wrong?
[code=vb]
IF (dcount(printed , '10pkBoxLabels ',[printed = false] >10 then
'I've set up a macro to print the label
stDocName = "Open10pkLabelM acro"
'then another query to update the printed fields
stDocName...Leave a comment:
-
thanks for pointing me in right direction nico5038, it's taken me a while however i'm beginning to make progressLeave a comment:
-
Automate Print Labels After Set Number of Table Entries
Hello,
I’d like to make an inquiry into how to best perform a task in access 2003. I have a form which enters data into a table. This in turn is linked to a label. After ten data entries into the table, I’d like a label to print. Is it best for me to use a counter on the ‘save’ button in my form or is there an easier way to do this? I’d also like to be able to print a partial label say 3, 5 or 7 enters through my process,... -
Hello ADezii
I've a very similar problem to Larryimic's. I'm trying to print a report after a specific number (10) of command button clicks and also I'm very new to this. I understand the principle behind the program you describe however can you help me understand the specific function (and difference) of the lines 6 & 9.
Thanks for any advise you could provide,
Peader...Leave a comment:
No activity results to display
Leave a comment: