CD Tom
Last Activity: Mar 19 '25, 10:06 PM
Joined: Feb 6 '09
Location: Portland, OR
-
Microsoft form question
I have a form with a drop down the list people's name on my computer when I start typing the name the drop down jumps to the start of that persons name on another computer is doesn't do that does any body have a answer, I'm using Office 365 the other computer is running Access runtime 2010... -
Ok thanks for answering. When the app it started everything is ok, when the user say goes into the edit members section of the app it works fine for the first couple of times, but after maybe three of four time they will then get the error message, when I look in the task manager I see that access is running multiple time in the background section. I kind of looks like the app opens up each time the user does anything three or four times. -
Getting error message Can't open any more databases
Just lately some users of my application have been getting the message (Can't open any more databases. When I look at their task manager, I see Access running in the Apps section and when I look in the background section I find that access is running 4 or 5 times. My users are running Access Runtime version 13 32bit. On my machine I don't get the message but if I look in my task manager, I see Access in the Apps section and I see it once in the... -
That's kind of what I did, Opened the .accdb that was working and just made the changes that I made to the one that wasn't working and created the .ACCDE and everything is back working again. Thanks for your help.Leave a comment:
-
Thanks for the quick response, I'm almost positive that there was no changes to that section of the program. But just to be sure I'm going to compare the previous .accdb and see it there is any difference, I'll let you know if I find anything.Leave a comment:
-
Problem Converting .ACCDB to .ACCDE using Access 2016
My program searches through all drives on the computer looking for the _be.accdb database, this allows the user to put the database on a network drive. The program when compiled was working fine, but the last time I compiled it and ran it using Access runtime it didn't find the database, however if I run the .accdb program it works fine. What could be the cause of it not finding the database when in a compiled mode.
Any help would be app... -
Adding up only highest 7 numbers in a table
I have a table that can contain up to 12 entries for an individual in the number field each number can be different number I want only to add up the top 7 numbers for each individual. What's the easiest way to do this.
Thanks -
how to collapse a custom toolbar in VBA
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins that the users have to right click on the Custom Toolbars and them select collapse the ribbon. is there any way to do this in vba so the user doesn't have to do the right click everytime then run a report. -
How to minimize a tool bar that shows up when in reports
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right click on it and select custom toolbars then collapse the ribbon. Is there a way to do this in vba so the user doesn't have to always right click and custom toolbars. -
Having a problem with the 0 not showing
Right now I have a field type short text. in that field I'm putting numbers .345 .432, etc. but when the number is .340 the zero doesn't show up. I've tried changing the field type to numeric but when I enter the number .665 or something it shows up as a 1 how do I fix either one of these problems. -
NeoPa
I'm still working on the problem with the runners and not matching them up with the same person. I thought if I could put the runners number in a file and put the runners number they are match with that way I will have a place to look to see if that runner has ever been matched with that runner and if so select a different runner.
Does that sound like it might work???Leave a comment:
-
What i'm trying to do is get the XFDAnumber from the 2nd record in the file, I will then update that number into another file in record 1 then get the 4th record and put that into record 3 of the other file and so on.
Don't know if that makes sense or not.Leave a comment:
-
I'll try and explain better. Here's the code I'm using.
...Code:j = 2 strsql = "select * from scores order by RandNumber "" Set rsscores = db.OpenRecordset(strsql) Do While Not rsscores.EOF DoCmd.GoToRecord acDataTable, "rsscores", acGoTo, j SXFDA = rsscores("XFDANumber") J = J + 2 rsscores.movenext loopLeave a comment:
-
using the docmd.gotorecord command
I've been working on a problem and want to try using the docmd.gotorecor d to get to a certain record in a table. I've got that figured out but I don't know what to do once i'm on the record. I want to select a usernumber from that record. It should be fairly easy to but I can't figure it out. Any help would be appreciated.
Thanks -
I see that my first thoughts are not going to work. in round 2 runners 3 and 4 and 5 and 6 and so forth.
So how about this.
Again, I'm starting with 40 registered runners. Round1 is pretty straight forward.
Not sure how many rounds there will be but no more than 12.
I know what round number I'll be in so I can use that to setup the table lookup. If I knew how to do that. Round 2 I can start with registered runner 1...Leave a comment:
-
I've come up with an idea but not sure how to implement it. Here's my thoughts.
I have 40 registered runners.
round 1: 1 round 2. 2 round 3. 3 round 4 4 round 5continue for as many rounds as selected.
1--------- 2 ---------- 3---------- 4 -----------5
2--------- 3 ---------- 4 ----------5 -----------6
3--------- 4 ---------- 5---------- 6 -----------7
4--------- 5 ---------- 6 ----------7 -----------8...Leave a comment:
-
i've been working many different ways to try and come up with a solution.
Runners register for the match. this number can be any number of runners. Each runner in the database has a unique identifier.
The number of rounds they can run can be as high as 12 time but usually no lower than 6, this depends on the match director and his decision may be decided by the number of runners that have signed up.
When registration is complete,...Leave a comment:
-
Sorry for the confusion so let me see if i can explain it better. I'll use a different example
I have 4 or 6 lanes. (The lane number can very between 4 or 6) each lane will have two people assigned to it. Lane 1 and Lane 2 will have two people assigned. 3 and 4 will have two people assigned these people race down the lanes you have a winner for Lane 1 and 2 and a winner for lanes 3 and 4.
The people can run this race up to twelve...Leave a comment:
-
Need to divide a group
this is a general example of what I am trying to do.
I have a group of 50 people and have 12 tables, I need to put two people at each table but can't have the same two people together. I've tried doing a random numbering, but I still end up with the same two people at the same table. Does anyone have any idea how I can do this. Any help would be appreciated.
Thanks. -
Export data from a table to a .txt file
I'm having a problem exporting a table that has a field formatted as Field size (Double), Format (standard) and Decimal Places 3. looking at the table everything is fine fields shows 0.624 but when I try to export it to a .txt file if field shows up as 0.62 I've used the External Data and export to Txt file. I've set up a specification with the field type as double but when I export it I don't get the 3 positions. My export code is as follows ...
No activity results to display
Leave a comment: