Search results for query: *

Thanks you guys. I was given a resolution, but, was happening was, I wasn't understanding it. I have been heavily using CR 8.5/10 and only have been heavily using CR XI for 6-8 months now. This was the solution: SQL expression named Timezone: Hour(current timezone) Formula: DateAdd("h"...

I am building in CR XI, a report that lists complaints that our call center receives on a daily basis. The only problem is that the Start_Date_Time for the comments is in GMT, so some of the comments look like they were entered late at night after we've closed or at 3:00am. I wanted to use the...

Before I post my question, can you use the SQL CAST function in the SQL view of MS Access 2000 to link two tables by their primary keys that have two different data types? i.e. Table1 has member_nbr as numeric Table2 has member_nbr as text.

No, that doesn't seem to work, but, I will still keep trying. Thank you.

I'll try that, however, the second combo box works. This will help the combo box show the BOName and not the BOID? Thanks

Access 2000 I have created a combo box that limits its list based on the selection made in a previous combo box. First Combo Box Table Name: BackOffice BOID BOCode BOName 1 ACCTG Accounting 2 CENLEND Central Lending 3 LNSERV Loan Services 4 REL Real Estate 5 SA Special Accounts Second Combo...

Thanks guys!!!!!!!!!!!!! I have to clock out now. But, I will try your suggestions tomorrow am. PST. Laura

Thank you. I will give this a try and repost. Laura

Apparentally, I am missing a close ")" in my code because I am receiving this SQL message: Server: Msg 170, Level 15, State 1, Line 12 Line 12: Incorrect syntax near ')'. But, now I am wondering if it is possible for a query to contain a subquery both of which select from the same View? I have...

Thanks PHV!!! That is exactly what I will be doing. --lradon

Good point Remou. I'm making a database to track losses resulting from fraud and/or teller overages/underages that our financial institution takes periodically. And the users already have to perform corrective transactions in our core system and then will be expected to turn around and key in...

Thank you Remou. I read the article. Now to convince the committee. I know that the users are not going to want to use this database that I am making, because it will be double work. lradon

I noticed that when I upsized a table to SQL 7.0 and then linked it to an Access 2000 database via a SQL ODBC connection, I lost my drop-down boxes. Can anyone confirm that you definitely can use list boxes or combo boxes with sQL tables with Access as a front end? Is there a way to do this or...

Thank you, Mr. Denny. I added a primary key to my Access table before I upsized it to the SQL db and tested it and it worked!!! I could edit and add new records. So thank you. Laura

Thanks Mr. Denny. I will follow your suggestions. I have spent much time googling this and reading BOL and am getting frustrated because I haven't had to do this before and there are all sorts of options out there and I'm not sure I was finding any I could use, due to my knowledge, until you...

Thanks, zemp. I have looked in those forums, but, I will look again. lradon

Hi, I have a similar need as the previous post. We use SQL 7 and I need my ODBC connection to be Read/write, so that users can do data entry thru an Access 2000 form and be able to edit the records and delete them as necessary. I have a feeling that the problem lies in the SQL login and I am...

Hi, I have a similar need as the previous post. We use SQL 7 and I need my ODBC connection to be Read/write, so that users can do data entry thru an Access 2000 form and be able to edit the records and delete them as necessary. HELP!!! Thanks in advance.

Hi, It's interesting that you are looking for this, because I need the same thing, except I need the ODBC connection to be writeable/editable. I am using using SQL 7. Can anyone help us out? Thanks!!!

Hi Paul, I am trying to do what you are doing using Access as a front end and SQL tables as the backend. ******************************************************** "I have a problem with an Access 2000 front end which needs to take data from an Access 2000 Db and pass it to a remote SQL Db. I...