Recent content by jostrep

I need some help here please. I need to loop from a table (Markers), each record consist of the record number for the begining ,end and time value for some of the records. Ex: table Markers record 1 correspond to record 4 to 200 on the table FormatedData. What it must do is loop through...

I don't know if it's possible... I got a table containing data from a huge unformated txt file (JunkData.txt.). After transfertext and some queries I have eliminated all the text and irrelevant data (tblFormattedData). I got my primary key field (Num AutoNumber). I have deleted a lot of...

I need some code or ideas for reshuffling the order of visit in a itinary. Currently i export to excell drag n drop then import in access. I would prefer to stay in access. Any ideas? Thanks JT :cool:

Does any one here know the code for hidding some collums in a subform in datasheetview with a command button from the main form. Thank in advance JT :cool:

I wanna know if it's possible to use an access 2002 form to create some controls(icons) on top of a picture (a map) so that i can click those icons to display some info. The trick part is that those icons positions are generated by x,y coordinates from the db itself. Plus a zooming control...

Is there is new ranking functions in access 2000 that i can use to calculate some bonus point in a bowling db, any help specially links would be appreciated. Thanx JT

Tip I'm building a bowling db too. Try sorting -descending and in the number of values type 3 that should do it it . You can include these results as a sub-report. If you know a way to calculate the peterson points feel free to let me know Hpo this help you

Try this For your delete query, you probably need to isolate the field which contains the NULL values , then have the criteria "is null" You only need one field for the whole query or if you need more fields with their criteria (All Nulls?) to isolate those records you wanna delete. Hope this...

I did it I did it within the QBE woks great , i'll be glad to share if if needed.

I'd like to know if there is a function in access 97 that calculate a correlation coefficient or do i have to program it Thx in advance Jos

This is sort of wierd but her it goes: I must generate a report via a query in this format [Rank] [Element] [Status] [Week 1(From (a) to (b)] [Week 2(From (c) to (d)]...[Week 5(From (x) to (y)] and under the weeks are grouped each day like this EX:[Week 1(From (a) to (b)] S M T W T F S...

More details One more thing that data base is always open so the pop up reminder must appears automaticaly when they are scheduled.

Is it possible in acces to program pop up event reminder? How?

I ve got a list of items that have a certain rank, each month ive got to make some change in that rank how can i do it whithin access (sorting list?)

I got a chart that has years as fields. The problems i got is when i change the years range the report does not update its fields and bugs. Any sugestions Thanx:confused: