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

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...

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:

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

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

On the buttom of some chart i wanna include some comments about that chart. Those comments must come from a table via a query. The problem is how can you make the next comment skip to the next line automatically, the users don't know a thing about data bases, so skipping to the next line must be...

Can someone please help me with the following msg box. When i click on a button which run an "import form excell macro". I want a msgbox Vbyesno to appear before the macro is run. The Vbyes = run the macro The Vbno = exit the procedure (do not run the macro and close the msgbox). Can someone...

i have some problem exporting a table to a file in a format named '.IDM" can someone please help me; what kind of text file is that , plus some info on the procédure overall. Tnx

Can someone please help me i have the following problem. Each day we are entrering the value of a totaliser (for total flow).The old system use excell no problem here. But in access we are storing the values in a table but i cant find any information on how to calculate the difference today's...