Search results

Thanks Minty... that is great advice. The steps I took were to split the database, Import the 5 tables from the BE file into SQL then in the FE file, deleted the 5 tables and created/added links to the SQL table. I then renamed each to the original name and everything works. So I think I, by...

Thanks for the pro-tip Isaac. What about queries? I noted when I tried to use the SSMA tool that it listed queries as an import item. Should I be trying to import queries into SQL?

OK... I think I am finally getting it. I have 5 tables. I imported them into SQL. In the FE (Front-End... spent a few min's looking for an actual file with and FE ext.) DB, I delete one of the tables, then add a new link to the table in SQL. Totally makes sense. I created the link to Drivers...

Is that done in the be.accdb file or from my original? And I can't find where the links are to delete or relink. I see the Linked Table Manager but only offers options to export to Excel.

Hey all, Again, thanks to all who reply. This forum is great for nubies like me. I only have a tacit understanding of SQL server operations and I do have a working knowledge of SQL commands. I most likely didn't do this correctly but I do have a backup. I have a fairly simply Access DB I...

Well, originally, it was the only way I could figure out how to compress the data initially. When this thing is running, we will have between 50 and 100 trips a day being added into the DB. Each trip is listed under type TF, A, F and M with the super majority being To/From. For reporting to the...

Thanks Isladogs. I figured out what I was doing wrong and my poor logic lead me WAY down a bad path. I actually just needed to add a DLookup() to the query for pulling the dates from the SchoolYrDates table. Once I pulled my head out and pointed it in the right direction, I was able to use the...

Well, not quite there. TOP is an awesome function and I didn't know about it. However, I still can't seem to find the core solution. Top gives me the top 3 but the query does not total by day... it finds the top 3 days, two of those days should be added together. Still on the hunt for how to...

Select TOP 3... awesome answer. Gave me exactly what I needed with a supper short edit to the SQL. Seriously great answer. :-)

Hey all, I have to report the top 3 headcount days to the state for 3 count-periods during the year... FirstCount (Sept 1 to Oct 31), SecondCount (Nov 1 to Jan 31st) and LastCount (Feb 1 to Apr 30th). I have a query that lists all the bus trips between date X to end date Y. All trips have a...

Looking at this... it is very cool in deed. Quite a clean approach.

Thanks Arnelgp

OK... that is cool. I tried importing something like this before and missed a critical step that made the thing work kind of wonky. What are the steps to properly import this?

Thanks CJ... good advise. I actually set all format checking in the table but your suggestion makes perfect sense so I will modify and move it to the form.

Thanks CJ... I do have check to ensure the return time is after the depart time. The input mask is a great suggestion. That I will add. Where is the format property set? In the table or the form?

Interesting Arnelgp... so the overlay unbound text box provides the default template? in this case, 8:00 am? For T1, I don't see in the property sheet how that is accomplished.

OK... I see what you did there. I guess I could train them to enter only numbers, then assume the last 2 were min's and the remainder hours and work from there. Still, a lot of assumptions. There are so many ways users can screw up entering time. But you're giving me some good ideas. Thanks...

Not sure what you mean Arnelgp. What would the dummy text boxes do for correcting the time entry?

Wise words doc. :cool: I do have a check for a 5 min increments but that is one crazy line of code. I am using validation rules in the table... but this sucks. Not elegant AT ALL. Second([DepartTime])=0 And (Minute([DepartTime])=0 Or Minute([DepartTime])=5 Or Minute([DepartTime])=10 Or...

Hey all, Still working on a Ridership database. On my trip entry form, drivers are to put in the start and end times. I have the fields set to 24hr clock which is helpful but I am wondering if there is a way to capture (to help speed up entry) forms of entry and convert them into proper form...