Search results

I want my database user to enter a record thru a wizard. in step 1 he should put in the product info, in step 2 - price info, in step 3 he confirms the new record to be created. What's the best approach to enter 1 record through many steps?

_______________________ Wow, just discovered this 7 years ongoing "story"... Can I see somewhere the whole story in a glance? or I have to go through all the 308 pages (which I wouldn't do)?

My continuous form will contain hundreds of records, and growing. As far I understood before your last comment, i thought I'll have to create a single form and set hundreds of records. After your previous comment, I tested your DB and realized that I just have to fill 1 page. I'll check it out...

I'm Using 2010 and it's not any better. I tried setting the "Picture" property to "Me.BoxCombo.Column(2)" but no, it asks me for an actual file name. Thank you anyway John for sharing your great ideas. I'll try my luck in a new post.

Thank you John, good sample. However, I have a problem. I'm trying to do this in a continuous form and when I use your sample, ALL records are being changed instead of only the record selected. Is there a small change I have to make in it? EDIT: I got it, I had to select a Control Source...

I am working on a "Toners Bought and Sold" database with a "Box" field keeping track if the toner was bought either normally packaged ('Closed' box), in an open box ('Open' box) or without a box ('No' box). I have 3 BMP files saved on my computer, 1- a closed box, 2- an open box, 3- a big X...

:( No solutions?

Should I guess that Vista and Windows 7 are the problem???

"Readystate" didn't help either. I'm not as pro to be able to answer on the "Iwebbrowser2 is part of the WinInet dll" question. Wondering if there's anybody able to solve the mystery ... t'would be greatly appreciated.

Can anybody please help me? In MS Access, I'm trying to open IE, navigate to Google.com and set my text in the text box. I don't know why it's not going. I used: --- Function OpenIE() Dim ie As Object Set ie = CreateObject("internetexplorer.application") ie.Visible = True ie.Navigate...

Sure it helps! Thank you for the satisfying answer, and for sharing your knowledge with others. Well, I got some problems with the new macro design in 2010. After creating a product, customer couldn't run the Macro in 2007, I had to change the macro to VBA.. and there's no option of Save As...

Thank You Gemma!!! Thanks to your reply I got the solution: I just had to write Null without any quote or & sign. RemoveNumber = "UPDATE MyTable SET MyTable.[MyCheckbox] = No, MyTable.NumberField = null WHERE (((MyTable.[MyCheckbox])=Yes));"

How do I enter 2 Double Quotes ("") in a String next to each other? I want VBA to run a SQL statement to Update my number-field to "empty". Here's my exsample: RemoveNumber = "UPDATE MyTable SET MyTable.[MyCheckbox] = No, MyTable.NumberField = "" WHERE (((MyTable.[MyCheckbox])=Yes));"...

Bob, thanks forn the strSQL idea.

Thank you Junkie :cool: I have 2010, I followed your instructions starting with an IF action, everything went nice and dandy. May I ask you: It's interesting to me, in CheckBoxes I know that "Yes"/"No" stand for "0"/"1" or "-1"/"0", From your example I learnt that in the MessageBox "Yes"...

DoCmd.SetWarnings False

Month: =Format(Month([DFDateRaised]),"mmmm") Date: =Format(CDate(Month([DFDateRaised]) & "/" & (Day([DFDateRaised]) & "/" & (Year([DFDateRaised])))),"mmmm/dd/yyyy")

Let's take the M/D/Y for example. Add Before the expression: "Format(" Add after the expression: ","mmmm/dd/yyyy)"" Date: Format(CDate(Month([DFDateRaised]) & "/" & (Day([DFDateRaised]) & "/" & (Year([DFDateRaised])))),"mmmm/dd/yyyy")

Insert a Field in the query. In the first line enter the following text (without the outside quotes): To get the DATE of a M/D/Y field: "Date: CDate(Month([DFDateRaised]) & "/" & (Day([DFDateRaised]) & "/" & (Year([DFDateRaised]))))" To get the DATE of a D/M/Y field: "Date...

Thanks, I'm in middle on trying to use the RunCode function. RunCode: MsgBox("My Message",4) Yes/No Dialog Box appeared successful. Now I want to use "If" function to either continue or cancel running the Macro. How does the "If" argument have to look about? Or maybe a different approach is...