Search results

Keith, I don't want to sound like and idiot, but where do these strings go? ...I'm used to using mySQL and PHP. I'm planning on using MSSQL and PHP now. I've researched and found that they aren't very different, but it would appear that I need to call an ODBC connection in my connection string...

Hey all! Nice to be back in the database world, for now. I have a user with a problem. I helped to designed a database a long time ago. One of its functions allows the user to click a button, which runs the "sendreport" VBA function. Basically. it opens the "Compose" dialog box of Outlook...

Never mind... I think. Well, in any case, it's been corrected. I changed the value from "char" to "varchar" .... Thanks, Andrew

Thanks! ....I'll risk another potentially ignorant question... Why can I set the length of a column in SQL Server Enterprise Manager to, say "10" but be able to type many more characters than 10? Or, I recently set the length of a column, whose data type was "char", to "20" but was only...

Hey all, I'm moving from the World of Access to SQL. It's terrifying. I don't suppose you all could provide some hints... I'm designing a system with a SQL back-end, and an HTML front end. I'm putting the SQL tables together right now... <dumb question>What data type would a checkbox...

I know that I can use SQL Server as a backend in Front Page... Can anyone point me in the right direction (A link or something?) as to how I would go about doing that? I need to create a database connection, and I have no clue. I've done it with Access before (I think) but I know that it's...

Good Article I'm not sure it addresses my problem - This is event more basic than some of the issues Luke Chung has brought up. Rounding down at five (From 1-5) and up from 6-9? Is there a profession on earth that does this? At any rate, I think I've found a solution based on this thread. My...

No such luck... Thanks, though. Has anyone had this issue? It just doesn't make sense (or cents). Andrew

I have a query that uses the round function as follows: Round([LoanAmt]*0.0125,2) This should multiply that LOANAMT field by 1.25%, and round that answer to two decimal places. 1.776 rounds to 1.78 - That's good 1.774 rounds to 1.77 - That's good BUT 1.775 rounds to 1.77 - Why? Didn't we...

erp - never mind. Figured it out! Thanks! Andrew

You likely aren't far off - I just have never done it. You're saything that I add a grouping clause in my query? There is a query behind the report....I just haven't ever grouped via query before. Is this something that I must do via SQL, or can I use the regular query design view? ...Help's...

I'm not sure where to begin, and I have no idea what sort of search terms I would use for this: If I have a report grouped by a text field, and the group footer counts the number of records in that group, is there any way to sort the records within that group by number of occurances? Basically...

I am attempting to use a filter when I open a form. Would anyone be able to tell me the correct syntax? DoCmd.OpenForm "FRMNewLoan", acNormal, , "Date is between 8/4/2005 and 11/15/2005" "Date is between...." is what I'm using.... I want to pull all records between those two dates. Thanks...

hmm... How? I haven't found a "save password" feature. The only checkbox on the login screen is "Use Trusted Connection" Andrew

Does anyone have a solution to this? We have the same problem.

No.. On the DoubleClick event of the list box.... DoCmd.openform "yourotherformname",acnormal On the on-open event for "yourotherformname", put in the code... Me.RecordSource = "your list box string here" As long as the options in the listbox are the names of tables in your database, I don't...

http://www.access-programmers.co.uk/forums/showthread.php?t=63820&highlight=change+form+source Use the code provided in that thread, in the OnOpen event, to change the record source of a form. Andrew

The user should not have to input the autonumber. The query will look at the form, see the autonumber, and return only that record. Andrew

I figured you did as much. Yea, there are probably better ways to organize that database, but if you've already put information in, there's no point in going back now. A Union query would solve your current problem, Without doubt. Andrew

So, for every record, you have an "album name" and then 21 columns for songs? (Along with some other stuff, I assume.) You need to find if a title exists in any of the 21 columns of any of your countless records? If that's correct, then I would go for a union query. These are actually supposed...