Search results

Thank Mark for replay. When I use your suggestion I got run-time error '424' Object required. Previously I had run-time error '3075' Syntax error (missing operator) in query expression: "[Devices].[DeviceID] = [Receiving].[DeviceID] INNER JOIN qLocation ON [Receiving].[ReceiveID] =...

Hi All. I tried to run report and used such code: Private Sub lblDelivery_Click(Sql As String) Sql = "SELECT Receiving.ReceiveID, Receiving.Date, Devices.Device, qLocation.Location, Receiving.Amount" & _ "FROM Devices" & _ "INNER JOIN Receiving" & _ "ON Devices.DeviceID =...

Hi All. Can someone show me how to code it. Thanks.

Thanks for replay. When I click the label color is changed, but I would like when MouseUp color change and when mouse out label retrive previouse color. My current code is: Private Sub lblSummary_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.lblDelivery.ForeColor...

Hi All. I crated form with 2 lable. When user click lable he/she has ability to open report. How to chage a color of lable when mouse up on a lable? Thanks

Thanks a lot very helpful.

Hi All. I have form with command button to delete record. All work fine except after I receive my confirm to delete a record I'm goting MS Access confirm like: "You are about to delete 1 row(s) from the specified table. One you click Yes, you can't the Undo command to reverse the changes". How...

Thanks a lot for help. That event for the form. And what code for the buttons? Also when I try enter some data buttons didn't change caption. I did exactly like you sugested. Thanks.

Thanks for replay. I will appreciate if somebody show me how to do it. Thanks.

Hi All. I have simple form based on Device table with 2 buttons. And would like to change caption of the buttons when user enter data to the form. When user open form Button1 is disable and has caption Cancel. Button2 is enable and has caption Close. When user start enter data Button1 become...

Hi All. I try to create Inventory DB. I have qRequest quiry that display amount devices that was requested by users and qReceived quiry that display total amount devices which was received. I would like create form to display Balance ([received] - [requested]). How to do that? Thanks.

Hi All. I would like to import Access report that has two totals in page footer. I highlight my report then in menu use Tools -> Office Links -> Analyze with MS Excel office create Excel file of my report. But I have only one total. How to decide that problem? Thanks

Hi All. I have total calculation in Access report. But after export it to Excel I can't see these totals. Thanks.

Hi All. I would like to create Search form. That form will have 3 textbox (Insur#, FirstName, LastName), Search button and listbox. When user will like to find some records then he/she will call Search form type searching data in textboxes, click button and listbox will display information based...

Hi all. I would like to create simple form with combobox. When user select value in combobox he will run preview report accorting that value. For instance, combobox has list of employee names and when name is selected user can display report filtered according name. If it possible how to do...

Hi All. I would like to insert 3 check box in Word file. And I would like if user check one box other 2 becoming uncheck. If say shortly only one check box posiable to be checked. How to do that? Thanks.

Hi All. I created condition for form when fields are empty the button is disable. But it works in case with one field. When user enter data in one of the field button become enable. I would like that button become enable only when all fields was filled up. And button is disable when user open...

Hi All. I would like to create a form that remind user which record is not complete. Some times user don't have ability to fill up form completely and need wait couple days of addition information. In that case will helpfull reminder form to display number of record. How to create form with...

But those fields we took from a table. Do we have ability to bind their and writing to the table? How to do bound fields in our case? Is it posible? Thanks.

Hi Moniker. Thanks for help. Can you show me how to save values of Field3 and Field4 in the table A? They look OK on the form but table fields are empty. Thanks