Search:

Type: Posts; User: cubsm22p

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Re: combobox that finds record based on order number typed

    do you think that would be under property sheet > validation rule
    'Like '@'

    because i dont want to limit it to just that order number
  2. combobox that finds record based on order number typed

    i have a combo box that finds a record on my form based on order number i select in the drop down , is there a way i can get it to auto populate if i search part of the order number instead of the...
  3. Replies
    10
    Views
    1,429

    Re: Database Access

    change both database data type to number then put field size to double that will make all your decimals show
  4. Re: putting pictures on a form and report in access

    ok i have got a form for data entry almost figured out:
    158903
    here is what my form looks like, i got the photo to change with the dropbox using this VBA code
    Private Sub Combo75_AfterUpdate()...
  5. Re: putting pictures on a form and report in access

    158839
    i have decided i may just want a drop down box like above picture, and have a image control linked to show up depending on what number is in the unwind field. if there is a one in the unwind...
  6. Re: putting pictures on a form and report in access

    how would i go about doing "image control + jpgs to shared area (or local drive) for display."

    thanks for your answer
  7. putting pictures on a form and report in access

    158763158765158767158769
    I have 8 of these images , i want to make a form that has a way for for someone to select one of the images on the form to save it to a record and then later on i need the...
  8. backend data base creating a button for linked table manager

    i would like to have a button to push to refresh my links to my backend and frontend access database so people entering data dont have to go to the linked table manager every time they want to update...
  9. Replies
    0
    Views
    534

    default form to first or last record

    i have a button on my form that deletes a record and adds the record to another table and when it does that the form looks like this:
    158507
    this makes my find button 158509 search the [Order...
  10. Re: blank page on report when in print preview

    i figured out if i go to the headers and open the property sheet change the [force new page] to none for all sections
    158403
  11. [RESOLVED] blank page on report when in print preview

    158397 this button is linked to a report and when i click on it it is giving me a blank page at first158401 then when i click [next page] at the bottom it shows 158399 how do i get rid of the blank...
  12. Re: have a field on a form that keeps rounding a decimal

    i changed the feild type to a double and it worked
  13. [RESOLVED] have a field on a form that keeps rounding a decimal

    how do i stop this field from rounding to a whole number
    158009
    goes to
    158011
  14. Replies
    2
    Views
    639

    [RESOLVED] date button on form

    i have these date buttons i put on the form and now i have a problem with them being in the way when i click through other tabs on the form
    157553
    then when i switch tabs i get....157555
  15. [RESOLVED] taking out commas and quotations out of text file using c++

    here is the code im using, it is executing with out errors but not getting any desired results

    #include "stdafx.h"
    #include <fstream>
    #include <iostream>
    #include <sstream>
    #include <string>...
  16. Re: comparing table feilds with single value in combobox

    i fixed this problem by going to to property sheet for the combo box and changed limit to list to yes
  17. [RESOLVED] comparing table feilds with single value in combobox

    i am writing a code to throw an error if user types in something in combobox that is not in the table. how would i compare the Combobox value with the tables feild values
    here is what my guess was...
  18. Re: going back to default on combobox view

    thank you for the advice with a little research with google i found something that worked:
    Me![Combo970]= Null
  19. Re: going back to default on combobox view

    i gave this a try and had no luck
  20. [RESOLVED] going back to default on combobox view

    i have a combo box that i made for bringing up records on a form but i wold like the combo box to be cleared after the form has been populated any ideas on how this would be done?
    157119
    157121

    ...
  21. Replies
    1
    Views
    526

    Re: linking a report with a form

    i used this code to move the record to a different table then made the report off that table,


    Private Sub Command985_Click()
    On Error GoTo Err_Command985_Click
    DoCmd.SetWarnings False...
  22. Replies
    1
    Views
    526

    [RESOLVED] linking a report with a form

    i need to link the planning worksheet to auto fill from the order master. right now i have user typing in order number but would like to somehow link the me.[order number] from the form to the report...
  23. Replies
    6
    Views
    892

    Re: handling NuLLS

    i have missed your post suggesting what i can do to handle nulls
  24. Replies
    6
    Views
    892

    handling NuLLS

    i have this code that sucessfully works takes a record from one table and moves it to another, but when doing this is handling the null dates not as desired. it is putting default 12:00:00 am in in...
  25. Re: trying to insert record from one table to another keep getting errors

    156825
    got this error after using this code

    DoCmd.RunSQL "Insert Into [Archive] * Values " & _
    ' "('me.Order_Number',#me.[Date Entered Into...
  26. Re: trying to insert record from one table to another keep getting errors

    what should i use wih the yes/no feilds
  27. Re: trying to insert record from one table to another keep getting errors

    here is what the text data type is in every table
    156805
    he is ever number data type
    156807
    Text data type
    156809
    Yes/No data type
    156811
    Memo data type
    156813
  28. Re: trying to insert record from one table to another keep getting errors

    ok i have no exra table and made some changes till keep getting this error
    156803

    Private Sub Archive_Order_Click()
    On Error GoTo Err_Archive_Order_Click

    Dim Answer As Integer
    Dim...
  29. Re: trying to insert record from one table to another keep getting errors

    ok i changed my code to this , and now im getting a data mismatch error in the VALUES part of the code not sure if i represented String, integer, and date right

    for date i used = # " *...
  30. Re: trying to insert record from one table to another keep getting errors

    it had a primary key of the [order number] but i recently took the primary key off every table and still am getting the same error
  31. trying to insert record from one table to another keep getting errors

    here is the error message after i click the button
    156747
    and here is my code, both tables have the same structure

    Private Sub Archive_Order_Click()
    On Error GoTo Err_Archive_Order_Click

    ...
  32. Re: duplicate button with id feild that wont change

    You my friend solved the problem manipulated the field in the Duptbl after changing the criteria of that field only in that table
  33. [RESOLVED] Altering Date/time field in SQL to Now()

    i am trying to change the date in this field to be the date and time currently

    DoCmd.RunSQL "update Duptbl set [Date Entered Into Alvin] = now()"
  34. [RESOLVED] duplicate button with id feild that wont change

    i am trying to change a primary key that is the same as the previous record i duplicated and i keep getting an err.
    156463
    156469
    156471
    the ID field is an auto number field
    here is the vb...
  35. Replies
    4
    Views
    785

    Re: [RESOLVED] matching up data types

    what is parmeters
  36. Replies
    5
    Views
    1,206

    Re: Running SQL in VBA

    here is what i have so far

    Private Sub Duplicate__Record_Click()

    DoCmd.RunSQL "Delete * From Duptbl"
    DoCmd.RunSQL "insert into Duptbl select * from [Order Master] where [Order Number] =...
  37. Replies
    4
    Views
    785

    [RESOLVED] matching up data types

    hello im am trying to match up data types in a sql statement i know the date is # " * Me.Date & " # and a string would be " & Me.Customer & " ' i can not figure out what the rest would be, how would...
  38. Replies
    5
    Views
    1,206

    [RESOLVED] Running SQL in VBA

    Hello guys i have a duplicate button with some SQL code embedded into it and i cannot get the sql code to execute here is a copy of the code

    Private Sub Duplicate__Record_Click()
    Dim fullpath As...
  39. Replies
    10
    Views
    1,038

    Re: creating duplicate record VBA

    This worked now im tring to get my SQL code to run correctly

    onn = [order number].Value
    If onn Like "0000********" Then
    onn = Format(onn + 100000000, String(12, "0"))
    ElseIf onn Like...
  40. Replies
    10
    Views
    1,038

    Re: creating duplicate record VBA

    this code seemed to do the trick now i have to some how use a statement to see if the first four number are 0000 or 0001 or 0002 or 0003

    Dim fullpath As String
    Dim dirs(0 To 2) As String

    Dim s...
Results 1 to 40 of 56
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width