Search results for query: *

Is it possible to import an xml file into acces and not have access break it up into multiple tables? I would like it to place it into one table like it does when you import it into excel. Any insight?

Here is what I am trying to accomplish: I have a xml file that I need to open in excel, then need to sort for unique records, then need to sort one column for (Non-blanks). I then would like to save the excel file and import it into a database as an excel table. Is there an easy way to...

My database currently authenticates users using their Windows ID I have two modules as seen below: The first is called GetUserName Declare Function wu_GetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) _ As Long Function ap_GetUserName()...

That post selects multiple records from one column. I am trying to select data from multiple columns and pull together to form one string.

I am trying to concatenate multiple fields into one based on criteria. I have no idea as to whether it is possible to do this in VBA or SQL or both. I have a table with: ItemNo as one field Tool1 as another field Tool2 as another field Tool3 as another field Tool4 as another field I want to...

The following code below will export data from access to a word document. The problem lies here: If one of the fields on the access form does not have data, the data export will stop at that field in the word document. Is there a way to skip that field if it does not have any data? Here is...

I need help with the following code. What I want to do is export the data from a access form to a word document. If all fields in the access form have data in them, then it will fill the word document completely. However, if the code see's one field in access with no data, then it will stop...

Is there a way to show a subreport even if there is no data in it? I still need the fields to show on my report.