Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DrDan1
  • Content: Threads
  • Order by date
  1. DrDan1

    Updating records via VBA in bound continuous form

    Hi. I'm using Access 2010 and I'm stuck! I'm essentially putting together a system for booking jobs. I have a form for booking them (done and dusted) and a form for confirming a job as complete. when updating the job as completed, it needs to update TWO tables, including the jobs table. Each...
  2. DrDan1

    Keeping files seperate to virtual domain path

    Maybe I'm over complicating things here, but here goes. I'd like to have a system where a user can have theri own website by selecting a website template. Lets say a user select template1 stored at: \htdocs\templates\template1\ He will also need to be able to store his own files, such as...
  3. DrDan1

    2 Col layout, But SEO friendly

    Hi. I am attempting to create a page with a header and footer and 2 columns. The navigation column on the left should be static, while the right one will be fluid, accoring to the size of the screen or window. Simple enough to do, but for SEO reasons, I need the right column source code to...
  4. DrDan1

    Show unique primary key from record just submitted

    Hi. The answer to this is probably so simple I'll end up cracking my head on the keyboard later. Using a very simple example, I have a table with just 2 fields. A primary key consisting of a unique auto-number and a name field. A user would submit their name in a form and the ctahing page...
  5. DrDan1

    email from exchange server into MySQL database

    I need to have any emails sent to a particular email address to get placed into a table in a MySQL database. I know it's a simple matter to have this done using a web form, but this case requires email. I've noticed something about this in the threads using the impa function but the emails are...
  6. DrDan1

    Displaying x out of y random images from database

    Hi. PHP newbie getting to grips with things. I'v got a simple test page to display the fist 4 images from a database... but what I'd really like it to do is display 4 RANDOM images from the database without repeating any. i.e. each one should be unique. I realise I could do this by having 4...
  7. DrDan1

    Pupulating form text box with defined value

    Hi I'm trying to find a way to populate a text box in a form from a value in a link. For example, I click on 'http://www.website.com/form.htm?text=123' This will take me to my form called form.htm. If I have a form text box, am I able to put that 123 into it as a default value? I'm...
  8. DrDan1

    table - populating cells in 3 cols, then again on a new row

    I've been racking my brain as to how to do this. And I'm sure it's a simple thing but I'm not so clued up on CFM. I want a table with 12 cells. 3 cols and 4 rows. I'm wanting items put next to each other till the 3rd column, and then starting a new row for the next three. e.g. product 1 in...
  9. DrDan1

    Pulling data from a record number from a recordcout

    Lets say I do a recordcout and it comes up with 50 records. It it possible to say in coldfusion that I want to see record 25 from that 50? ---------------------------------------- Knowing is not enough, we must apply. Willing is not enough, we must do. --So said the ever wise Bruce Lee...
  10. DrDan1

    Routers and gaming!?!?

    Hi. I know nothing about routers really. I got age of empires 2 here and 2 PC's in the house... and so does a friend of mine inscotland. I would like these 3 PCs to connect and play agame. In the house here the 2 pc's have the connection shared by means of an Origo Router which assigns both...
  11. DrDan1

    Is this possible? Excel 2000

    Is it possible to do the following: I have a workbook with several sheets, one for each month of the year. I would like an additional sheet that has all the information that's on the monthly sheets. When I add a line to, say October, I would like the same line to automatically copied or...
  12. DrDan1

    Expirey Date and CFMAIL

    Hey. I'm trying to sort something out here but getting nowhere slowly. I have a form where someone can upload details to the db, but it has to expire in month and get deleted... say 28 days. The access db will have a record of the expirey date of 28 days after the date the record was...
  13. DrDan1

    Select File name, but not the file

    Hi. I was hoping that there is a way of selecting a nuber of files and having the file names added to a field in a table. e.g. selecting a folder of 30 video files and they're updated to the access table as 30 new records, without having to type out out the filename of each file. I've played...
  14. DrDan1

    Selecting a country from an Access database

    Hi there. A Coldfusion Question. I want to offer a user visiting my page to a choice of a country from a complete lis of countries in the form of a drop down box. I was wondering if I could keep a list of all the countries in an Access table. The drop down box would then get it's data from...
  15. DrDan1

    A tough cross reference

    Hey. Got a problem. I'm trying to write a form that will cross reference data and return an end result. I have a table with Railtrack Line numbers and junctions. I want to be able to provide the form with, for example... Line1 and Line26. I would then like it to tell me where those two...
  16. DrDan1

    Too many records, not enough mem.

    It's got to the point in my Access 2000 database where I have over 430,000 records now in one table. I really want to change one of the fields from text to number but after a while it says that it doesn't have enough disk space or memory. I was wondering if there is a way around this. e.g...
  17. DrDan1

    Populating more than one cell in Access 2000 at once.

    Hi. If I had a column in Excel where each cell I can simply select the column or the cells I want populated and paste them. How can I do that in Access. I have an excess of 400,000 records. I ran a query and out of those I have about 2000 records which need populating in a single column. Just...
  18. DrDan1

    RecordCount & Current record

    Can anyone tell me how I would return values for CurrentRecord and Total Records. i.e. If CurrentRecord = TotalRecords Do something I'd apreciate any help. Thanks. ---------------------------------------- Knowing is not enough, we must apply. Willing is not enough, we must do. --So said...
  19. DrDan1

    Lock Each Control In form IF.....

    Hey there. I have the following code: If [Accession Number] = 0 Then Me!Comments.Locked = True Me!Description.Locked = True End If This works fine. It locks the chosen controls if the value of Accession Number is 0. But there must be way of writing code that'll do the same for every...
  20. DrDan1

    The Space Button Blues

    Probably something really simple but I can#'t find anything in the help files on it, and I'm relatively new to this. I'm using The Visual BAsic Editor for Access 2000. Whenever I push the space button to start the next word... it won't work. I try and type in Private Sub but it comes out in...

Part and Inventory Search

Back
Top