Recent content by xolo

Yes. I want to have default value of "Date()" for the date part and "#23:59#" for the time part. In case the user enters or updates the date text-box with another value, the time part will still be #23:59#, and vice versa. I need these two text-boxes act like if I had this date with two fields...

I am building my own program for my 2 retail shops using Access 2007 and it's about 70% finished. But lately a person told me that Access is very slow compared to Microsoft SQL or MySQL when dealing with a lot of data. One shop of mine has hundreds of transaction a day, so I am wondering if this...

I had exactly the same problem before. What I did to solve it is to use this: Private Sub Form_Open(Cancel As Integer) InsideHeight = [some number] InsideWidth = [some number] End Sub I hope it helps.

Thanks David, But isn't it only to display the field's value? I want also to input the field from the same text boxes.

I have a "general-date" field but I want to use two text boxes to input and display the field's value on one form. One text box is for the date part and the other one for the time part. What is the best way to do this?

The Replace function does the job perfectly! Thank you!

I want to change the state of "ribbon startFromScratch" to "False" when it's under development and to "True" when it's ready to install for the user. So I want to have a button to set this state when the next time the application is opened.

Is there any way to assign "ribbon startFromScratch" property from VBA?

Thanks a lot Bob!

How do I refer to a control on a subform (with variable names) using something like this method: Forms(FormVariableName).Controls(ControlVariableNames) in VBA?

I had the same problem and I fixed it with "me.Visible = True". Thanks! :D But how do we solve it with the control? I keep getting this: "Run-time Error '2474': The expression you entered requires the control to be in the active window." My Sub is like this: Private Sub Form_Load() Dim...

Is it possible to use "LIKE" with DoCmd.FindRecord? I am trying to find record(s) on a form that meet some criteria called from a pop-up dialog box.

Thanks! My problem was to find the right syntax to call the VARIABLE name. Now that should help me, I will give a try!

How do I use SetFocus to a control with variable name from another form?

Thanks gemma!