Search results

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)...

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...

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

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...

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...

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...

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...

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

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...

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

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...

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

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)

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

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...

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

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

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...

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 & "...

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)