Search results

  1. a.sinatra

    Using wildcards

    But because of the two asteriks, it searches everything, so i wouldnt be getting any different results because my query is set up like this.. "Like [txtSearchFind]" correct? ________ Porn
  2. a.sinatra

    Combo box - data displayed in columns

    you have to set the column widths like 0;2.1;3;1;2.6 and then you have to set the width, it should say auto, but add the numbers in your widths to equal the width :D ________ Rambler marlin history
  3. a.sinatra

    autoincrement field with added numbers

    But you could do this, leave the autp number alone, add a new field, and set the default to "=Date()" that what you could use that information how ever you like :D ________ SEX VIDEOS
  4. a.sinatra

    What am I missing??

    Private Sub Form_Load() Me.TimerInterval = 2000 End Sub Private Sub Form_Timer() If Forms![Frm-Splash].TimerInterval <> 0 Then Forms![Frm-Splash].TimerInterval = 0 End If DoCmd.Close DoCmd.OpenForm "Frm-Main Form" End Sub That shoud work, if you want to get...
  5. a.sinatra

    custom msgbox??

    Damn. I got last place :p Learn something new everyday, i though select case could only call numbers :mad: (my stupid oracle teacher) ________ LAMBORGHINI JARAMA HISTORY
  6. a.sinatra

    true/false or what

    Or you use a field "Night" and in your forms use vb... Night = -1 Day= 0 :D ________ VAPORIZER REVIEWS
  7. a.sinatra

    User Interface

    Have you tried using white or a light silver color in your little menu bar with the images behind the text? Its kinda of clashing colors to me. Just a suggestion. :D ________ LAMBORGHINI CHEETAH
  8. a.sinatra

    Access 2003 Security

    From the menu bar... Tools Macro Security... Then set the security to low, thats should stop them from popping up :D ________ Xjr-15
  9. a.sinatra

    On-Format problem

    Sounds like the code changes the relationship between the two ("A" & "B") in your query for that report. Ss the relationship between them correct in the design view of the query? Sorry i cant say much without actually seeing what data duplicates. ________ Chevrolet Chevette
  10. a.sinatra

    Table Documenter question

    Have you checked the field type on the database tables to see what they read? ________ Full melt hash
  11. a.sinatra

    User Interface

    "Print Screen" or if you have a modal "Alt+Print Screen" it will capture only that window Then you would open paint or imageing software, paste, then save (ms paint works) ________ Easy vape vaporizer
  12. a.sinatra

    Clear fields on a continuous subform

    I once had this problem before, i didnt want to struggle with it forever, so i set it up on the click of the save button, that the form would acCmdSaveRecord, then it would close the form, then reopen it. Theres probably better ways like a me.form.refresh then a Me.subform.refresh then requery...
  13. a.sinatra

    Hiding Field on Certain Conditoin

    We'll i assume your talking about a combobox, so this is what the code would look like to enable and disable that.... If Me.Decision = "Suspended" Then Me.Date_From.Visible = True Me.Date_Till, Number_Days.Visible = True Me.Suspension_Type.Visible = True...
  14. a.sinatra

    true/false or what

    tblEvents ---------------------------------- DayNightID (number long int) (fk) [many side] tblDayNight --------------------------------- DayNightID (autonumber) (pk) [one side] DayNight (text) Set up the relationship You would enter 2 values into DayNight.. "Day" & "Night" an id for each...
  15. a.sinatra

    Review my DB

    Hrm. Maybe i should of worded my post better, the SS was nearly a suggestion. I am not the creator of the db :D ________ FORD 999 SPECIFICATIONS
  16. a.sinatra

    syntax error in query

    SELECT COUNT(B.CASE_ID), SUM(A.AMT_TO_DISTRIBUTE) AS [HELD AMOUNT], [NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE], [NOLDBA_RECEIPT.CD_REASON_STATUS] FROM NOLDBA_INT_CASE_STATUS B INNER JOIN NOLDBA_RECEIPT A ON B.CASE_ID = A.ID_CASE WHERE (([A.CD_STATUS_RECEIPT] = "H") AND ([A.DT_DISTRIBUTE ]=...
  17. a.sinatra

    custom msgbox??

    Private Sub cboBox_AfterUpdate() If Me.cboBox = "Active" Then MsgBox "Active" ElseIf Me.cboBox = "Pending" Then MsgBox "Pending" ElseIf Me.cboBox = "Retired" Then MsgBox "Retired" ElseIf Me.cboBox = "Lost" Then...
  18. a.sinatra

    Review my DB

    What about a better look to the switchboard? Lemme know what you think, see attached. ________ Ford Motor Credit Company
  19. a.sinatra

    Access db that can be set up like a stopwatch

    Who is that directed to? We're all doing something different i assume. But if it was towards me, i just needed a simple, yet effective way of logging work hours at home. And it doesnt cost $100USD+ and I MADE IT! (just a feeling i get) :D ________ MEDICAL MARIJUANA NEWS
  20. a.sinatra

    Access db that can be set up like a stopwatch

    I thought about the exact thing, but since i will be only using this for personal use, logging my time, i found that no resources were hurt, my cpu remained at 0%-2%. And i kinda liked seeing time "go" This is what i made for myself, i guess you could rework it for yourself, have fun! The only...
Back
Top Bottom