Hello everyone, I have two Combo Boxes that I've made required. When the user goes into the form to populate the two fields and save, they are told that the...
Dawn Can you check the Control Source of the combo box if it is really set to the required field? Sometimes it is possible to set a wrong control source when...
Hello Liveson, I've gone into the table and added the year without problem. The Required field is yes. I'm just not sure why this is not working. Thank you...
Dawn How about checking the Control Source property of the combo box? Is it really set to the correct field with the property "Required" set to "Yes"? Just try...
Hello, I'm not sure what is wrong with this. I think I'm going to have them just populate this field themselves. LOL. I'm so frustrated. Thank you so much...
Dawn You seem to be getting quite weird problems with your database. If the formula is in the control footer or the report footer and the control source is...
I am having some trouble to just to populate two list boxes vendors and products I generate the code, the computer don't like it. Me.Products.RowSource =...
I am struggling to import a three column list of data,less than 100 records from Excel into a three field table in Access. I'm sure I've done this in the past....
Neil Try higlighting data and headers only and past into a new sheet, then import the new sheet ...... you may have a field other than your data that is being...
Hi everybody, I need to create a command button to make a backup copy my whole program to another location. I've tried everything but it just didn't work. Any...
I don't seem to understand why you have Me.Products=Me.Products.ItemData(0) at the end of the SQL statement. Is this part of the criteria? In addition, if...
Need help here please (didn't get any help with my previous question). I tried using the macro command for CopyDatabaseFile but to no avail. Can someone out...
can you please give m that example in the coding. Me.Products.RowSource = "SELECT ProductName FROM" & _ " Products WHERE VendorID = " & Me.Vendor & _ ...
Hi, I need to capture value of a text box and based on that search and display rows of data. Something like a search button with data displayed in the same...
I don't seem to understand why you have Me.Products= Me.Products. ItemData( 0) at the end of the SQL statement. Is this part of the criteria? In addition, if...
I think the SQL statement should be "SELECT ProductName FROM Products WHERE VendorID = " & Me.Vendor & " ORDER BY ProductName;" (Please note the use and...
For the books database I will try the coding you sent me What I would like to achieve is have the one combo list box for the author, the other one for the...
Hi, I have a field (StudID) that has numbers but they are surrounded by quotes e.g '123456' Is there a way in a query that I can remove these quotes so that i...
Ian Use the Val function to convert a string to a number. For example Val('123456') returns 123456 and Val(123City) returns 123. So you would have Val(PutYour...
The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize...
I have descended into Access HELL. I have a small database with an AutoExec macro. I got this annoying message every time I opened the database telling me that...
I see 2 options of solving this problem and maintaining that numeric field: 1. Change the numeric value to text in the process with the str() function; or 2....
RESOLVED: Error was discovered in a Link Spec to one of several link tables. An old spec that had been corrected in an earlier coy failed to carry forward...
Hello, I'm new to Access. I need to create a button for the end user that will prompt for the quarter and year, then it will pull up the report with that...
(1) A quick and dirty way to do it would be to edit the source query of the report and put in criteria for the Quarter & Year like [Enter Quarter] and [Enter...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the ms_access group. File : /Quarterly...
ms_access@yahoogroups...
Apr 17, 2009 3:26 pm
21631
Hello, I first want to say, "Thank you so much for replying." I'd like to use your first suggestion with the query. Are you suggesting that I first create a...
Quick & Dirty method: (1) Edit the source query of the report and put in criteria for the Quarter & Year like [Enter Quarter] and [Enter Year] Now, when you...
With the QBE interface, with two tables Table_A and Table_B, how can I produce that code ? (it's easier directly in SQL :-) UPDATE Table_A INNER JOIN Table_B ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
