Recent content by shan_vba

What is a bypass key ? I didnt have such

I'm new to Access and vba I was experimenting the File > options on how to hide the ribbon menus and navigation options before giving the system I made for my client (Actually for my friend I'm doing for free) and I wento file > options and in ribbon options I hide the menus and kept only Home...

Thank you very much I could get it done.... I was finding for the property by selecting the section not the form.... Thank you all

Where can I find that property under format ? Other ? I couldn't find it

I have created some forms in the wizard and had done several stuff on them with VBA, and when I run them in the Form view they are opened spread and embedded inside access.... I need two things.. One is to get them opened as windows... and second things is I need to open other forms with buttons...

It was the same without Me.txt_OUT.Value = "" I added it as things were not working to see (A guess)

It worked Thanks a lot but it's wierd..... because those values are not strings as they could calculated instead of concatenated and even it worked when I was checking for 0 But any way I couldn't have figure it out without your advise....

In my small application There is a text box called TAKE OUT where user can enter a value and click the button so it will be deduced from the Quantity text box (Which is bound to the database) and this should happen only if the TAKEOUT value is smaller than the quantity other wise a message...

Thank you all for the support Code Tags Added by UG Private Sub Drug_Change() Dim Dbs As Database Dim Rst As Recordset Dim MyString As String Dim valId As String Set Dbs = CurrentDb() valId = Me.Drug.Value MyString = "SELECT Quantity FROM Summary WHERE Drug =" + "'" + valId + "';" Set Rst =...

No in that I changed the names to match the names in my form.. so the error is not due to that..... Why can't I do it with one table ? The purpose of this very simple application is to have two forms one is to enter data to the Summary table and the other is to In OUT operation where user can...

Thanks for the reply I tried the code below but still the qty text box becomes #Name? Code Tags Added by UG Private Sub Drug_Change() Dim Dbs As Database Dim Rst As Recordset Dim MyString As String Dim valId As String Set Dbs = CurrentDb() valId = Me.Drug.Value MyString = "SELECT Quantity...

Hello all! This is my problem I am currently having.... I have a table called "Summary" and it contains a fields called "Drug" and "Quantity" where I created a form by using the wizard and changed the text field of the drugs to a combo box.... and it loads the drugs in it... and there is another...

I no longer can see the header that's the problem

I'm a little lost in creating a new thread... Can anybody help please ? I need some problems to get resolved...

Thank you guys for the reply I opened the code builder for the button and add the following code Me.Quantity.Value = Me.Quantity.Value + Me.txt_qty.Value and it worked....