I'm trying to convert a matrix within a table (m x n) to a single column. So basically
1 2 3
4 5 6
7 8 9
to
1
2
3
4
5
6
7
8
9
I would do this in excel, but the problem is I have already over 1 million rows, and I'm converting 48 columns into one (too much for excel). Is there a way to do this via a macro or query?
The other catch is that I want to repeat Column A (which has the username) with each row of data, for example
Joe 1 2 3
Sam 4 5 6
Jeff 7 8 9
to
Joe 1
Joe 2
Joe 3
Sam 4
Sam 5
Sam 6
Jeff 7
Jeff 8
Jeff 9
We recently updated to 64 bit Office 2010, however there is a form created by an intern who has since moved on, anyways the form was created in 32 bit. SO hence we cannot open it. We get any error message that it was created in 32 bit and cannot be open in 64 bit Office. I have tried to resaved the form on a different pc with 64 bit office. But it will not allow me to save, possibly because the form is locked down from changes. The file extension is .accde.
Is there a way of changing the column heading names on the split form portion of an access form. I tried changing them using a query to populate the form and changing the caption of each field in the query and that didn't work. I also tried adding a [Caption] at the design level of the table and that had no affect also. The split form seems to be displaying a portion of the actual field name or something like that.
I have a MS Access 2010 application when the User opens form CONTACTS Form
â—¦User finds single record to be used CONTACTID is identifier to be used for selection â—¦User clicks button to open form frm_MAIL_MERGE â—¦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID. â—¦User selects single .dotm file for merge â—¦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number â—¦User enters CONTACTID to be used for the mail merge â—¦User selects SUBMIT â—¦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID â—¦Merged document is saved on the user Desktop as xxx.docx
Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?
For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.
I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?
Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.
how data is best structured in Access.I have a table of values (for instance: weight) and I need to be able to look up a weight based on the column header (age) and row header (height).How is this sort of data best structured and accessed in Access?
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later FROM TESTSTAT WHERE [LOG_NO] LIKE '*' ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
I am working on a project that was started in access, but needs to be moved into an Access project so that It can be integrated with other forms. When I did this I realized that my database queries needed to be changed from Access to SQL code. for example instead of representing a date as #DATE# it needed to be represented as 'DATE'.
However I have one issue that I am having issues with.
I have a query that determines a few collumns by running information through a vb function and returning the result.
The issue is I do not know how to convert this code from Access to SQL so that it will work.
The code is
SELECT Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]) AS [Action], TESTSTAT.*, Action_date([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER])) AS Action_Date_Field, IIf([DUE]<[WAIVER],[WAIVER],[DUE]) AS Later FROM TESTSTAT WHERE [LOG_NO] LIKE '*' ORDER BY Action_Indef([DUE],IIf(IsNull([WAIVER]),[DUE],[WAIVER]),[LOG_NO]);
Can someone provide me with a sutible sql equvalent to this code
I'm trying to get a way to creat a database of my phone messages (SMS). I have them on a .txt file and I would like to create on ACCESS (or other program) the fields "Date:" "From:" "Message:", etc. So, everytime I introduce a day, all sms sended on that day appears, or, when I introduce a Name, every message from that person, appear. Is that possible? Of course that I want to convert it, not introduce one bye one because I have around 2000 messages...
Thank you very much
This is a example of the .txt file I have:
================================================== ========= Message type: SMS From: 0: Maria Date: quinta-feira 03 Maio 2007 15:33 ----------------------------------------------------------- Hum que bom então. Tou com a minha amiga na praça da república. Vais ficar aí? ================================================== ========= ================================================== ========= Message type: SMS From: Figueiredo 0: Maria Date: quinta-feira 03 Maio 2007 14:59 ----------------------------------------------------------- Tas em casa?a mariana foi aí? ================================================== ========= ================================================== ========= Message type: SMS From: Figueiredo 0: Maria Date: quinta-feira 03 Maio 2007 14:52 ----------------------------------------------------------- Já tá? ================================================== ========= ================================================== ========= Message type: SMS From: 0: Maria Date: quinta-feira 03 Maio 2007 12:47 ----------------------------------------------------------- Desce tou no carro em frente ao mc donalds.. ================================================== =========
I have been informed by an off-site program of ours (out of state) that they need to convert an Omniform application to Access.
I did an initial search on the web on Omniform but I really don't know anything about it.
Has anyone every converted an Omniform application to Access? Is this something that can be done in an automated way or would the Access db need to be made from scratch?
I have a question relating to Access, which I'm hoping that someone here can help me with. We currently have a large CD library, and a few years ago we had a database created in access which allows us to catalog all of the CD's in the library. Fields include information on artist, track title, publisher, composer etc. We're at a stage now where we'd like to rip all of our CD's, and have a searchable database which allows us to port across all of the existing data from access, but also to locate and audition the tracks themselves. I'm not an access programmer, so please avoid overly technical responses, but does anyone know of any software which would allow us to do this? Essentially we're looking for fully searchable mp3 ripping software with the ability to import data fields from access. Thanks
Hi, I have a few Access 2003 databases and I need to open them on my computer which has Access 2000 on it. Can anyone please tell me how to convert it so it is compatible? I have looked into "databse utilities" "convert to" etc but can't figure it out.
I am in the process of converting data from an excel sheet into Access 2000. I know the import procedure, however some of the fields in the Excel sheet have multiple data.
Is there a way to sort out this problem, short of cutting and pasting or re-entering the data? For example one field has the following: Mon, Jan 10,2006, 9AM to 11AM. I want to eliminate this field and create a field each for the day, date, start time and end time.
i'm importaing a table through a mysqlserver, it contains a field (call_time) and its a long integer, i suppose it's an unix date format that can be converted
into DD:MM:YYYY HH:MM format, only problem is i cant find a way to do it on access i've tried creating a query with all the fields and adding my one fields with commands such as valdate([call_time]) but it dosen't seem to work.
I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:
My code is:
On Error GoTo Err_Command151_Click
' Declare variables Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String
[Code] .....
The syntax error I get in Access 2010 is:
Syntax Error in query expression 'SELECT * FROM qryContractListSummarybyDateContract3TYPEBREAK WHERE qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri Masonry NSW');'
I've been hired to clean up and convert a flat filemaker database into access 2003 and I've spent the last two weeks learning the ins and outs of access and doing preparations. Well, today some high up database guy in another department told me not to use access because in the future when a new version of access comes out we will have to recreate the database from scratch because there are lots of problems converting between versions. I'm aware there might be some hiccups but I don't really agree with him. Plus once the database is up and functioning I don't see why we'd even have to upgrade it to a new version. It's just a small health centre patient database with info about patients and their treatments. Does anyone have any opinions about this. Thanks.
Hi, I am converting a database from Access 2002 to Excel 2002 but when converted each value in the spreadsheet has the value ' directly before it. Is there anyway around this problem.
A group in my company has, for quite a while now, used a spreadsheet template to capture information needed for customer hard output. Someone built a page, with the less-than-a-dozen required cells in the appropriate places and a set print area, for printing the information. After they enter the information and print the page, they save the excel file. They have been doing this for quite a while now, and the number of files they have on their shared drive is staggering... and the method they using for naming conventions and cataloging them is almost beyond comprehension.
As they do indeed refer back to these files quite a bit, I am wondering if it possible to import the required cells of information from this mass of excel files, all of which are formatted and laid out the same, to an access table. I have never considered this before and have no idea how to start or whether it is even possible. I did a search on "import" but no results match what I am considering here.
To clarify one thing about these files: The information is not contiguous. It is spread all over... C6, E12, F45, J5, etc. They tried to build the form in excel so that it would print in the format they needed.
I would like like to convert some of my Access 2003 databases to 2007. I am on a stand alone pc running Vista Business and Office 2007.
When I follow the "convert" instructions using either the SAVE AS option (or even the CONVERT), I get this error message which prevents the conversion taking place.
"You attempted to open a database that is already opened exclusively by user 'Admin' on machine <name>. Try again when database is available."
My Vista User Account is one of administrator.
Any help would as always be appreciated. Thank you
I am trying to import certain data from a massive excel workbook into different Access tables but some of the worksheets contain simple formulas such as multiplication and division. I was wondering if it is possible to create these same formulas within Access? If it is possible then what are the necessary steps to create them? Thanks!
I have been tasked with converting a spreadsheet to an access database. I work for a growing firm of Tree-Surgeons (no pun intended), who service a sizeable chunk of the power grid in the UK. At any time, we have up to 150 operatives in the field, cutting vegetation around power lines. Because of the obvious danger, the power company need advance warning of where any teams will be cutting on any given day.
Various team leaders call in each day and give their intended locations for the following day to an individual who's responsibility it is to log the info onto a central spreadsheet, an Excel workbook. Each workbook contains a worksheet for each day (Mon-Fri). Each worksheet contains the following fields:
1. Number (Unique Numerical Sequence for the individual) 2. Name 3. Phone Number 4. Working/Not Working 5. Type of Line (132kv, Extra High Voltage (EHV), High Voltage (HV), Low Voltage (LV)) 6. Area (in this case a lookup of 8 geographical areas) 7. SubStn Number (a name of exact location followed by nn/nnn) (LV Only) 8. Circuit and Pole Numbers (a location followed by nn) (HV Only) 9. Locality (nearest village/town) 10. Grid Reference (nn/nnn/nnn) 11. Time On-Site 12. Time Off-Site
So far I have created a table (Called Contact) for the individuals:
Team Members can move between teams, but Team Leaders remain largely static.I guess I should create a separate table for Team Leaders and Team Members, with a one-to-many relationship between them? All of the others could be around the network but would not be attached to a Team Leader, so I guess they can be in the same table as Team Leaders for the purposes of tracking their location.
Also, what is the alternative to using a look-up for some of the fields, for example the Area field? I was concerned about breaking one of the commandments, and cant see a reason why, but I await enlightenment!
