472,793 Members | 2,154 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,793 software developers and data experts.

Code Just Stops

I have a summary form that has two columns of unbound textboxes for actual cost
and marked up price. There are eight textboxes in each column. There are also
two unbound subforms. Each set of textboxes and each subform are for something
different. I have a Calculate button that programattically fills in the
textboxes and subforms. For each set of textboxes and for each ubform there is a
query that calculates the values I need. For each I create a recordset, get the
values from the recordset and assign the values to the textboxes or subforms.
The code sequentially fills the form from top to bottom so I only need one
variable (Rst) for DAO.Recordset and one variable (QDF) for querydef. After each
pair of textboxes or after each subform, I close Rst before going to the next
calculation.

The problem is that the code just stops about midway. There is no error message
or indictaion why it stops. It just fills about half to textboxes and subforms
and stops. Would this have something to do with creating so many recordsets
although I close the recordset after each calculation?

Thanks!

Traci
Nov 13 '05 #1
0 1204

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

53
by: Cardman | last post by:
Greetings, I am trying to solve a problem that has been inflicting my self created Order Forms for a long time, where the problem is that as I cannot reproduce this error myself, then it is...
109
by: Andrew Thompson | last post by:
It seems most people get there JS off web sites, which is entirely logical. But it is also a great pity since most of that code is of such poor quality. I was looking through the JS FAQ for any...
4
by: D Witherspoon | last post by:
Sometimes if I build the app I will get intellisense, undo, and code completion (automatic completion of if stataments etc), but after a few lines of code this stops. I lose any code completion...
16
by: graham.reeds | last post by:
I am updating a website that uses a countdown script embedded on the page. When the page is served the var's are set to how long the countdown has left in minutes and seconds, but the rest of the...
9
by: BoloBaby | last post by:
I have an extremely vexing problem occurring in a program that I am writing. Consider the following block of code: Dim pDancer As New BEDancer mintIndex = mintIndex + 1 pDancer.DancerName =...
5
by: Adrian Enders | last post by:
I have something that I have never seen before in a MS development product. I have a pretty simple call to a network directory that looks something like this ... Dim dirFolder As...
2
by: iwdu15 | last post by:
hi, i have the following line of code Dim fsUser As New IO.FileStream(SnPath & s.Identity & "\UserData\info.ppf", IO.FileMode.Create, IO.FileAccess.Write) in a sub, SnPath is not null,...
5
by: Raj | last post by:
Following is a code to replace blanks in entered string with adequate number of tabs & spacings as required. I've taken the width of tab as 5 characters here. The problem that occurs here is for...
11
by: raamay | last post by:
when i download movies my download stops in the middle. I use Free Download Manager and i get the message "File not found in the server" error. The download manger tries to reconnect to server...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.