Search:

Type: Posts; User: freelance; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    473

    I have the following recordset: Dim rs As...

    I have the following recordset:

    Dim rs As DAO.Recordset
    Set rs = CurrentDb.OpenRecordset("SELECT Productid, code, categoryid,supplierid, size, ddu, grossprice,

    office,cons,vip,dealer,pref...
  2. Thread: Date part

    by freelance
    Replies
    4
    Views
    442

    Thank you for your reply ! It works just fine ! ...

    Thank you for your reply ! It works just fine ! Thank you !
  3. Thread: Date part

    by freelance
    Replies
    4
    Views
    442

    Sorry.Please do aplogize me. Hereis the...

    Sorry.Please do aplogize me. Hereis the attachement
  4. Thread: Date part

    by freelance
    Replies
    4
    Views
    442

    I have a report that shows the liters per quarter...

    I have a report that shows the liters per quarter for all the years and it works fine.I want however to have a report showing the liters per month and not per quarter for all the years.Also, i need...
  5. Thread: Last call

    by freelance
    Replies
    5
    Views
    397

    Thank you very much ! The query is perfect and i...

    Thank you very much ! The query is perfect and i thank you very much for that !!!
  6. Thread: Last call

    by freelance
    Replies
    5
    Views
    397

    Thank you for your reply.I got the following...

    Thank you for your reply.I got the following error with the sql:"The Microsoft Jet database cannot find the input table or query "select ClientID,Max(CallDate) as LastCallDate From CallsClients GROUP...
  7. Thread: Last call

    by freelance
    Replies
    5
    Views
    397

    I have 2 tables tblClients and CallsClients.I...

    I have 2 tables tblClients and CallsClients.I have a query with a field CallDate.
    SELECT [TblClients].[ClientID], [CallsClients].[CallDate]
    FROM TblClients INNER JOIN CallsClients ON...
  8. Replies
    6
    Views
    476

    You need to execute the same code in the On...

    You need to execute the same code in the On Current event of the form. This event occurs when the user moves to another record. The easiest way to do this is to call Command2_Click:


    Private Sub...
  9. Replies
    6
    Views
    476

    Try this: Private Sub CmdACustomer_Click() ...

    Try this:


    Private Sub CmdACustomer_Click()
    With Me.CmdACustomer
    If .Value = True Then
    .Caption = "customer"
    .ForeColor = vbBlack
    Me!LblACustomer.Visible = True
    Else
  10. Replies
    6
    Views
    476

    Why would you use a toggle button here? It's...

    Why would you use a toggle button here? It's easier for the user to click the check box.

    Thank you for the reply.
    Because i want to change the caption on the same button.When the check box is...
  11. Replies
    6
    Views
    476

    I want to have a toggle button that enters yes ot...

    I want to have a toggle button that enters yes ot no values in the table and changes the caption of the button.
    The button should be names contact but when pressing the value yes hsould be entered...
  12. Thread: visibility

    by freelance
    Replies
    2
    Views
    341

    Do you have list boxes ListCVL1, ..., ListCVL8?...

    Do you have list boxes ListCVL1, ..., ListCVL8?
    If so, add the following line inside the For ... Next loop:

    Me.Controls("ListCVL" & i).Visible = f

    Or do you have a single list box ListCVL?
    In...
  13. Thread: visibility

    by freelance
    Replies
    2
    Views
    341

    I have a wonderful function for making lables...

    I have a wonderful function for making lables visible and invisible.:
    Sub ShowCVL(f As Boolean)
    'ShowLabels True; ShowLabels False
    Dim i As Integer

    For i = 1 To 8 ' change to number of...
  14. Replies
    1
    Views
    372

    I have a problem with clearing the form.My...

    I have a problem with clearing the form.My functions worki only once but after that they stick.For example on pressing the button ltr the result is ok.After that on pressing the button drum the...
  15. Replies
    2
    Views
    371

    The Filter property should be a text string that...

    The Filter property should be a text string that represents the WHERE part in an SQL statement. Try changing

    Me.Filter = Me!ltr > 0

    to

    Me.Filter = "ltr > 0"


    Thank you for the advice the...
  16. Replies
    2
    Views
    336

    You could use code like this. It will toggle the...

    You could use code like this. It will toggle the visibility of text boxes and labels in the Detail section: the first time it is run, the controls will be hidden, the second time they will be made...
  17. Replies
    2
    Views
    371

    I get th error invalid use of null. Me.FilterOn...

    I get th error invalid use of null.
    Me.FilterOn = True
    Me.Filter = Me!ltr > 0


    I want to filter the form showing only the products with ltr>0
    Can yo hlp me with the error ?
  18. Replies
    2
    Views
    336

    How can i make visible and invisible all the text...

    How can i make visible and invisible all the text boxes and labels in the detail section of the form ? But not in the form header?
  19. Thread: make table

    by freelance
    Replies
    6
    Views
    473

    Andrew is correct, you can't do it all in one SQL...

    Andrew is correct, you can't do it all in one SQL statement.
    Alternatively, you could add the fields after creating the table:

    DoCmd.RunSQL "SELECT ProductsPanolin.CodePanolin,...
  20. Thread: make table

    by freelance
    Replies
    6
    Views
    473

    I am making a new table by copying fields from...

    I am making a new table by copying fields from the old table as follows
    DoCmd.RunSQL " SELECT ProductsPanolin.CodePanolin,ProductsPanolin.GradePanolin,ProductsPanolin.ltr INTO TblPricesPanolin FROM...
  21. Replies
    7
    Views
    553

    You don't have to remove the Euro sign by hand:...

    You don't have to remove the Euro sign by hand:
    - Open table2 in datasheet view.
    - Click in the grade column.
    - Select Edit | Replace...
    - Enter a space followed by the Euro sign in the Find What...
  22. Replies
    7
    Views
    553

    It works! thank you ! As i have written, the...

    It works! thank you !


    As i have written, the code

    StrSQL = "UPDATE table2 SET table2.price = Mid([grade],InStr([grade],'L')+2), table2.grade =

    Left([grade],InStr([grade],'L')-2)"

    works...
  23. Replies
    7
    Views
    553

    You can't store both values in the same field...

    You can't store both values in the same field 'pack' - you should use two different fields, e.g. 'pack' and 'size'.

    You could use code like this:

    To extract the last number (after the 'x'):
    ...
  24. Replies
    7
    Views
    553

    Your table doesn't contain a field named price....

    Your table doesn't contain a field named price. Before running the code, create a field price of type Currency in the table.

    PS it would be nice if you provided some feedback to the replies you...
  25. Replies
    4
    Views
    530

    Thank you very much for the fine suggestions they...

    Thank you very much for the fine suggestions they worked and i am pleased with the results!
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4