Search results

I have one table RecID Transit USRoaming 1 1 yes 2 1 no 3 4 no Another table Regular Charges USRoaming Charges 100 120 I need to rollup all the transits so I would get Transit Charges 1 220 4...

it is defined as date/time in the spreadsheet, but when I import data it all comes in as the text.

Hi When I import spreadsheet into the Access 97 table, I get all my dates in the text format (for example 9/12/2002 would look like 37511) And Access wouldn't allow me to change the format from text to date/time What should I do? Thanks

Hi I just imported a data from another table. What bothers me is that for instance, a record has field LastName filled in in the table, but when I look at that record on the form, LastName does not show up. That only happens to a few records, where as the rest of the records do show up on the...

Hi, I need to loop through all records in the table in order to assign the value to the field Please suggest the code Thanks

I have a spreadsheet that I have to import. It only includes last names. I have a table that includes last names and employee ids. So what I have to do after I import the data, I need to run a query to find and assign all matching Employee IDs to the last names from the spreadsheet. Please...

Hi i have a simple question i need a sql statement that will replace all '950' to '1' and all '957' to 2 in my Model column of the BlackBerry table. Please advise the code Thanks

Hi I am trying to go around the locking problem in Access So what I want to do is to make my record be exactly 2048 bytes? How would I check the size of the record? Thanks

I want to be able to send the report to the text file. But I also want to be able to pass the parameter for that report. So now I just have this line of code, DoCmd.OutputTo acOutputReport, "rptSomeReport", acFormatTXT, "c:\Files\SomeReport.txt" How would I control the criteria for that...

Hi I was wondering if anyone knows how implement the following: I send the table to the excel spreadsheet file. The location of the excel file is hardcoded. However it is sort of limiting for the user in case she/he wants to save the file in their own directory. So I want to give that option...

In what area of the report should I place my command buttons? And please give me any examples that may help to quickly resolve my issues. I'll appreacite your help greatly Thanks

Hi I want to produce a very basic report. What I also want is the command buttons "PRINT", "E-MAIL", "SAVE AS EXCEL FILE", "CLOSE" Is anyting of the above achiveble? Please advise on the best approaches? Thanks

Hi I use edited record locking in my Access 97 application. But the way this lock works is not only the particular record gets locked but the whole bunch of nearby records as well. Can anybode tell me, how many exactly records would get lock? Does it depend of the number of the records in the...

All I need is to send an e-mail and attach the excel spreadsheet I believe it's dueble, just don't know the code Please assist Thanks

hi I have a spreadsheet that I want to insert into the e-mail from the code. What is the way to do that? Thanks

Hi Before I ask for another favor, I want to thank all for being so helpful and professional. You guys are the best. This forum is the best. Here goes my little question: How - from code - could I reload (or requery) all currently loaded forms? Thanks

I have a listbox with many columns and rows. User has an option to sort that listbox. so everytime the RowSource of that list would be different. Based on that RowSource sql I want to print the report. How would I pass the current RowSource to the report? THanks

I have a listbox with many columns and rows. User has an option to sort that listbox. so everytime the RowSource of that list would be different. Based on that RowSource sql I want to print the report. How would I pass the current RowSource to the report? Thanks

Need to compact a current database from the code... Please help

Hi My Access 97 application is on our sharedrive. But my problem is whoever access that database CurrentUser is always ADMIN Why is that? How could I actually fix that so the user on the certain machine would be captured? Thanks :confused: