Search results

Well are you building this for experience or for a project? There are many free ones out there already...no need to reinvent the wheel if dont have too. Just google CMS or ASP CMS you will find some. The best out there is Wordpress, just google it. Many of these are alreay SE friendly and...

Well are you going to host it or get hosting? Honesty most if not all, will have MySQL which is easy to use or much better than Access. There are many many many scripts out there that would work with MySQL. If you want a game site with users the easiet way would be google PHP acade script...

Hello, Found this here and was trying to do the following. Delete rows in my table that are dupicates and put them into a new table. Keep getting a syntax error. SELECT DISTINCT * FROM tblRaw INTO tblClientcontacts Anyone know why? I have a table that has 12,000 rows. Out of those rows...

Ok so if I have this right. I can import the spreadsheet say into table A. Then using an append query add the data I need to table B. Which would be everything but CONTACT_COMMENTS column. Now where should I delete the duplicate rows? After or before the Append or does it not matter? So...

Hello, I have a database which every week I have to import an excel spreadsheet. Now this spread sheet will always have rows that repeat and will have somewhere between 700-1500 rows. What is my best option to delete the rows that repeat? Meaning if a rows 1-10 have the same data then delete...

That worked, amazing. Thank you for your assitance. Rep+ (It wont let me just yet, but I will, thanks.)

That LAST UPDATE format is "SHORT DATE" in that fields format. There is like 12 entries for June. I tried this: Month(Me![LAST UPDATE]) = month(Date) But gave me null error.

Thank you for the help. I have this: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me![LAST UPDATE] = month(Date) Then Me.Section(acDetail).BackColor = vbYellow Else Me.Section(acDetail).BackColor = vbWhite End If End Sub I tried using [text 35] but it cannot find...

Sorry havent messed with my database lately and everything seems foreign.;) Ok. This is what I have in my Event Procedure in my details format section on my report: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me!txtMyControl = "somevalue" Then...

Hello, I need this to highlight a row in a report or a field in a report if a condition is met, is this the same thing. For example if a field equals the current month then highlight yellow, if not then do nothing. Does the code above do that or work for what I am trying to complete... Thanks.

Why would you want to build one just to do it? There are many out there now for free to use. If you look there should A LOT...google; cms, forums, php forums, or whatever. Free ones I know of off the top of my head are Nuke and Mambo, but there are at least 20+ types that are free. Now if...

I take it this must be your own server. If so I would just install PHP on it and or get some help, since a programming language is going to be essential at some point. When I had my server running I had: Apache PHP phpmyadmin MySql Think was about it, but yea your not going to be able to do...

Hello, I have been working with PHP over the years and have become quite familiar in how it works, however I want to learn more about ASP. Anyone know of some good websites to learn some information...tutorials and such. Thanks.

Why for course work would you professor tell you to create a database for a made up company in which nobody knows how to use Access...were you cutting class lol. :rolleyes:

Thanks for the reply. Sorry I did post in the wrong forum by accident. This is for a Excel macro. Here is the whole thing...so what should I do to fix this or what is causing this? Sub AddVantage_SQL() ' ' AddVantage_SQL Macro ' Macro recorded 4/5/2007 by user ' ' With...

Hello, I recorded this macro via Excel and it has a compile error anyone know why? It runs a SQL for me, here is the section that highlights as compile error- syntax: .CommandText = Array( _ "SELECT AC_BI.ACCOUNTANT, AC_BI.ACCOUNT_NAME_FIRST, AC_BI.ACCOUNT_NAME_LAST...

Well this is my issue. See we have a database and I may "over estimated" the number...I just called operations and they said 718 tables with 200 blank tables left. I am trying to create a form with infopath that receives data from this database. However infopath cannot connect to the database...

Hello, I am working on something and have to link I think a few thousand tables from a "store bought" database here at work. Is there a limit in regards to access? I know they are just linking but I didnt know if Access gets nutty after a while... Anyone encounter functionality breakdown due...

Yea this one works good, used it for my database "bells and whistles"... http://tools.dynamicdrive.com/favicon/ Supposed to be for URL favicons...but I use it for other things as well.

Ahh so Spencerport maybe...