I have all my customer information in a database program called Maximizer CRM 11. I inherited this info from another worker. I would rather use Microsoft Access. I am thinking that I can export the Maximizer database to a csv file. Will that include all the fields and can I import this to a new Access database? Is it a seamless transfer or is there more I need to know to accomplish this? Thanks for your help with my project.

Member Avatar
Member Avatar
+0 forum 10

Hey guys, Basically i want to create a database in Access 2002 that will hold names of functions of a mobile phone. When the user enters a search the databse should query the information held within it, display the appropriate search results. It should be able to serach for precise function names entered such as Write Message,Inbox, Message Settings, Clear Cache memory. Partial words such as WRI would display WRITE messgae, Write email, TEmplate, and INB would display INBOX,and also ambigiuos words such as message the results should be Inbox, Outbox, saved messages etc. all words that are related to …

Member Avatar
Member Avatar
+0 forum 5

I have just started using Access 2010 and am experiencing problems with it corrupting the database. To take one example I have a database with one module in it. Today when I open the module in design view Microsoft Access falls over with the error "Microsoft Access has stopped working" Compact and repair does not fix it. you can't import objects into another database because that causes Access to fall over as well. It is a recurring problem and it is driving me batty. Has anyone any ideas on what is going on.

Member Avatar
Member Avatar
+0 forum 4

Greetings, I have just went from Access 2003 to 2007.... I have a project requiremtn to output some reports to PDF file format... Don't know how to do it.... I tried doing a little research but.... :-( I am open to ideas... I would like to automate the process so my clients just click a button or something to make the output go to PDF. Thank you in advance !!! Regards, OASys1

Member Avatar
Member Avatar
+0 forum 2

Hello! Now I am trying to make selection of Customers easier for my user. My user's business involves making deliveries on [B][I]routes[/I][/B]. Every customer is assigned a route number, which references the route in the route table. In my form I want to have [B][I]two list boxes[/I][/B], side by side. [B][I]lb1[/I][/B] showing customers already assigned to the route, and the other. YES, all other customer NOT assigned to this route - [B][I]lb2[/I][/B] ... clever huh ? :-). Besides the usual buttons ( " < " & " << ", " > " & " >> " )< I would like …

Member Avatar
Member Avatar
+0 forum 1

Hi Guys, I want to use the Autonumber function in my table in a specific format. The format is SP10000. And I want Access to automatically number each entry by one with each new entry eg. SP10001...SP10002...SP10003. Please let me know how I can do this as when I use the autonumber function it only gives me simple numbers such as 1...2...3...4 etc. Please help Thanks

Member Avatar
Member Avatar
+0 forum 1

I have been fighting with this all day and looked at so much documentation and other posts I think I am going blind. I can't find an answer that works. I am trying to read through a set of records until the reference number changes and then return to the first record with that reference number to do some calculations. I want to continue to loop through the record set until I have touched each record twice and written out each record once. I am using the ADO .find to return to the first record with the reference number and …

Member Avatar
Member Avatar
+0 forum 3

Hello all! I'm making a Applicant Record Keeping System. I'm a newbie with MS access. And i'm having a really hard time understanding how queries work. I have three forms: (Sequentially) Background Checking Criteria.. Document.. So, this forms are for one applicant and they have common details. Background Checking's common details with the other two are Name of Applicant and Position Applied For. Background Checking's common detail with the Criteria Name of Applicant, Position Applied For, Date of Application, and Conducted by. Criteria's common details with Document are Name of Applicant, Position Applied For, and Vessel Type. So, I want …

Member Avatar
Member Avatar
+0 forum 2

How can I open a Record from a Listbox Using a Command Button?

Member Avatar
Member Avatar
+0 forum 1

Hello friends, I am looking for a bit of help. Here is the scenario. I am trying to compile sales data for a number of stores from multiple databases and import them into excel for the current month by day. I have a field for date and sales. The problem I am having is some stores are open Sunday and some arnt. When I run my query the stores that are off that day skip a day. If there a way for me to set up my query so that if there are no sales for a day make it …

Member Avatar
Member Avatar
+0 forum 3

hey im new to microsoft access and databases.im trying to create database with Tables for 1.Researchers(have that) 2.Test performed by researchers (at least 5 different tests)(have that and my 5 test are diabetic,blood type,high blood pressure,positive for drug tests and eye sight) 3.and Results of the tests given by researchers Data entry 1.forms(dont have that) 2.new researcher being able to be added to database 3.Test results(dont have that) Populate the DB with sample data(have that) I dont understand forms and querys and how to connect the data.Please help me and i used random data generator to tes this.Thanks

Member Avatar
Member Avatar
+0 forum 1

Guys,i want a small help from you.I have a created a database in MS Access and now i want to connect it to with Java Application by using ODBC Administartor.But when opens it,it doesn't show any driver for MS Access DBs.Do u guys know any driver for that.I'm using Windows 7 64-bit version.Please help me ASAP...

Member Avatar
+0 forum 0

Hello, I am trying to query a table for todays date based on this format mm/dd/yyyy hh:mm:ss AM/PM I tried date() but it only returns results based on the mm/dd/yyyy formate. Any assistant is apprecaited! Thanks, Wez

Member Avatar
Member Avatar
+0 forum 1

[CODE]980 Set rs = db.OpenRecordset("0 - Supplier List") 990 RptLoc = 0 1000 If rs.EOF = False Then ProcessCount = ProcessCount + 1 1010 Do While rs.EOF = False [COLOR="Red"]1020 XL.Sheets("Supplier").Copy Before:=XL.Sheets("Supplier") 1030 XL.Sheets(2 + RptLoc).Name = rs!Supplier[/COLOR] 1040 RptLoc = RptLoc + 1 1050 rs.MoveNext 1060 Loop 1070 XL.DisplayAlerts = False 1080 XL.Sheets("Supplier").Delete 1090 XL.DisplayAlerts = True 1100 rs.Close[/CODE] when i get to the this lines i get error 1004.. any idea how to fix it.. thanks ^^

Member Avatar
+0 forum 0

i'm trying to get data of 30 minutes ago to now.. any idea with the query [CODE]SELECT DateDiff("n",Now(),[TimeStamp]) AS [Time] FROM RIMData_RAW GROUP BY DateDiff("n",Now(),[TimeStamp]) HAVING ((Now()>30)); [/CODE]

Member Avatar
Member Avatar
+0 forum 1

Hi There experts... i am hoping that someone will be able to help me with a problem... I have the following vba code.. some of you that are clued up with vba will know... it is a code i got from the net that allows me to choose dates before running my report... Private Sub cmdPreview_Click() Dim strReport As String Dim strDateField As String Dim strWhere As String Dim lngView As Long Const strcJetDate = "\#mm\/dd\/yyyy\#" 'Do NOT change it to match your local settings. 'DO set the values in the next 3 lines. strReport = "Main View" 'Put your …

Member Avatar
Member Avatar
+0 forum 1

Hi I have made lots of Access databases over the years but it seems I have fogotton lots of basic principles since I have not used it for ages. One thing I want to do is: For instance when you send an email using Yahoo or similar webmail if you are adding an attachment there are 5 spaces to add 5 file attachments. If you are adding more than 5 you click on add more files and another box appears ready for you to add another attachment. I want this to happen in Access only instead of adding file attachments …

Member Avatar
Member Avatar
+0 forum 9

Main Form = Frm_Engineer_Search Sub Form = Frm_Engineers Frm_Engineers populated by Tbl_Engineers I've been trying to link together a textbox with a subform so when a surname is entered into TxtSearch and CmdSearch is click it will run a query/refresh the subform displaying the correct record which correspond to the entered surname. Is this possible? I've tried entering into Qry_Engineer_Search in the Surname attribute criteria [Forms!][Frm_Engineer_Search!][TxtSearch] and add me.refresh to CmdSearch Click event but it just refreshes the whole form. Any pointers? Thanks in advance

Member Avatar
Member Avatar
+0 forum 2

I've created an append query to move records from one table to another. Am i right in thinking it should move the records then delete them from the previous table? If so then for some reason its not working for me. Using MS Access 2003. [ICODE]INSERT INTO Tbl_Job_Temp SELECT Tbl_Job_List.* FROM Tbl_Job_List WHERE (((Tbl_Job_List.[Date of Visit])<=Now()-120));[/ICODE] Above is the Sql Code for the current query. Also is it possible to append to two different tables? If is it possible to run two queries at the same time on event click of a command button? [ICODE]INSERT INTO Tbl_Assign_Temp SELECT Tbl_Assign_Engineer.* FROM …

Member Avatar
Member Avatar
+0 forum 3

This is problem that I have struggled with for some time, but im sure the answer is very simple... I have a sub report that performs calculations on 2 fields ( [Rate] [Hours Worked] ) from a table called [Hours]. The report is GROUPED by [Rate] and is as follows: [CODE] | | | | [Rate] | [Total Hours Worked] | [Total Billings] ============================================================ | =[Rate] | =Sum | =Sum | | ([Hours Worked]) | (([Hours Worked]* | | | [Rate])) [/CODE] So some example data would look like: [CODE] | | | | | Rate | Total Hours Worked …

Member Avatar
Member Avatar
+0 forum 1

Hi, I want to know that if i have form in html and i want to save data in MS Access or any other database so is it possible? if yes so how? i use php to connect mysql but i didn't use simple html connection... I hope someonw iwll help me... Regards.. Farhad

Member Avatar
+0 forum 0

I have a database with a list of process owners. The users of this database wants the process owners emailed when a form is updated with a click of a button. I can email to one person using a macro but this requires additional codeing which I am not all that great with. Any Access Experts available to answer this one? I have a table containing the process owners names and email addresses I have a form that requires the process owners to be selected from the table Once the form is filled out, click on email, its to send …

Member Avatar
Member Avatar
+0 forum 1

Please could you tell me where I am going wrong I want to open 1 of 2 forms depending if a certain text is present in a field of a table. If text "Expired" is present in the 'Name' field of Table 'MAIN' then open form 'Expired' and if is not present open form 'Data_In'. The following code in the 'On Open' Event Criteria of a Hidden form, and does not work, that is to say neither form opens: [CODE]Private Sub Form_Open(Cancel As Integer) If DCount("Name", "MAIN", "Expired") = 0 Then DoCmd.OpenForm "Data_In", acNormal Else DoCmd.OpenForm "Expired", acNormal End If …

Member Avatar
Member Avatar
+0 forum 2

I have two tables like Staff Table ............ Staff ID Staff Name Age ...and more Staff Salary Table .................. Staff ID Staff Name basic Salary ...and more Now I have created the Staff Salary form in which I got the staff ID from the staff table using the lookup wizard query in the Staff ID field of the Staff Salary Table [B]SELECT [Staff Table].[Staff ID] FROM [Staff Table]; [/B] but I need one more When The staff ID was selected from the drop down list, I need the relevant staff name (from the Staff table) also be displayed in the …

Member Avatar
Member Avatar
+0 forum 1

I'm trying to create a database to store product and customer information. An item have many batch numbers (batch ID) a batch number can only belong to one item an item can be in many products a product contains many items an order can contain many products a product can be in many orders a customer can have many orders an order can only be for one customer from this information i have created the following relationships.[URL="http://postimage.org/image/2fva2x890/"]http://postimage.org/image/2fva2x890/[/URL] Is this all correct?? i think the relationship between batch ID in tbl_batch is wrong?? Cheers in advance

Member Avatar
Member Avatar
+0 forum 1

Does anyone have any experience using curl from MS Access. I would appreciate some pointers,

Member Avatar
+0 forum 0

I just want to know about the new extension in Access 2010. I need to create a database with .mdb and I can't do it with Access 2010 'cause the new extension is .accdb or something like that (I don't remember :$) As you can see, I don't use it too much but I need to create a .mdb database now so my question is: How do I change the extension? I tried to do it in the save file dialog, but there's no option.

Member Avatar
Member Avatar
+0 forum 1

Hi, I want to make a report of several fields - however, rather than showing each record for each field I just want to display totals. Given this I think it would read a lot better if I had the field headings in one column down the page, so it reads downwards as a list. Is it possible to format a report in this way? Thanks very much.

Member Avatar
Member Avatar
+0 forum 3

I have 2 table [EMPLOYEE] Emp_ID Emp_Name [ATTENDANCE] Emp_ID Emp_Name Time_In Time_Out How do I display it like this. I hope I present this right [CODE] +--------++----------++---------++---------+ | Emp_ID || Emp_Name || Time_In ||Time_Out | <---- FROM ATTENDANCE +--------++----------++---------++---------+ | 1 || Josh || || | <---- FROM EMPLOYEE +--------++----------++---------++---------+ | 2 || Carl || || | <---- FROM EMPLOYEE +--------++----------++---------++---------+ [/CODE]

Member Avatar
Member Avatar
+0 forum 1

DATA TYPE MISMATCH ERROR CRITERIA [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text <> " " And TextBox2.Text <> " " And TextBox3.Text <> " " And TextBox4.Text <> " " And TextBox5.Text <> " " And TextBox6.Text <> " " And TextBox7.Text <> " " And TextBox8.Text <> " " And TextBox9.Text <> " " And TextBox10.Text <> " " And ComboBox4.Text <> " " And ComboBox5.Text <> " " And RichTextBox1.Text <> " " Then Dim s As String Dim sex As String If RadioButton1.Checked = True Then sex = "Male" Else …

Member Avatar
Member Avatar
+0 forum 1

The End.