Search results

  1. C

    ALTER TABLE column field type from TEXT to NUMBER

    Hi all, I have a problem with a table ive linked to / selected contents into a copy of said table. The field type of one of my columns changes to text (shows as text on the link dispite being a number). Ive tried converting said column to a number column using the following command but to no...
  2. C

    Cause number to act as a string?

    well its working now, i placed cstr() into the sql command around name and now it retrieves the numbers fine, i must have just been doing incorrectly when i put in name = cstr(name) before :s and i shall revise my naming of Name, dont worry, thanks all fo rthe assist ^^
  3. C

    Cause number to act as a string?

    would take me some time to put one together, has some sensitive records. As for QBE ive not heard of it?
  4. C

    Cause number to act as a string?

    The field is 'Text'
  5. C

    Cause number to act as a string?

    oh, and i tried using Name = CStr(Name) before hitting 'If ISNull' but returns an error (Invalid use of Null) if the textbox is empty. If its 201 it still didnt work, but ATHERTON did.
  6. C

    Cause number to act as a string?

    sorry for confusion, when i mentioned that this was on a form, i really should have mentioned that a search box is used, where this code resides. I understand this likely caused confusion as to the number of words being searched for. Ill elaborate on the previous. Theres a textbox, enter...
  7. C

    Cause number to act as a string?

    i actually figured that to be the case, that the numbers would be treated as text/strings initially but then i wouldnt need t owork out why they arent being retrieved :(
  8. C

    Cause number to act as a string?

    yes thats correct, i was just giving an example of what could be found in the many rows of that column such as NAME ----------- ATHERTON LINKS OTHER SUBCAP 201 G&N
  9. C

    Cause number to act as a string?

    Im in 97, Form_frmSearchResults.SetSearchResults strSQL is relating to the following procedure Public Sub SetSearchResults(strSQL As String) Me.RecordSource = strSQL End Sub Im aware the CSTR command to convert an integer into a string but im not sure how i can first convert the...
  10. C

    Cause number to act as a string?

    Hi, I have a form that searches a table and retrieves all the values in a column, based on an SQL query. At the moment it is only retrieving values that are all character related, not integers. Such as in my column i have ATHERTON 201 It wont retrieve 201. My search button contains the...
  11. C

    Combine # text files but remove first line from all but 1

    Hi, Each month i get several text files which i want to load into a table in access via VB. Atm this is a slow process so would like to automate this with VB, by combining the text files together then exporting into the database. I know the DOS command to combine the files copy filename1.txt...
  12. C

    Cannot load image in Microsoft Office Document Imaging

    Hi, I was formerly using Kodak Image Viewer to view images in a form but im not on XP which doesnt use it so im trying to use Microsoft Office Document Imaging to view the image (.tif). However the code doesnt want to take the code i found on the MS website. the code im trying is...
  13. C

    Insert into table using VB

    Could you show me the basic layout of the update statement? ive tried it with the SQL sequence but doesnt work for me :(
  14. C

    Insert into table using VB

    I currently have ObjConn.Execute "INSERT INTO tblRESULTS (REF) VALUES (" & strREF & ")" Which works fine for adding a value to a single column on a blank table. What i need is to update my table in a cell in column REF where column ACTION has a cell that shows its value as LIVE So, in...
  15. C

    Insert into table using VB

    Hi all, Im trying to insert a vlue into a table where the corresponding cell in another column = 'LIVE' ObjConn.Execute "INSERT INTO tblRESULTS (REF) VALUES '" & strREF & "' WHERE (ACTION) = 'LIVE'" Whats wrong with my syntax? Thanks
  16. C

    Check Date complys in query?

    Hi, I have a query where i wish it to check that a date within my table complies to the below <>"05/04/yyyy" So in crteria i want it to be 05 of 04 and the following to be in a year format. The o5 and 04 are specific, it doesnt matter what the year is as long as its a year.
  17. C

    Display Image on form based on path

    Hi all, Ive been trying to find a method to display an image on a form dependent on the fielpath in a variable used when the form is opened (click on users name, form opens, image shown). Ive been trying to use the windows image and fax viewer but to no avail...
  18. C

    Windows Image and Fax Viewer (Preview 1.0) problem

    Just tried a few more times and to no success, trying to find if theres an OCX to it as shimgvw.dll is the only thing i think is registered. I get the error (when checking in properties) A problem occured while db1 was communicating with the OLE server or ActiveX control. Close the OLE...
  19. C

    Windows Image and Fax Viewer (Preview 1.0) problem

    my app is at university atm, but ive just recreated it, on form load, as Preview1.ShowFile "C:\My Documents\Picture\Sunset.jpg, 1 the websites ive read on the Preview 1.0 Type Library dont really mention details on adding the class, just on the code in the tool. I cant imagine ive added it...
  20. C

    Windows Image and Fax Viewer (Preview 1.0) problem

    I did trychanging the name of the control to Preview1 to comply and it still didnt work :(
Back
Top Bottom