Search results

hmmm ok then, guess I need to figure out if I need a screwdriver or a sledgehammer :D So please help me understand the following sql: SELECT [Address] & ", " & [City] & ", " & [State] & " " & [Zip] AS FullAddress, PCID, PMID, ServiceType, DateCompleted, pInvoice, nInvoice, ConvInvoice AS...

Hello all, As mentioned before, I am going through a database designed by someone else and trying to salvage what I can. This database has about 10 union queries. I have never used them as I was under the impression they are quite slow, and I never needed to compare data from two queries...

I have come across a program from bay state consulting that will import the excel list to the customer list in quickbooks. It also seems like you can automate this process by either using command line or the windows scheduler. So it IS possible to do what I wanted, I am just wondering if it's...

That, and this frequent conversation: "Do you use this form for anything?" "No." "Has anyone used it recently?" "I don't think we have ever used it." "Do you know why it was made?" "No, I haven't even seen it before." "Does anyone know why it was made?" "Nope." "Ok, well I'm going to get rid of...

Fantastic explanation, thank you so much!

All good information I appreciate it. I would LOVE to walk through the business plan before even touching the computer. Problem is, the BUSINESS doesn't even know what it is. I am running off the way things WERE done, guessing how things SHOULD be done as they are changing the way their...

That makes sense, but all the fields are required so there should be no blanks. Is there a reason why you would choose Min over Group By?

Hello All, I am redesigning a database and there are some queries that use the Min total. I understand why you would use this for numeric fields, but I can't find anything online that explains why you would use Min for text fields. Is there any reason why you would or need to? When I remove...

Ok now I'm back to the same question hahaha, thank you for the other opinion ButtonMoon.

BEAUTIFUL thank you this is very helpful!

Hello all, I am redesigning an access database, but I have no formal training so I am not sure what it the best practice to use here. Currently, there is a new data entry form with a record source of a selection query. When new data is entered, it is split between two tables (the two that...

Hello all, Looking for a way to fully integrate MS Access 2007/2010 with Quickbooks Enterprise Solutions. And I mean, fully integrate. It seems like most options I have found are import/export drivers with the occasional perk, but they all seem to lack something import. Currently, I am...

Requests of the company that wants everything in Access :( Currently they are using Google Calendar, but they have had issues in the past since it is so easy to accidentally move around an appointment and mess things up downstream. So they want something that looks like Google, in Access, so...

So I have ten Text boxes in a row. Depending on the appointment length, it will subtract the TOP from the textbox at the end appointment time, from the TOP of the textbox at the start appointment time. The code will also look to see if a color has been applied to a text box to the right of it...

So here is where I am at, and thoughts or advice is greatly appreciated: The company I am designing this for wants the calendar to be in Weekly View, Monday - Friday, from 6 am to 8:30 pm. This calendar will be made up of several different calendars. There is a combo box that will allow you...

strSQL = "UPDATE OwnershipLog SET OwnershipLog.[Current Owner] = Null " _ & "WHERE OwnershipLog.[Chassis_No]= '" & Me.CChassis_No & "';" Same thing with the 2nd SQL, doesn't look like you are connecting the stings correctly...

try ado.database and ado.recordset or dao.database and dao.recordset I believe dao is the old school version but it is still supported you will also have to set your references to allow for ActiveX Data Objects (ADO) or Data Access Objects (DAO).

I am making a calendar form in Access and want it to look like Google Calendar as much as possible. I am wondering if there is a good way to go about setting up the form to allow for multiple appointments scheduled for the same time. Designing the form to be in Week View with half hour blocks...

Any thoughts on this?

This question involved MS Access 2010 and Windows 7 Professional. I have a .chm file located on at C:/Windows/Help and it is opened in access using the following code: [CODE] Declare Function HtmlHelp Lib "hhctrl.ocx" Alias "HtmlHelpA" _ (ByVal hwndCaller As Long, ByVal pszFile As...