Search results

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

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

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

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.

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

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?

How can I use append queries to add records into 2 tables (with 1 to many relationship and autonumber primary key on parent table)? The Autonumber is set to "Random" and the tables have already some records before.

I have forms with format settings: Border Style: Sizable, Control Box: Yes, Close Button: Yes, Min max Buttons: None. The strange thing is, when I open it with "maximize" from a Switchboard: the Control Box dissapears. It is even more strange because it happens with some forms only. As with...

How is it to add a record in the subform without typing anything on its parent form? In this case, the text boxes on the parent form will be automatically filled with their own default value once someone type in on the subform. Thanks!

I have a "Purchase" form and a subform in it. When I delete record(s), I want the stock quantity of the related product(s) in the "Product" table to be deducted the same quantity as what was stored on the "Quantity" field in the subform. With this way, the stock in the "Product" table is always...