Search results

I did format the field, but the problem is that Im not saving this data, im using the calculations as I need them. In particular im calculating time, and on my form it works just fine, but in my query it comes up as a negative double number.

How would you specify the data type for say, shortdate in a query when you calculate time? Or if I wanted to add and subtract numbers with a fixed decimal point. I know you can specify datatype with a parameter query, but then it asks for the parameter, which I dont want. Is there any way to do...

hmmm.. well the calculated data i needed to store would never change, and we need to keep record of it, so that if we need to go back and look at the data we dont have to recalculate the same values.

Validation Rules for Data Integrity I have a field that looks up the JobType using a LookUp Combobox from another table where these records for JobType will never change. I want the user to only be able to select from the Combobox for the job type they want and be able to type the beggining...

How would i go about saving the data in a calculated textbox on a form into a field in a table? For example, on the form there is =[MatchedPages]+[UnmatchedPages] that I put into a textbox. I now want to store those results in a table with the field titled TotalPages. How would I do this?

OMG wow, this is much simpler than i thought! you guys are awsome! thanks soo much for your time to help me out. :D Now all I need to do is get it to store that calculated time in a new field in the table. How can I assign the calulated time in the textbox to the new field in the table1 called...

What type of references would I need? And how would I know if it is missing or not?

So if I put DateDiff("???",[StartTime],[EndTime]) what do i put to get the time? also, what data type would i use for the total time field? It would be nice for it to be double, and go out to 2 decimal places.

Thanks, but i tried the download, and when i load it it comes up with "cannot find date library" errors and such. That data base is not working for me, and I have A2k. I tried to look at some of the stuff, but it is beyond me how it works, im pretty new at VbA and I am at a begginer level...

I'm having difficulty figuring out how to calculate time. To test this i have three fields. The first field is StartTime and the second field is EndTime. The third field, TotalTime stores a calcualtion, which is how much time is between the start and end times, which is basically the total...

I got the Union Query working, it only allows 50 tables at a time, or is says "QUERY TOO COMPLEX". But when i make an Append Query for the Uniion query1-50, it says "QUERY TOO COMPLEX" when i try to execute.... any help? :confused:

Yes, all tables do have the exact same names every time. The union query is not looking mighty tempting, i will experement, and post some results if all goes wrong. Thanks a whole bunch guys, this really helps me out, if you still have any suggestions please let me know. :) *EDIT* ok I need...

Is it at all possible to append 100 or so tables into one main table? All attempts have failed, and i do not want to make 100 append queries to do this. Is there any possible oter way to do this, prefferably in VBA? -Thanks in advance :)

Hey guys, i had an idea and wanted to if it sounded plausable before i went into that crazy thing called development. The windows search bar onlly allows for 255 characters in the search box, making searchinf for large amounts of files much more difficult. Is it possible to have a form that...

I need to have a table renamed when a tab is selected, and when a different tab is selected, i need it to rename the first table back to its orignal name, then rename the next table. For example: These are the tables ConcatenateM&M-002 ConcatenateM&M-003 ConcatenateM&M-004 ConcatenateM&M-005...

well, The forms that i make use macros to preform many tedeous tasks, i just need a simple textbox that can be incoperated into a step in a maco. Where would I use the code posted above? In a module? i dont want to create a form just so i can use a simple text box. But, I will need to have a...

How about inside a macro? Condition: MsgBox("Confirm changes?",1)=1 Action: Stop Macro This displays a Ok, Cancel message ox that is suppoed to stop the macro if the Cancel button is pressed, but it does the opposite for me, it runs the macro either way

How do I make a message box? not the ones that you find in macros that only allow you to press ok, bu i mean message boxes that can decide what action happens next, with yes & no buttons and such. Can anyone help me out?

Hi guys, here is my problem. I need a query(s) to preform the following tasks. Each part represents a what a query needs to do, if the parts can be combined to prefom the same task(s) with less queries, that is also acceptable. Part1 -------------------------------------- I have a fields...

WOW, this really helps, silly me trying to re-invent a square wheel... U gys are awsome, thanks a whole bunch.