Search results

Thanks for the example. Can you possibly tell me how I can add the string to the underlying table. / I also want to know how you can add an item like "All" in the list box in your example to be able to show all the items in the report. I have a similar example in my database, but I filter my...

Do you think the new encryption tool in Access 2010 is a better way to create a password than just having a username and password table in the database?

Yes, you are right. The Multi Select property has been changed to Simple to be able to choose multi items. Well, I have days of the week in the list box, and I want to be able to select multi days. can you possibly let me know how I can write the code to read the items from the list and store...

I have designed a split database( with back end and front end), I am just wondering what would be the best way to put a password for both of the back and front end.

I have a list box on a form. The list box is bound to a field of a table. When I select a single or multiple items from the list, the selected items will not be recorded in the table. Can somebody help me to fix this problem?

How can I add clock control functionality to a form in Access 2010? I have tried the entire procedure in http://office.microsoft.com/en-ca/access-help/add-clock-control-functionality-to-a-form-in-access-HP001121061.aspx, but I get an error that says "a problem occurred while Microsoft access was...

Can I also make [ProjectApprovalDate] required to be filled, once the ProjectApproved filled?

Thanks CJ London. It worked.

I implemented the above code, but it did not work. I guess it is just because my field#1 is a check box. Here is the code that I have : Private Sub Form_Current() ProjectApprovalDate.Enabled = ProjectApproved <> "" End Sub Private Sub ProjectApproved_AfterUpdate() ProjectApprovalDate.Enabled...

I have two fields on a form. One of the fields has to be entered first in order for the other field to be filled. How can I restrict the user to enter a value in filed #2 before filling the filed #1?

I found the following code from one of the replies in this website. I just want the "RecordCount" to be dynamically changed according to my query value. Please let me know if this is possible. Private Sub Form_Current() If Me.NewRecord = True And Me.RecordsetClone.RecordCount = 5 Then...

There is a field on my Order form that has the # of product requested.

No, The main form has multiple packing slips ID on it. Products has their own form.

Well. I have an order form(grandparent) that has a subform called "packing slip"(parent). Once I double click on a row of the packing slip subform, a seperate form called product form(child) will pop up. So, order has multiple packing slips, and packig slip has multiple products. I want to limit...

I want to limit the # of records being entered in a form according to a limit value which has to come from a query. I greatly appreciate it if you help me how to code this.

I have a split form design. I want to hide a field which I have already set a default value for. But when I make it invisible, the default value is not being recorded. Is there anyway, I can fix this problem.

Sorry, I may not understand correctly. I created both the above queries in the Northwind database not for the same tables mentioned in the above example, but for Product Table (Product Id and Units In Stock) as an example. When I run the query I get same ranks for the product Ids that have same...

Thanks jdraw. I read and practiced the instruction in the link. Just a couple of things: 1)this instruction does not break the ties, It just ranks according to the values 2)How can I break the ties according to second and third criteria?

Just to clarify, my current query has the following columns, (project-ID, project priority#1, project priority#2, Score). The Score column is simply the addition of priority#1 and priority#2.

I have a score column for my data in a query. I want to add a rank column beside it to rank according to the scores.I also need a way to break the ties using 3 other criteria, which are all dates. I appreciate it if you can guide.