Search results for query: *

In my database I have a birthdate field, type decimal. Example of a record would be 19721003, i.e. 10/03/1972. I am using the following syntax where $whatMonth = '10'. Ulitmately, I want to pull out all the records with a birthday in a specific month, then order them by day: SELECT lastname...

I have a list of employees with birthdate as one of the fields. This field comes from the database as a string, i.e. 19721003 for 10/03/1972. The initial query pulls all employees. I then have the code working to pull just employees for a specific month. I do this by pulling out the month...

I've got two databases, same schema structure, basically company A and company B. I can get the data I want from each individually but need to combine the results of identical queries then echo it out on the page, i.e an employee directory that list employees from both companies but all in one...

MSAccess 2003 I have a form with two listboxes. The user moves items from listbox1 to listbox2(target). I want to move all the items from the target listbox into a variable and use that variable as criteria in a select query. The variable would need to have OR between the values due to the...

Crystal Verson 8.5 Developer I have a main report that has a single grouping, Revenue Center. In this group's footer, I total/display charges. I have a subreport that also has the same layout except is pulls payments and totals/displays in the subreport's group footer. The two reports are...

PHP - 4.3.1 Apache - 1.3.33 Server OS - W2003 Clients - W2000 and XP We have a Trouble Ticket application that our users submit tickets with. It sends an email to IT so we can resolve. I have modified the email to include the machine's IP address that the ticket was submitted from. However...

I am attempting to get a specific record from a table using DAO. Copy that record into a new dataset, modify that dataset and put back into the table as a new updated record. I am receiving a DataType Mismatch error when I try running through the For Loop when assigning the values to what will...

I am wanting to use DAO.RecordSet to pull a specific record. This I am able to do; slice and dice through the data for that record retrieved. What I want to do is modify a few elements(fields) in the recordset and insert the modified recordset back into the same table as a new record. I am...

I have a converted Access application where I converted the backend to MySQL and kept the frontend(Forms/Queries/etc) in Access. One of my forms has a create duplicate button which in the Access Only version, it created a duplicate record and then refreshed the form with the duplicate record...

I have my crosstab working perfect. It contains drugs for row headings, visit dates for column headings, and comments about the drug on the date in the grid. I want to display that on an exist form. The problem I am running into is no matter what object I try to use, subform, listbox, combo...

I have frmMain with txtPatientNumber. When I click a button, a new form opens to enter drug history. It contains a bound field, txtPatientNumber, as well as other bound fields that the user would enter data. I want it to automatically populate with the current patient number from frmMain to...

I am dump the database nightly for backup purposes using mysqldump. It generates the file which contains the statements to build several tables and the insert statements to populate. However, there are two Create table statements that have invalid syntax. How can this be if MySQL is the one...

I am using MSAccess 2000 to run against MySQL 4.0.12. What I need to have happen is when a user pulls up a record and begins updating it, another user on another workstation cannot access that same record. Where do I begin with this? Is it a simple setting in the .ini file or using...

I have a mileage report that a supervisor signs off on an employee's records for the month. If the same supervisor signs off on say, 10 records, I want to Hide Duplicates. Okay, no problem, set flag to YES. It prints the supervisor's name on the first record and hides it on the rest...

I have a checkbox 'roundtrip' that when the page is first loaded, it is enabled. I have a dropdown, 'to_site', that populates with several locations including 'HOME' and 'OTHER'. What I want to happen is that when a user selects either 'HOME' or 'OTHER' from the dropdown, the checkbox is...

Not sure if this should be posted here or in the MySQL forum but I'll try here first to see if anyone has had the same situation. I have converted a MSAccess(2000) database to MySQL. I am using MSAccess forms/queries/reports/modules and linking to the MySQL database via MySQL ODBC (v3.51)...

I thought I had a good grasp of sessions until... I have several scripts where I initialize a session and pass user_id, password along to different pages. My problem is that if the user never closes out the browser and a different user logs into the site, it pulls up the previous user's...

I have a first name and middle initial. Both put into seperate variables. I know the length of each string. I have to concatenate them together into a string that is limited to 16 characters with the middle initial being in the last position (16 character). Example: strfirst = "Apollo"...

In cell "A1", I have "AAA". I want to populate down column "A" incrementing the original value as follows: A1 = AAA A2 = AAB A3 = AAC Once it reaches "AAZ" the next cell should be "ABA" as follows: A27 = ABA A28 = ABB A29 = ABC And so on... Ultimately, I am looking for an alpha 3-character...

I have the following snippet of code which shows a little calendar icon and a textbox on the form. <td width="26" height="24" valign="top"><a href="javascript:show_calendar('form1.datebox');" onMouseOver="window.status='Select a date...';return true;" onMouseOut="window.status='';return...