Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    458

    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
    433

    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
    433

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

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

    by freelance
    Replies
    4
    Views
    433

    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
    385

    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
    385

    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
    385

    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
    465

    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
    465

    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
    465

    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
    465

    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
    332

    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
    332

    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
    364

    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
    360

    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
    329

    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
    360

    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
    329

    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
    457

    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
    457

    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
    547

    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
    547

    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
    547

    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
    547

    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
    517

    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