Search results

  1. D

    x-axis problems

    hey guys, im new to creating reports. im hoping someone can help me. im trying to create a report with charts. heres what my situation is: i have a table with the responses to a survey. when the survey results are inserted to the table, i only enter the codes, not the strings (ie. ans1 = 0 or 1)...
  2. D

    Enquiry on Checkbox

    check to make sure your if then statement is working correctly (you can do this by putting in a msgbox or debug line). usually the values of a check box (by default anyway) are -1 and 0. how are you sending the insert to the table (is the form bound or are you using docmd.runsql with a sql...
  3. D

    Question How to edit records in tables based on input from Forms

    maybe create a sub procedure for the onclick event of the button sending the sql statement. when the procedure is called, check the value of the combobox. if yes, do the sql statement, if no do something else
  4. D

    Enquiry on Checkbox

    is the databound to your form? if so, i think you can just change the "allow addition" ,"allow deletions", and "allow edits" properies. if the form is not databound, and your manually changing the table with sql statements, just put an if..then..else statement to check the state of the box and...
  5. D

    SOS plz Help

    i also always have a procedure i can run that will reset everything if i screw up: Function DebugMe() On Error GoTo errorhandler Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = True Next i 'reset all toolbars DoCmd.SelectObject acTable, , True 'unhide the table...
  6. D

    Error if nothing selected in Combobox

    error handling so it works if the combo's have a value? are you handling errors? if not, just catch the error and do something with it. to do that try: Public Sub SomeSubOrFunction On Error GoTo errorhandler 'your code.... errorhandler: If Err.Number = 0 Then elseif err.number = 25...
  7. D

    Calendar View in Access Forms

    yeah, its doable yeah, i created a calendar similar to that awhile ago. it took a long time. then, some a** hole stole my laptob :( anywho, i had the calendar attached to a table so appointments could be stored, settings saved, etc. although i dont have it anymore, i still remeber a lot of...
  8. D

    how to test string for proper formatting

    duh yeah, that should work. why didnt i think of that lol
  9. D

    how to test string for proper formatting

    hey everyone. i was wondering if anyone knows how to test a string to see if its formatted corretly. on a form, before sending it to the table, i have a field for Date of birth. because some of the people who will be filling in this form dont know their birthdays i need to be able to take in...
  10. D

    Programatically deselect a combobox?

    eek sorry, ive got 5 projects going right now. three in vb.net and two in access. i guess im getting old :0) ...dreamy... lol
  11. D

    Filtering -- Button-triggered or another way?

    ok, lets get started first, you should no im no expert and im sure my code and process may not be the best way to deal with the problem. also, if i read your question right you have this scenario: on a form you have a list box with a bunch of values. you want the user to be able to type a...
  12. D

    Coding help on Search function!

    i believe the word "Table" is reserved. you can name your table Table and reffer to it in your code. call it something more meaningful
  13. D

    Using A "SELECT" SQL command in VB from within access?

    something like this maybe: Dim sSql As String Dim MyRecordSet As Recordset sSql = "Select ItemName from ItemData where ItemName = 'whatEva'" Set MyRecordSet = CurrentDb.OpenRecordset(sSql)
  14. D

    Any help would be appreciated docmd.findrecord

    im not sure if this is it but: when you pass 'asset' between the functions are is it by refernce or value? im just thinking of how its done in vb. if you pass by refference you lose the value i think
  15. D

    SQL & Array - Is this possible??

    hey, any luck yet? im been looking at this post for awhile and its just hurting my head lol. could you list all the things you want to happen in order. ie: step 1 step 2 step 3 if step 3 = what ever then step 4 else step 5 if not: it sounds like you want to take all the data from your...
  16. D

    Programatically deselect a combobox?

    or better yet, if youve set the default in the forms properties Me.Combo3.SetFocus Me.Combo3.Text = Me.Combo3.DefaultValue
  17. D

    Programatically deselect a combobox?

    try: Me.Combo1.SetFocus Me.Combo1.Text = Me.Combo1.ItemData(0) 'this will reset to the first item in the ' combo. change the number to select lower in the list
  18. D

    Filtering -- Button-triggered or another way?

    are the records being shown in a listbox? maybe put a textbox(if you cant anticipate what they might filter on) or combo box (if you can) on the form with a button. when the button is clicked youll take the text from that control and build a sql statement. now set the listbox's data source to...
  19. D

    Format Text Box

    try this well, i dont know if you can do it right in the textbox (im sure im wrong). but what are you doing with the string? why not try this, when you send the form, take the text from the text box and concat the three space. ex: Dim GetString as string GetString = me.textbox1.text & "...
  20. D

    Code on form

    i think all you would have to do is just a cancel button (just run through the wizard when you place a button and select close form action)
Back
Top Bottom