Search results

Hi, May be some one specifically knows about this problem and solution. I am using SHA256 hash function for password and some other things (app security). This function has been working fine, without any problems for the last 3 years, with mutli-User app (more than 35 user accounts). Hashed...

I am using following code to prevent access to autosave data, unless I press save button. Form top Private SaveRecord As Boolean Form Current SaveRecord = False Form Before update If SaveRecord = False Then Cancel = True Me.Undo Cancel = False End If cod on Save button (on click)...

Looking for a way to have resizeable column width in listbox or continuous form or continuous subform. It will be exactly like datasheet columns which are expandable, though I can use that datasheet but I dont want to use filter, the way datasheet works. I will use clickable header to sort...

I have tree view which shows categories and sub of subcategories. Which I would name it as "Product groups" - Main form name (having tree view of product group) : ProductGroupF - Subform name : ProductDetailSubF (bound to query "ProductDetailQ") Two tables: 1st table -- "ProductGroupT"...

I have subform on Mainform. Normally subform on the main form is far right and looks like a thin line (collapsed completely). There is button on Mainform, this button can be for any thing like add edit etc. But basically this button is only expanding the form. I know there are many ways, smooth...

I want when I click on specefic field I want the action that sepecfic record set only but not on the whole column. Let me say briefly, but dont ask why all this. I have set of colours in a table (ColorsSetT) ID from this table will be saved as foreign ID in different tables like categories, for...

I want the ms access application window size to be fixed (height width etc) on restore command only. On close I am using command DoCmd.RunCommand acCmdAppRestore But this restores to the size where user has already stretched the application to whatever extent. Meaning this restore size will be...

A form (Form1) has a subform (subform1), and this Form1 has combo to filter the records of subform1. it works perfectly fine with the following example syntax. [Forms]![Form1]![SubForm1].Form.Filter = "Status= '" & Me.cboStatus & "'" [Forms]![Form1]![SubForm1].Form.FilterOn = True I have...

I have continuous form with records, I want to filter. Continuous form (Articleform) datasource is query. I am using query filter as we use it for list boxes using following criteria. Like "*" & [forms]![ArticleForm]![txtSearch] & "*" And form has unbound text field being used for text to...

Based on the articles (linked below), I created tree view of category. I am trying to filter records in list view based on Nod selected, so far I have no success. Sample db is attached, if some one can help me out. I want 1) Based on category selected - records in list view 2) if possible, want...

I came to situation, where I had to ask to increase my knowlege. I this is very basic question, but I am learning. Database is about articles, suppliers etc. It has three levels of categories. CategoryMain, SubCatLevel1, Subcatlevel2. Not all the subcategories of level1 are further...

1) I want to stick with ms access as front end, because I am used to it and its ease. 2) I always have multiuser interface, login system I want if users have their front end they should be able to login to perform tasks from any where via internet connection. AWS: To test I tried it as back end...

1) I have a form with listbox (query sourced), results are filtered on search. 2) Click on any record in lisbox, populates form data, on ID (ID_ArticleDetails) match basis. 3) form has two comboboxes, which are autopopulated as of point 2. 4) these comboboxes have bound column of ID, while user...

Want to prevent duplicate entery including extra/less spaces. with follwoing code, duplicate entery is prevented including case sensitity. I am wondering if it is possible to prevent with extra or less space. For example: Test1 or Test 1 1st one has no space, 2nd one has space. is it also...

I have timer on two forms. 1) login form (after user logs in -- this is hidden but not closed) 2) Dashboard (on top right corner it shows, count down time, but on activity time restarts) code on timer is below Timer interval is 1000 Both forms have same code, except login form wont show...

Main form has subform. This subform is filtered some filter parameters on main form via query. Subform is continous form. One of the field on a subform is "AccountNo", In a single search result, if in all records under "AccountNo" are not same, I want a msgbox. eg, Four different account...

I have a form with listbox, based on query. I have two option groups on my form, and want to combine filter result, to show filtered result same time, if I toggle between options. Option group with Frame155 filters status of Articles Option group with Frame173 filters date criteria Because...

I have Form sourced from query with 3 filtered based on Form value. Filters on form are 1) combo1 value 2) combo 2 value 3) date start and date end and para meters in query are [Forms]![MainFormWithQuery1]![cboCompany] Between [Forms]![MainFormWithQuery1]![txtStartDate] And...

I am looking for a way out to source ms access application icon from ms access table itself. Normally icon file is kept with backend file. But in this case it will be user choice to replace it, which I dont want. Is there any way out source it from backend table itself? Thanks

I have form based on query and want to send its reocord in email body but not as an attachement. Form is continuouse, its record is filred based on query. It can be hardly 5-8 rows daily, and I want to send that per email. Earlier I am sending this one by one, so users receive many emails...