Search results

Hi All, I have an access database which import the .csv file but after importing it is creating the tables "google_ImportErrors" If i won't delete this, for next time i would open the database it will create the tables and follow the same sequence like stated below and it increase the size of...

Hello there! I have an Access database that contains Orders and its delivery status with the sub table Products that have relative records of the order, I want to Auto Create the New Order with the Same Products (sub tables that have foreign key of Order Id) on the order due date, any idea how...

Hello All, I need your help regarding the database in Ms-Access, i have an IP Address table that contains IP Addresses Ranges with the Country name and have the following fields! Id=AutoNumber StartIp=Text EndIp=Text Country=Text I have another table that fetch the data from the website like...

Thank you for highlighting the mistake but i have tried this, it is giving me the same error, please help me why it is giving me the error of The Expression you entered is too complex! Value...

I have a crosstab Query in Ms-Access where i have set the Value Property based on Combo Box Selection, below is the Expression Builder code that worked fine, but when i want to add 03 more Criteria, It give me the following error? The Expression you entered is too complex?? This Works fine...

Hi All, i am stuck in the situation that, i have multiple tables and i have join these tables by using union queries, now i have created a new table tblcriteria which i want to use for applying criteria to these queries? Please guide me is it possible to apply criteria from table fields (the...

Hi All, I have made Custom Shortcut Menu in My Access Database by using Macros Option, I have buttons on my form, When i click on any button using the left click of my mouse i want to show my shortcut menu bar, i am stuck i dont know how to do that? Right clicking on the form or button is...

Are you talking about Goods Management in Ms-Access, The Best Goods Management database in Ms-Access is on the following Microsoft website: Download Goods Management Template compatible with Ms-Access 2010 and furthermore I have completed my Project of Real Estate Management in Ms-Access.

Hi there, I love this forum and its my only choice for solution! Project Background I am working on Employee Management Software, In short i have setup the software with Bio-metric Attendance machine getting employees attendance, it give me attendance of those days where we can punch our thumb...

Hi there, I have made custom shortcut menu bar for different controls. I want to automatically showup the Shortcut menu bar when the Textbox Got focus. The Shortcut menu bar is appearing by right clicking on textbox by default. Please tell me how to automatically showup the shortcutmenubar when...

Hi, I have an Attendance Machine Installed having Face Recognition/ Biometric Function, The Software came with this attendance machine, backend is based in Ms-Access, I want to make some reports according to my requirement, The issue is that i want to connect the machine and retrieve data...

Hi there, I am setting up the criteria for my Query tfrom form to show the result if it meets the criteria of showing payment but not yet paid to show me all the records having [Total Net Paid] is null, "Required but Not Paid" is the requirement for which whose result would be showing all record...

Issue Resolved by adding as Output: Sum(IIf(IsNull([Forms]![Search]![Dropdown]),([Total Net Paid]),([Discount]))) and setting it up as Expression and Value for Crosstab Columns. Thanks

Hi Everyone, I need some guideline in crosstab queries, i want to set the criteria through form named as "Search". I am trying to display the total net amount, if Dropdown value in form "Search" is "Total Net Amount" and if the User select "Discount Only" then it shows me "Discount" values, I am...

Hi everyone, please help me in making a dynamic query with yearwise column heading, i want to show the column years in sequence, if there is no data for any year ms-access is skipping that year from the query column heading, i want ms-access to dont disturb the sequence and show the column head...

Hi everyone, please help me in making a dynamic query with yearwise column heading, i want to show the column years in sequence, if there is no data for any year ms-access is skipping that year from the query column heading, i want ms-access to dont disturb the sequence and show the column head...

Thank you All I tried that code and it worked for me. If Me.lbl.Caption = "Show" Then Me.password.InputMask = True Me.lbl.Caption = "Hide" Else Me.password.InputMask = "Password" Me.lbl.Caption = "Show" End If

I tried: If Me.lbl.Caption = "Show" Then Me.password.InputMask = True Me.lbl.Caption = "Hide" Else Me.password.InputMask = False Me.lbl.Caption = "Show" End If

No this trick worked on one side, i tried but it could not worked to UNDO the mask to the first level that it was before "****", It will remain as "1234"(example). The caption is working great but the Input Mask wont be applied, any idea

Thanks that worked in one side, but when we repress the button when its caption is set to "Hide" from "Show", it could not set the Input Mask Property to its default i-e Input mask=true