Search results for query: *

Thanks so MUCH!!!!

Hi Everyone, I'm sorry. I didn't know which forum to best put this question in but basically I want to know how to get the ip address for a computer in the command prompt. I know there's some command line I can type in the Command Prompt to get this I but I can't remember. Can anyone help...

Hi, I want to create a calculated field as a sort expression on my report. I want this calculated field to sort by my LastName and FirstName fields. Can anyone help me with this? Do I need to create a calculated field first and then select this expression in the sorting and grouping window...

Hi Guys, Thanks for getting back to me on this. I just noticed after posting this that it pops up on the Timbokto Icon on the task bar on the bottom right of my screen. WM

Hi, I need to find out what the IP address is on my computer here. It's a networked, Windows 2000 pc. Can someone tell me how to do this? Thanks, WM

Hey Steve, That worked great. Thanks very much. WM

Hi, Thanks for the response. Do you mean divide by 100 again? I did try changing the format to standard and I'm getting some strange numbers. For example one student's GPA was 3.57% (this was correct). When I change to standard it comes out .04. I also tried changing standard and dividing...

Hi, Thanks for the response. The Grade Value field is defined as a number in the table. The format for the field on the report is a percent. I'm not that familiar with other formats but I tried standard and fixed and they didn't come out correctly Thanks, WM

Hi, I have a function that is calculating GPAs for students in our database. The problem is that it's leaving this percent symbol (%) on the end of the calculation. I tried to use the left function to remove this but I didn't have any luck. Does anyone have any ideas for how I can remove this...

Duane, That was great help. Worked like a charm. Thanks so much! And, Gary good tip as well. Thanks, WM

Thanks, guys. I like your suggestion Duane. I'll give this a try tomorrow and let you know. Thanks, WM

Hi, Can anyone help me? I'm trying to create an expression to sort my report on (under View/Sorting and Grouping). Basically, I want my report to sort by Last and First Name. These are separate fields in my table so I'm assuming the best way to use them as a sort on the report is by creating...

Hi, I'm trying to remove the read-only status of an Access database I'm supposed to be making changes on. I received this database from an end-user via email as a .zip file. When I extracted the file I was promted to enter a password which she provided me. I did this but then when I actually...

Hi, I'm trying to remove the read-only status of an Access database I'm supposed to be making changes on. I received this database from an end-user via email as a .zip file. When I extracted the file I was promted to enter a password which she provided me. I did this but then when I actually...

Hi cmmrfds, Thanks, bingo. That did it. Watermelon

Hi Dan, Thanks for the suggestion. I tried that out. Unfortunately, I'm still getting the same message. I'm pretty sure the problem is the Now() field because I don't get the error message when I comment out this field. But, I still don't know exactly what that problem is. Watermelon

Hi, I'm using the Now() function in an Access module to try to insert the current date and time into a date/time field in one of my tables. Everytime I try to run the code I get a "Syntax error in Insert statement." Here's my code: sql = "INSERT INTO IPOClientDetails(ClientID...

Hi guys, Thanks for the feedback. I'm doing this only in a temp table. It's kind of a long story but that's why I'm duplicating this data before moving it to a permanent table. Thanks to both of you. Both suggestions worked. Watermelon

Hi, Can anyone help me with this query? I'm trying to update a field in one table by setting it equal to a series of concatenated fields in the same table. I'd like to separarate each concatenated field with a comma only if the field is not empty and has some value in it. Here's the code I...

Hi, Thanks for the response. You're absolutely right, there was nothing wrong with the code itself per se. The problem was, embarressingly enough, that I was referring to the field as LastName instead of LName. I guess it was a case of the error message throwing me off the trail. It's strange...