Search results for query: *

I was wondering if there was any code that could be involved that would automatically fill in fields. I have this form in which everyday all 25 of my drivers are being put in. The only thing on the form that changes is the date. I have the default value set for current date in the date field...

I was told to use the upsizing wizzard in access. I kept getting this error message saying that my connection failed. So then I logged In as the administrator then a overflow message appeared. Do I need to get on the actual server inorder to convert my backend from access to sql? I wouldn't...

I have a Field called "time" where I can input hours for the day. Then i have another field in which I can subtract hours and minutes. For instance if someone took lunch for 34 minutes I would be able to subtract that from the time. I can always get my total time for a single day...

I figured out how to do a difference in times and get it into this format hh:mm. But now my problem is when I want to add the total hours up for a week it will not let me. It will only allow me to go up to 24 hours. What could I do inorder to have a value of lets say like 40 hours and 35...

Is there a way to Have a YES/NO Field Type but if you check yes on the form it would print out whatever the field is on a report. For example: IF you have a field called "Late". On Your form there will be a box to check. Then on your report you want it to print the word...

I was wondering If I could change my backend to sequel. If that could be possible. I've heard that it could be done. But I don't know.

I want to be able to do a time calculation that will not let the minutes go over 60. Right I have the get the difference of two times to be something like 10.75 hrs. I want it to be like 10 and 45 minutes. Can I please get some help!!!!!

I'm getting this #deleted in all of my fields for a certain record. This record was not created by me but everytime I delete this record it (#deleted) reappears again. How can I stop this from showing up

I'm kind of new VB so I was wondering if I could get some help. I have two fields (Begining and Ending Odometers) that need to be calculated. They get the odometer readings off of the trucks and input them into the database. I want to be able to have the default value in the Beginning...

The program I'm trying to write has a value for each letter in the alphabet. When someone enters a word I want to be able to total each letter in the word up and show a total value for the word. I was wondering if i was on the right track. I'm just trying to test it out and no matter what...

I am trying to write a program that will let a user enter a word. Each letter in the word has a numeric value. Example; a=1, b=2, c=3, etc... If the user enters the word "AB" the value would be 3. How can I set this up? Should I make an array called word?

I have this mileage calulation for our different trucks. I want to make my default value for the beginning odometer reading to be equal to the ending odometer reading for the previous day. What do I need to do? Or if this can't be done what kind of validation rule can I have to minimize...

I've just created a database for my boss. The problem he had with it was when he opens up a certain form the information from the last time was still in there. So I created a macro that would only let him add records. But now he wants the form to open up with no information filled out but he...

I created a new form with a calendar. I tried to click a day and it is bringing up all the days again. This is the expression I used in my date field: (="#" & Forms![name of form with calendar]![name of calendar control] & "#" ). Every time I try to run the query it will...

If you want to be able to click on anyday in a calendar and have it show you the report for that day what do I need to do. I made a form that has the calendar. I created a button to preview the report for that day but its showing me all the days. Is there a macro needed to perform this?

If a user wants to be able to at anytime pull information between two dates without you having to keep making a new query. How do you set up a query that will let a user enter two dates?