Search results

thank that will solve it but that leave all options open if a user need to edit the drop down. I guess you cant have it all, this solution is good enought.

How do you handle Non Active entries from the past past? Sample exemple. EmployeeID: AutoNumber EmployeeNr: Number EmployeeName: Text NotActive: Yes/No I have a combo box in one form that utilize the above table to allow user to select only active employee. my queries is select EmployeeID...

i suggested you create a another table to use as a log of user action that looks like this. then you create append query to append the the new records on click event of the chkbox. Pseudo code Private sub chkbox_onClick() docmd.runsql "Insert into log (ClientID,TimeStamp, Action) values ('' &...

in general the pseudo code looks something like this Find the total of records that need to be loop through. for i = 0 to Total -1 docmd.doEvents msgbox (i/total) next

with current theory it will work if the user add one item only. if the user add more than one item which item should be selected?. It may be more clutter but at least the user is aware of what is going on. On the note of that. if the user decide to use the combo box and not type anything in the...

i not sure of what you are trying to do. show me the result and i might be able to figure it out. From the look i would suggesting looking into dictionary object.

Please provide link or picture of databases that you have encounter or create that you feel fits the above description. I just want to see what creative people can do with MS Access. I will post picture of mine once i strip out all the clients information.

I have a suggestion but maybe it to late since you already have redone the forms but anyway here it is. With this method you dont have to worry about anything. Create a button or label control next to the combo box that says add. on click button or label add open the form they fill in but open...

on the unload event add the following code. Docmd.SetWarning false Docmd.Openquery "" Docmd.SetWarning true

How do you reset a combo box to the state when you open the form? I have a few combo box that are required fields. I know it works if i set combobox = empty but that will allow user to by pass the required fields criteria. and when i set to Null it says this field cannot be null. if i enable...

I have the following code Option Compare Database Option Explicit Private dct As Dictionary Private StrTest as string Private Sub Form_Load() dim rst as DAO.Recordset set dct = new Dictionary set rst = currentdb.openrecordset("qryMenu") while Not rst.Eof dct.add rst.fields(0), rst.fields(1)...

I have a table that uses a drop down menu let me illustrate my point a little more. Option 1: Table - Sales Order: SalesOrderID, primary Key-Autonumber CustomerID, long Options 2: SalesOrderID, Primary Key-Autonumber CustomerName, text Option 1: Table - Customer: CustomerID...

Create a Make table query with a group by on all the fields and you should get a new table with non duplicate. when you think you have it all replace the old table with the new table create from the query.

What better to store in a table the primary Key or the actual text? There is pros and cons for both implementation. i just want to get best practice. Primary Key as storing field Pros: faster search(using the full name, if they use Like statement this doesn't apply) Change one place and...

Thanks, that should do the trick as long as the picture is under the application folder can always use this to link them up even if i dont know where the exact path may be.

is there a way to get the current location of the database? I can link the pictures but the problem is I don't know the exact path as it will not be on site. My company has many different location.

I forgot to mention how are things from administrator perspective? it most be hard to delete or add something since this is a matrix.

i can create different table to hold the drop down options for different form or i can create a structure like this to do the same thing. Table: DropDown DropDownID, AutoNumber DropDownOption, Text Table: DropDownItem DropDownItemID,AutoNumber DropDownID, FK DropDown ItemNr, Number Item, Text...

If you are gonna write to every field in your table the query will look something like this private Sub SubmitBtn_Click() docmd.runsql("Insert Into project ('" & me.txtProjectID & "','" & me.txtProjectNr & "'....')" end sub if you are gonna write to only few fields use the following syntax...

I have front-end/back-end system. The front is pretty heavy as it has many pictures. What is the acceptable size of frontend application. Currently it is 10MB. What are the problem i may face if the front-end grows in the future as all the features has not been develop yet.