Search results

giorgospsk, When you reference a form Access fills in the name of the database because you can reference stuff in another database from the current one. My guess is that sharepoint needs the full name of the database then the form name. I am afraid I don't know the format for this, but you might...

satswid: "to add a field which is combination of two fields" This is asking about concatenation and you can do it on the report. In the text box on the report enter this: =[Address_Eng] & ", " & [Address_Por] Privateer

firefly2k8 Your query has a sub query in it, which is why Access added the alias and I can't see why you would need it. Try using just this code: SELECT STDEV((High+Low)/2) AS StandardDeviation, DateValue([Date_Time]) as TheDate FROM TSTable WHERE ((DateValue([Date_Time])=#12/2/2011#) And...

Fairman: First alias the hours fields so they have different names, query1: TotalHours and query2 ExtraHours. Then in query two, you need to pull the first letter of the EventWkCode so you can match up F with F_UST, so EWC: left(query2.EventWkCode,1) Now in the third query, using 1 & 2, you draw...

leevbyrne: The answer is pretty easy. Create a query where you average the salaries from the source table using the following formula: AvgComp: Avg(tblCompensation.Salary) Create another query with the source compensation table and this average query as recordsources. There is no relationship...

Building a DB to track my investments. Assuming I have the stock ticker, does anyone know how I can pull a stock price from out there into Access?

Thanks for the answer Bob, obviously I was hoping for a different answer. I just assumed all properties were available in VBA. BTW, your link pointed to a local url.

Your example is not mathematically sound. 0-6 averages to 3, 6-16 averages to 11. Can you explain a full minute so I can see if the answer involves math. Otherwise, take the minutes away from your data/time record and use a case statement to tack on whatever minutes you want.

The minimum (underscore), maximum (box) and close (white X on red background) symbols in the upper right corner of all forms are in a control box. In the form's property you can modify what is displayed. I am trying to modify when and what is displayed when the form opens. So I am not trying to...

I would like to flip the switch on the form's control box in VBA. The current code is: Me.ControlBox = True Me.CloseButton = True It errors out on the first line saying I can't assign a value to this (2448). I know this can be done using the properties window, but I am changing how the form...

Smig, I am not sure what the end game is here, but you might want to try Me.Form.Name, as a reference to the property. That phrase will give you the name of the current form. Often I use it with with haha then you can copy stuff like this to any form and it will grab that form's name. With...

Wayne, You can't update a new record. You append a new record and use last modified to go to it, or you update an existing record and don't move. If your form is attached to a query and you are requering this will put you at record one. The solution here is you should consider having one form to...

Thanks Galaxiom, that got me one step closer. Now the error (2498) is: "An expression you entered is the wrong data type for one of the arguments." I am certain all twelve fields are matched up as text, date, or long integer. Do you know of any examples of working delimited and fixed width...

Hello all, first post here. I hate to trouble you with a text import problem, but this will save a lot of time if we can make it work. Let me also mention that I am aware of saving the spec files during a manual import, but the front end is being passed around and each person could create a...

If Allen's stuff doesn't work, consider opening a blank database and importing all tables, queries, and modules. Then import one form at a time and test its functionality. When you find the bad boy, it may corrupt again, and you may have to start over. But the next time, remark out all the...