Search results

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!

Never mind! I've just solved it by using this: Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 3200 Then MsgBox "Some message..." Response = acDataErrContinue End If End Sub

How do I get rid of this warning: "The record cannot be deleted because table ... includes related records." and use my own msgBox fuction instead?

No, it returns "dd/mm/yy" format, exactly like I want.

When I checked in my "InvDate" field in the "Inv" table, Access stored it as 39923 (serial date) which is supposed to be "April 29th, 2009". So I wonder why it returns 0 (December 30th, 1899) when I call that function. Maybe there is something wrong with my codes? I still want to use...

I have similar problem. I am trying to retrieve the date in my invoice where the price is at the highest. My windows sytem date is "dd/mm/yy" and all the date format of my project is also "dd/mm/yy". My codes are something like this: Function FDate(vProductID As Variant, Optional vAsOfDate...