Codebug
Last Activity: Feb 26 '08, 08:41 AM
Joined: Feb 13 '08
Location:
-
Yes thanks, NewRecord that worked! -
Yes, working now, just updated the Adobe Reader !Leave a comment:
-
Ok, still having problems
After_Update event not working as the user may sometimes want to drop down before moving to another input field (When the field gets updated)
have tried a routine using on change, but cannot get the data the user has typed into the combobox, the combobox value only returns the last updated value, not whats displayed in the comboboxLeave a comment:
-
Yes thanks for your help,
yes that is correct, the data for this field is generic from a serial number of a product. And the data structure was something I had inherited when I took on the design of it.
Every time the product is returned for repair it is entered into the database, with a unique indexed field.
the serial number can be alphanumeric ie S124-2 (Second Time product was returned).Leave a comment:
-
PDF Object Not working.
I have a form with a PDF object that loads perfectly ok on one machine, however if the same form is loaded on another machine, it fails to load, (Just displays a blank white object)
I assume that there is a missing dll on the other machine that loads it into access, although Adobe Reader is installed on both machines.
The machine that works is using XP, the one not working is 2000 -
I want to run a function based on the text typed into the combobox, so that the user can select a valid input. The field has a suffix at the end indicating a unique entry based on how many times it has been entered.
I already have a function that will return the correct result in the ComboBox List, I just need it to be called if the user decides to pull down the ComboList to select the next in the seqence, otherwise the user has to...Leave a comment:
-
Thanks,
overlooked the obviousLeave a comment:
-
ComboBox dropdown.
Is there an event I can use when a user slelects the dropdown from a ComboBox on a form, either by clicking it or pressing F4? -
Form append mode?
How can you check if a form is in append mode (ie new record)
Code:If MyForm = ' Append Mode ? Then ' my code End If -
Ok, figured this one out myself in the end, as always was simple
I just used the value property of the ListBox which is bound to the correct column of the list to return the value the user selected,
ie:
UserSelection = MyListBox.valueLeave a comment:
-
Tab Focus
How do you change the tab page of a TabCtlBox using VB so that it has focus?
I have an excel object on one of the pages but due to a function I have written to update the excel object, it will also move focus to the page this excel object is on. I have tried disabling the control whilst the update function is used: ie:
MyTabCtl.enable d = false
but then it returns an error, presumably because it cant then... -
Using ListBox To select data
I have a List Box on a form and the RowSource SQL is set in VB to display field data from a table.
How do I pass field data from the users selected row? -
Thanks, think it has put me on the right lines.Leave a comment:
-
No, its the format thats required, not to save paperLeave a comment:
-
Report Question
is it possible to create a report formatting the detail of related data as follows
Header data
Detail-------------------------
Item 1
item 2
Item 3
Header data
Detail-------------------------
Item 1
item 2
Item 3
This is how Id like it formated.
Header data
Detail--------------------------------... -
yes It is always a '-' that seperates the text, although sometimes there is no '-' presnt and need to leave the string as it is
ie.
"X1287-2" = "X1287"
"X1287" = "X1287Leave a comment:
-
String Function
How can I trim a string as follows?
Dim MyText AS String
MyText = "X1123-2"
so that MyText can become "X1123" -
Solved the problem
Id forgotten that i had set another event to load the pdf.
In fact the path in th above code didnt exist, but I was fooled because it loaded the pdf ok!Leave a comment:
-
DIR(Filename) Question
Whys does the second "If Len(Dir(Filenam e)) > 0 Then" function not work in this code, the first one is ok. The files DO exist and both should return 'true'. If I REM the second IF THEN, ELSE, ENDIF statements, it loads the pdf file ok!
Private Sub Form_Current()
' Update Cost Sheet, Check Sheet and drive History data on NCR change
Dim db As Database
Dim rs As Recordset...
No activity results to display
Leave a comment: