Search results

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:

Thanks Sorry for the delay everything seems to work great, Thanks again

When i click on a button i wanna do the following actions: 1-A transfer spreadsheet to exprt data to an .xls file. 2-Open that file (Via an hyperlink?) so i can edit that file. Any tips please Jos

Reply No i've got both portrait and landscape in the same report

I got this report wich include two chart in subreports that must be printed in landscape, the rest is not. How can i instruct aacess 97 to display in the print preview and when printing in the proper orientation (both landscape and landscape) Thanx in advance Jos

Ok, ont hte report, the comments and the charts are from separates queries. The comments are entered via a form and are selected via a query for the month they're attached. Those comments appears on the report from a sub report. What i need to know is how to specify the format of that text box...