Hello All; I usually do everything in SQL Server these days, however, I have an site that is just so small, that it is going to be using an Access database. This is the code that I am using to generate the Google Sitemap with, however, there is code here that does not translate over to ACCESS Database. SELECT imageid, imagetitle, MedUpdate as DefaultTime, convert(varchar(11),MedUpdate,121) as UModDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedUpdate, 113), 114) AS UMilTime, convert(varchar(11),MedDate,121) as JDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedDate, 113), 114) AS JTime FROM Images GROUP BY imageid, MedUpdate, MedDate, imagetitle order by imageid Could someone please convert this …

Member Avatar
+0 forum 0

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

[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

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

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

Member Avatar
+0 forum 0

Hello, Please I need an efficient algorithm for ranking records in a database. I know sorting and grouping can produce record ranks, but I want a means of inserting the ranks beside each record as arranged in the table. For example: [CODE=text]This figures will rank 10 - 3 5 5 43 2 78 1 9 4[/CODE] Thank you for your understanding

Member Avatar
+0 forum 0

Hi all, I have a Website developed by PHP4.3.2 and Microsoft Access2000 Database. The Site is running under IIS5 in Windows Server2000. Now I have changed the OS from Windows Server2000 to Server2008 and IIS is 7.5 here. I have configured PHP with FastCGI. But, When I run my site through IIS7.5, all PHP pages are opening well except the pages which are including Access Database Class File. I have used: include_once("lib/clsDB.php"); to call the Database Class File. But the PHP Pages which are including the Database Class File is opening with gurbage data. The other pages which are not …

Member Avatar
+0 forum 0

Hi, I'm supposed to create a little program that will allow you to select a range of dates and graph prices based on those dates. The data would come from an Access table. I know Excel allows you to pull in data from Access, but I'm not sure how to get started. Any little nudge or tip would be greatly appreciated.

Member Avatar
+0 forum 0

I'm not sure if this is the right place for this, but I'm having an issue I'm trying to solve for a customer, and it's not going well. Searching online I'm seeing this has been a common problem for many people, but there aren't really any solutions that I can find. Here's the problem: If I create a contact template database and try to save a contact as an Outlook contact, everything works fine. BUT... after splitting the tables into FE and BE, cmdSaveAsOutlookContact no longer runs. Trying to call acCmdSaveAsOutlookContact give a 2046 error, but I can't find how …

Member Avatar
+0 forum 0

i can't use vba in access because when i write: Dim db as[space]->error it seem error space . how do i fix it ?i reinstalled it already but it's not working . thank you

Member Avatar
+0 forum 0

hi i have this form, and a subform datasheet.i need to copy selected row/record from the datasheet to the corresponding textboxes. i have used this, but it will copy the whole column title and the record, and i dont know how to separate the string of copied data into textboxes, if anyone get this, can u pls help. thanks a lot. [CODE] ... DoCmd.GoToControl "OpNameClick" '1 of the textbox to check the paste command DoCmd.RunCommand acCmdPaste [/CODE] the copied value: [CODE] ProcessBlock Purpose OpName OpDescription TechName IDProc IDTech IDRemark ProcessNum Step IDOp 1020 LC START LOT SFET3HV80RG 1 9 1 …

Member Avatar
+0 forum 0

Haven't used this stuff in years since working at IBM and Compaq in the early 90s. Different career path. Need to fix a guy's access 2000 software by tomorrow -long story -totally corrupted - needs something from scratch and his pictures of screens. Don't have the time to program and design everything. I've gotten most of the forms done but can;t remember linkages etc. Would like to hear from someone that would like to help me and can chat with ongoing. I've forgotten all the cool places to hang out with on the net but I'm really cute and smart …

Member Avatar
+0 forum 0

Do anybody know where can i find example of database management system all topic especially fast food restaurant(if possible).

Member Avatar
+0 forum 0

> Is it possible to convert older > version of FileMaker Pro > to Microsoft Access 2000 I suspect FileMaker can save its tables as .DBF; Access can use .DBF tables directly or can import them. Alas, I don't think you can convert any part of your application EXCEPT the tables. But, if you become familiar with Access, or hire someone who is, it may be quite simple to re-create the user interface features. ...................... [url=http://www.sbvtravels.co.in/]ooty tour packages[/url] | [url=http://www.sbvtravels.co.in/]rameshwaram tour packages[/url] |

Member Avatar
+0 forum 0

please help me.. I don't know ho to make that. Thanks

Member Avatar
+0 forum 0

I want my Access form to return a result based on data entered in a text box and combo box. I have 4 queries: qryA, qryB, qryC, qry D I want the user to be able to select A, B, C, or D from a combo box and then enter data into the text box that is common in all four queries. In this case let's say that field is Name. How can I accomplish this through a form? The result will show once the command button and two previous values are entered.

Member Avatar
+0 forum 0

Hi, I have ms access as front end software to be used for employees in my company. Every user will have different access to the contents inside based on their role. For example, manager will have different access from the others. First attachment is the image for limiting user access as well as giving specific roles to the user. With this function, every users will have different access, what the table they can see and can't, etc. However, I have some issues that already happen in the past twice, and not it just happens again. When I modify some script …

Member Avatar
+0 forum 0

HI guys, I have finish my project in vb.net and publish it without errors. The problem is this: As my project finished installing in the pc, an error occurred saying that the path where should be my DB Access is not there. Although I manage this problem by manually copy and paste my Access into that path. And bweella, no errors, But im just curious guys, How did this happen? Actually as im on my development part, my DB ACcess is save in the DEBUG folder in my VB.NET Project Folder. Would you guys out there help me figure this …

Member Avatar
+0 forum 0

search data in listview by using a textbox, this is my code sample cos i have been able to display data in access on listview so i want to perform a search function... Imports System.Data Imports System.Data.OleDb Public Class Form9 Dim Passport As String = "" Dim searching As Boolean Dim sSql As String Private Sub Form14_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load With ListView1 .Clear() .View = View.Details .FullRowSelect = True .GridLines = True .Columns.Add("First Name", 200) .Columns.Add("Middle Name", 200) .Columns.Add("Last Name", 200) .Columns.Add("Passport Number", 120) .Columns.Add("Matric Number", 120) .Columns.Add("Semester", 80) .Columns.Add("Year", 50) .Columns.Add("Course", 140) End …

Member Avatar
+0 forum 0

Hi, I have this database based on this logic: There are projects in a company. In each project, different employees different roles. One employee could have different roles in a single project. Also, can work in different projects at the same time. Some projects could be added but role of employees could be specified later on. Employees: Empid,Empcode,Empname (autonumber,text, text) Projects: Projectid,Projectcode,ProjectName (autonumber, text,text) Roles: roleid,rolename (autonumber,text) EmployeesProjects (autoid,empid,projectid,roleid) The database works fine. So far, the company was searching by project code or name. But recently, they want to enter employee name in the same textbox and that would return …

Member Avatar
+0 forum 0

I have inherited an Access 97 database with a VBA front end. I know nothing about VBA front ends, but can work with Access The system is vital to our organisation. At some point I will look at re-writing the full thing in Access 2007 as the VBA does nothing that Access currently does not. But we have time issues We have updated SOME of our machines to Windows 7 (64 bit), Access 2007. When i run the VBA Application, to fires up OK, and most of it works fine. However some of the options are returning an error message …

Member Avatar
+0 forum 0

I'm probably overthinking and been staring at this too long, but I'm having a huge brain fart and need help. I have 3 fields on a form: EMPLOYEE (visible), EMP NUMBER (not visible) (from a seperate table) and EMP NUMBER ENTRY (visible). I want the employee to choose his/her name from a pull down (I got that) and enter their "employee number" in the EMP NUMBER ENTRY field, then have it compare for an exact match in the invisible EMP NUMBER field before they can proceed to another menu. In essence, each employee has their own password (their employee number). …

Member Avatar
+0 forum 0

I have quite a long list on my listbox. And when I wanted to search for words like "Boy", I need to go through all the letters before 'o', for example, 'bacon', 'banned', 'because' and so on. I know that the listbox allow the user to search for the first initial of the word on the list, but can I search for the second letter of the word and so on on the list box as well? If it is possible, please teach me how to.

Member Avatar
+0 forum 0

I'm trying to join two tables and group the results. The tables are joined on an EventID field. The basic query gets all upcoming events for the following month: [CODE]SELECT StartDate, EndDate, StartTime, PresentedBy, EventDescription, AdditionalInfo, VendorEventID, FeaturedText FROM EventCalendar, Events WHERE EventCalendar.EventID = Events.EventID AND StartDate >= NOW() AND StartDate < DateAdd('d', 31, NOW())[/CODE] I want to group the events so that all performances of a particular event will be together, and the events will be ordered by date. The problem I'm having is when an event has dis-contiguous performances and a different event falls in the middle of …

Member Avatar
+0 forum 0

Hello, Here is my dilemma and I hope someone can help me: [ICODE]Table1 [B]First Last Dept[/B] Dan Smith Accounting Joe Doe Admin Mary Boe Accounting[/ICODE] [ICODE]Table2 [B]Contact[/B] 068097110032083109105116104 (for ref. this is Dan Smith) 074111101032068111101 (for ref. this is Joe Doe) 077097114121032066111101 (for ref. this is Mary Boe)[/ICODE] I'm using the following function in my code to convert Table2 data to char [CODE]private static string AsciiToString(string content) { string StrValue = ""; if (content.Length < 3) return ""; while (content.Length > 0) { // convert each ASCII value to the actual character StrValue += System.Convert.ToChar(System.Convert.ToInt32(content.Substring(0, 3))).ToString(); // Remove the converted …

Member Avatar
+0 forum 0

I'm new to Access 2007 need some help in regards how to build expression for the following - Product Price $: * Product Quantity - % (any number). Started with the following expression: Total Cost $: [Product $:] * [Product Quantity:] - [Discount %:]

Member Avatar
+0 forum 0

Hi, I am using MS ACCESS. I want to make Do not click a button more than once. I made a calculation button. And want to be just one click. Thanks alot.

Member Avatar
+0 forum 0

I work in a research lab and I'm building a new filemaker pro advanced 11 database to hold our study data. The variables that this database stores will occasionally be exported into excel documents and merged with exported data sets from another database. Unfortunately, the person who built the first database (the source of the "other" data sets) didn't use attribute/column names that meant anything. Furthermore, many of them are actually mis-named. I want to change the column names in my database so that they follow standard naming conventions but need to be able to export the data with column …

Member Avatar
+0 forum 0

Hi, This is a from that take comment from the user. Everytime a user open this form, currentDate and Time will be generated although the user does not put comment in it. Today's date = 18/10/2010 earlier, when this user open this form, the date is still "18/10/2010" But, in the afternoon, the date suddenly changes to "28/10/2010" I have checked the PC, the date is still at "18/10/2010" And this problem is not the first time. This problem occur sometimes. I only put "=Date()" in the TextBox in order for the date to be generated. Anyone know why does …

Member Avatar
+0 forum 0

I have a query that has two counts in an if statement. I need the query to return all values even if they are null once equated by count. I have tried the NZ function to no effect. Any help would be greatly appreciated. [CODE]SELECT REPRESENTATIVE.Country_id, IIf([CONTESTANT.Team_id] Is Null,COUNT(*),COUNT(*)-1) AS [# of BRONZE] FROM MEDAL, CONTESTANT, REPRESENTATIVE WHERE MEDAL.Cont_id=CONTESTANT.Cont_id And CONTESTANT.Rep_id=REPRESENTATIVE.Rep_id And MEDAL.Medal_color="Bronze" GROUP BY REPRESENTATIVE.Country_id, CONTESTANT.Team_id; [/CODE]

Member Avatar
+0 forum 0

The End.