Search results for query: *

How do I display the total number of records? Is there a function? for example: total sum has function DSum so what would total records be

Is there a way?

I have a function that I made in Modules called modFunc... fGetCost([Date],[Time],[Duration]) This function results in indicating a Cost according to Date, Time and Duration. I need to update ALL RECORDS using this function. Is there a way of applying this function using update query to...

I have a function... fGetCost([Date],[Time],[Duration]) This function results in indicating a Cost according to Date, Time and Duration. I need to update ALL RECORDS using this function. Is there a way of applying this function using update query to update all records in my table?

The code I have is this: Select Case Me![Time] Case #7:00:00 AM# To #8:49:59 AM# If Duration = 15 Then Cost = 33 ElseIf Duration = 30 Then Cost = 55 ElseIf Duration = 45 Then Cost...

I have a table called PRICE with Duration, Time, and Cost I wrote a code using Select Case method for the Cost. This cost is related to Duration and Time. What I need to do is calculate the Cost for all RECORDS. So for example (My Cost field is blank right now since I can't get this part to...

I'm fairly new at this so.... how do I link a table that has a Number field with another table that has a Number field. I'm trying to update the first table that has actual numbers with the second table that has a number field with no numbers.

I have a table with the following fields. List Date Time Duration COM-HB-NEVERBETTER-0506.mpg 5/12/2003 10:13:11 PM 0 COM-HB-DEALERLAUNCH-0506.mpg 5/13/2003 11:58:12 AM 0 COM-HB-DEALERLAUNCH-0506.mpg 5/13/2003 6:27:44 PM 0...

I have a table with the following fields. List Date Time Duration COM-HB-NEVERBETTER-0506.mpg 5/12/2003 10:13:11 PM 0 COM-HB-DEALERLAUNCH-0506.mpg 5/13/2003 11:58:12 AM 0 COM-HB-DEALERLAUNCH-0506.mpg 5/13/2003 6:27:44 PM 0 COM-HB-DEALERLAUNCH-0506.mpg...

How can I use password protection for my access file?

I have a list of records. I want to be able to update the whole record from a click of a button. But what I have seems to only update one record at a time. According to Time, I want to be able to update Cashflow. So, I have a bunch of Time and with one click, be able to update the whole...

I have a list of records. I want to be able to update the whole record from a click of a button. But what I have seems to only update one record at a time. According to Time, I want to be able to update Cashflow. So, I have a bunch of Time and with one click, be able to update the whole...

I have a table with a List, Date, Time, Duration, and Price Field. The list fields are composed of names such as List Duration D:\Commercials\tiger1.mpg D:\Commercials\tiger2.mpg D:\Commercials\tiger3.mpg D:\Commercials\tiger1.mpg D:\Commercials\tiger1.mpg...

I created an Import Command button ( DoCmd.RunCommand acCmdImport ) which works exactly the same as the on in the File menue = > Get External Data => Import. It works except that, when I press my Import Button and Cancel, I get an error. Is there a separate code when Canceling the import??

I have a Date Field, Time Field and a Rate Field in a table called tblLogs. There's this one problem I'm encountering and hopefully someone can help me. The Rates of these Dates depends on the time range. Here's the code for the different rates for different time ranges. Select Case...

I have a textbox named txtRate. For every record, I have different values in the txtRate. How do I summed them altogether into a different textbox, lets say txtTotal.?

Is it possible to convert the project into an .exe file?

I'm aware of importing for example excel files into access by going to the file menu => get external data => import. But I want to create an Import button on the form just for simplicity. Is there a way to make this Import button and call the same thing just like going into the file menu?

Is there a way to deactiviate the textbox so user can't change the original textbox caption?

I was wondering what's wrong with my laptop. I'm experiencing a major slow down and it's taking me forever to even get into windows. And when I actually reach windows, I can't even do anything b/c it's too damm slow. I was wondering what would be the exact problem. I think it's an internal...