I have a ACCESS application that I wrote several years ago and use quite a bit. Sometimes, I will open it up and it does not work properly. I have a form that contains several subforms and one of the subforms has cells that contain formulas like this one
=[fExpense_entries].[Form]![total_form_expenses]
Normally, I see numbers in these cells. But sometimes, these cells are just blank. Sometimes, I can get the db to work again if I open and close it a few times. Other times, that doesn't work and I have to "save as" a new file name. Today even that didn't get normal operation back but I did a full system reboot and then it worked again.
I also sometimes get a message that my file has been opened as read only, and sometimes I get a message that macros are not enabled.
There does not seem to be any pattern to when it stops working or what it takes to fix it.
I have combo boxes populated with all values in a particular field, then shunt the form onto that record (standard combo box for selecting records from a list in other words).
Problem is, these boxes seem to stop working if I leave the form for another and then return to it.
Here's the code Access puts behind:
----------- Set SerialRS = Me.Recordset.Clone SerialRS.FindFirst "[Serial Number] = '" & Me![Combo60] & "'" If Not SerialRS.EOF Then Me.Bookmark = SerialRS.Bookmark -----------
The form may be opened and closed via other processes (although never unloaded), but when I come back to it these combo boxes always stop working! Why?
I have a form with sub-forms. All the subforms work smoothly, I am able to assign students to classes, enter their late/absence data etc... But there's 1 subform that I want to include the Gender (male,female) so I have to go back to the query (see attached picture) to include the table with gender data and map it with other tables, then insert a combo box in that subform, which display the gender of the student along side with other data.
But the problem is as soon as I modify the query for that subform, all the subforms (including that one) stop working, I'm not able to enter and change anything with error like Recordset is Noteditable ( see attached screenshot).
And after I remove that table from the query and the combo box from the subform every works just fine again.
I have solved the problems getting values on the subform. I have not in getting values on the subform.For instance, on the one titled phone use the formula in the tutorial is:
=[sbfCustomerRoomUse].[Form]![txtTotalPhoneUse]
#Error results when the doc is put into a form mode.
Now when I input each value in the equation above separately.I still get no entry.
For " = sbfCustomerRoomUse" , I get #Error; and for "= txtTotalPhoneUse", I get #Name.
CustomerRoomUse and txtTotalPhoneuse are from the subform that was dropped into the customer form in a previous step. It shows that explicitly when designed sbfCustomerRoomUse on the main that CustomerRoomUse come from a subform. This does not seem to need to be done with txtTotalPhoneuse, and I am not sure why. Neither one gives me a desired calculation result.
I have an odd problem that has stumped me for several days. I'm working on a form that contains a chart. The chart is based on a query, which is based on another query, which is based on a table. In the top query, I need to put some calculated fields that operate on other fields. But when I try to multiply two fields together, I get Null. I'm pretty confident that the fields I'm operating on are numerical.
I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.
The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?
I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.
I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?
I'm hoping this is a no brainer...I am a complete newbie and self taught so apologies for not knowing the correct techie terms!!
I have a db with products...
Each product has a price (to customer) and cost (to me the seller)
What I want to work out is the margin i.e. price minus cost divided by proce multiplied by 100 to give a margin in percentage terms.
The data is held in a table with a record per product with the price and cost..
I want to build in another fieled per record that calculates the margin...
Thanks very much
Jessica
(I would also like to be able to work out decreasing margins if I was to extend say a 10% or 20% discount to the customer but I guess I shoudl walk before I run!!)
Hi, I have a database and on one table I have dates stored for certain jobs. I was wondering if anyone knew how to automatically calculate an end date if the start date and duration is entered!
Ok I'm really new at using access so go easy on me. I am trying to write a database to keep 30 measurements of a part grouped by lot number and then calculate the standard deviation, mean and a few other calculations, however I am unsure about how to do the calculations in access.
I would like the database operator to be able to enter the data then print out a report per lot, with the entries and the calculated answers.
I'm just unsure where and how to do the calculations... any help or suggestions?
I'm trying to a create a report to list results for a running club based on series-to-date. To do this, I allocate points to the first 100 runners to cross the line in each race. The winner gets 100, second place 99, and so on with the 100th person getting 1.
In the database i have 1 table holding member details, then one table holding races. I also have a table linking the 2 called race_entry so i know what members have entered for which races. I have one other table called race_result that links the runner to a race and holds the position they finished in the race.
How could i use the data in the race results table to add up all the points they earned by looking at their finishing position in the races they run and then listing the points in order in a report.
I assumed it wouldnt be necessary to have a point field in the table as its deriveable.
This is more than likely simple for a lot of people out there but it has me stumped. I have a form that has a two combo boxes with dates in both ( so the user to pick from and to dates) now I am always going to be adding more dates as time progresses. I need the next form to add the info with the dates no mater what the user picks. For example I am going to (once a week) be adding new info to the table.The end user is going to pick 06/24 (to indicate the end of the week) in both forms or 06/24 in the from box and 07/01 in the to box. In all situations I need the next form to add the data together. Sorry for the long post but didn't know how to state it any simpler.
I am a beginner with Access and was wondering if someone would be so kind to give me some pointers
I have created a form where the user can select which dates they require a hotel for the evening. I was looking for some advice on how I can go about putting an area on the same form which calculates a sub price for the days they have selected. If I am not being clear then ask for more details.
i have created a new utility DB that has only one form..when it opens I set the startup form "Main" and on the OnOpen event of this form I have some code to open another database and close this one...
this means that whenever i open this database, it opens, opens up the other one and this utility DB closes...and i cannot access it coz it always opens and closes automatically...how can I stop it from executing to be able to edit its VB code?!
Not too long ago, I wrote a top ten ways to make sure your question was never answered. I'm going to append it.1) "Help Plz!!!!!!!!!!!!!!!" does not an answer give.2) http://www.access-programmers.co.uk/forums/showthread.php?t=850423) "I'm totally new to VBA" is not an excuse when you're asking for VBA. Someone providing you with the code teaches you nothing. Show code, show where you're stuck, show something. 4) Stop telling us how new you are and do not do suck up ("You guys are so great, and I've learned so much blah blah blah"). We know why we answer. If someone helped you before, reference that, and that's it. 5) The subject is just that. The freakin' subject. Remember that. "I'm stuck" is a bad subject. "Help with error resolution" is better.6) We do this for free. Remember that.7) Cross-posting -- not such a good idea.8) Never, ever ask that posts are sent to email addresses. Are you that lazy?9) Explain, in detail, what the issue is. The posts that are like, "I have this table where I query it, and it doesn't work!" followed by the query have no clear purpose. Make sure you know what you are asking for.10) For god's sake, try to figure it out on your own. None of the stellar answer people (myself, boblarson, docman, rural guy, and the others I'm forgetting) got this way off of message boards alone. Yes, questions were asked (most likely before this place existed), but for the most part, programming is a self-tutorial through trial and error.
This should be a simple one.... But can't seem to find the answer.... I have put a line of code on the open event of a seconadry form.... First form is "Clients" second form is "Contracts" If no the client has no contracts the code goes.....
Private Sub Form_Open(Cancel As Integer) If IsNull(DateOfSale) Or DateOfSale = " " Then MsgBox "No Contract Exist" Cancel = True End If End Sub
After the first message box I get a "Access" message box... "The OpenForm action was canceled" ....... Thats fine.... we know that... But we don't need to know that. How can I stop the second message box from opening? Or can I ?
I need to be able to use some functions available in excel in an access 2000 database. These include SUM and IF functions. If any one can help me figure out how to do this any help help wouold be greatly appreciated
Hi I would like to manipulate some date information. I have a start date field and an end date field and I would like to draw up a schedule for payment where the Acess takes the finished date and the start date to get total days appart then devides this by a value set by the operator. say If the operator wanted 6 paymes then my total days would be devided by 6 giving me the number of days to add on to the start date. Then with these dates a schedule is made up and the code I have tried looks something like this.
Dim valuation1 As Date Dim valuation2 As Date Dim valuation3 As Date Dim valuation4 As Date Dim valuation5 As Date Dim valuation6 As Date Dim valuation7 As Date Dim valuation8 As Date Dim valuation9 As Date Dim valuation10 As Date Dim valuation11 As Date Dim valuation12 As Date Dim startdate As Double Dim findate As Double
Dim valcounter As Double
'retrieve start date and end date startdate = CDbl(Me.Start_Date) findate = CDbl(Me.Completion_Date)
'calculate evaluation periods Dim valCount As Double Dim valDays As Double
Select Case valcounter Case "1" Me.valuation1 = startdate Case "2" Me.valuation2 = startdate Case "3" Me.valuation3 = startdate Case "4" Me.valuation4 = startdate Case "5" Me.valuation5 = startdate Case "6" Me.valuation6 = startdate Case "7" Me.valuation7 = startdate Case "8" Me.valuation8 = startdate Case "9" Me.valuation9 = startdate Case "10" Me.valuation10 = startdate Case "11" Me.valuation11 = startdate Case "12" Me.valuation12 = startdate
I have a question that I can't seem to figure out. I am trying to create a form in which there are three major fields. 1) Value 1 2) Value 3) Sum of Value 1 & 2. I want it so that two fields are added up and then the sum, which will populate in the third field, will be stored in a table.
Does anyone have any suggestions on what I can do? I am fairly new to access and haven't had much luck finding anything on the net.
The fields include both date and time (date and time are in the same field) i.e. “6/26/2006 4:23pm”. The next field I need to calculate the duration, basically one field minus another…anything I’ve tried will only calculate the time difference will not factor in the days. For example, if it has been 52 hours (2 days, 4 hours) it will only say 4 hours. A few of what I’ve already tried are below. And I’ve also tried an elapsed time expression.
