Search results for query: *

Good day gentlemen Here is the project I am working on. A simple form accessible via a web page. basically from the form you click a field that launches a query. From the query, you load whatever information you need from the table. What I am trying to do is a web base database for emergency...

basically your have crossing number field, street, cross street etc. The timing of the action is as follow, close the form, open the query window that shows the question to enter [what is the crossing number] than field are populated by answer. It is relatively simple action when you click. It...

I am looking at that solution. But my knowledge is not advanced has I would like it to be. I dont known if I should go with "dim record set" or controlsource= field name. Daniel Belanger

Good day all. Here is my delemma. I have one form, with lets say for the example, 10 fields. I want to be able to click on a field and run a query for that field. Each field has a different query attached to it. Whatever query i would run, it would always populate the same form. Right now I...

Sir I thank you You are in my gratitude. Daniel Belanger

Good day ladies and gentlemen I have a question about if then statement. I have a time field name easttimeof. I am trying to write a simple code in the after up date that If easttimeof = "12:00:00 AM" Then easttimeof = "00:00:01 AM" . In other words if 12:00:00 AM:shows up I want it to be...

That is exactly what I am looking to do. I tried separating the members which = [district][members][detachment] and [availibility status]. And than make a timesheet with all the date code. I linked the two table via the id numbers (autonumber). But the members field goes away and I have to...

Good day gentlemen and ladies Again thank you for all your great wisdom. Here is one of my last problem in my roster entry project. Here is the breakdown : basically the top of the form is the employee district, name and detachment and availibility status. At the bottom of the form you have...

Good day again In my main switchboard I want to put a macro to close a database to open another one. what would be an appropriate code or macro format to use. Thank you

Good day sir, I had the same problem last week. The formula I have used is; in your control window in the form design mode where you want the combining date and time to appear write this function =[date]&" "&[time]. Naturally date would equal the name you gave to that control and time the same...

Good day to you all. I am currently in my last mile for my project. what would be the code or macro to saved the data I just entered in my table and to save it into another table in another database. I hope that does not sound to confusing. thank you

Good day To save on aggravation of copying and pasting , the best approach I find is to create a replica on your notebook. when your finished writting in your notebook, you just synchronize with your local copy and that is it. you donthave to do anything else. just make sure thought that you...

Basically was I decided to do, is to go with a macro that goto the control and runcommand "copy" and "paste" the data into tblocalstartdate/time. It actually work mighty good. Next what I will do is converting the macro into code, to help in getting a quicker results. What I am trying to do is...

Thank you for your help. The time now() is not appropriate for what I am trying to acheive. I work for a police dispatch. What I am trying to put together is a roster form entry. Choose the member, choose the date on a pop up calendar, than choose the time from a drop down list. Than have that...

Good day gentlemen and ladies here is my dilema. I have an unbound control that is the total of two other controls "frstartime" =[beg]&" "&[timebeg]. as beg = date and timebeg = time. I am trying to replicate the result of frstartime into a control that is bound to a table. I tried writting...