Search results

  1. Y

    mysql Export To Excel with Images

    i have a column called "image url" in mysql which has the absolute url for the image. If i were to export this to excel, is it possible for the images to show in excel if the absolute url is included? How can i achieve this. Thanks
  2. Y

    MySQL Group by except nulls or blanks?

    SELECT * FROM `coupons_coupons` group by `group` I need blanks or nulls NOT to be distinct from column `group` is there anyway to make an exception like SELECT * FROM `coupons_coupons` group by `group` except "" or NULL Thanks!
  3. Y

    Auto Populating a form FROM a table

    I have a table with Employee Name's lets say ID | Name I also have a table that also has a form to show if the employee has checked in or not. ID | Name Reference | checked in Everyday I go into that form and plug in every employee's name manually and check if they have checked in or not. Is...
  4. Y

    Adding Totals for Year Sold on Item Number

    I need Year Sold Totals for the Item Number for example, 42AG, 42AP, 42BO, 42MG = 126 4204AC, 4204AG, 4204AP, 4204BO, 4204LAG, 4204LAS, 4204MG, 4204MS, 4204RAW = 475 I'm not sure how crystal reports would group them together and add them up depending just on the item number range. Thanks for...
  5. Y

    filter over filter?

    lets say i filtered someone's last name manually. and i use vba to filter the date of birth the filter for the last name will break and shows everyone's date of birth is there anyway vba knows how to "continue on with the filter" instead of toogleing it? Thanks
  6. Y

    searching from ranges start date and end date

    start = "#" & textbox1 & "#" end = "#" & textbox2 & "#" docmd.applyfilter , "me.date>=" & [start] docmd.applyfilter , "me.date<=" & [end] when user clicks on button, this code is applied. Is there anyway to make this easier or more simplified?
  7. Y

    checklist report

    I need my report to display all the test results of the patient including ones that are not done. http://img651.imageshack.us/f/checklist.jpg/ patient birben has just a sonogram test. but has not done any other test. (HSV 1/2 IGM, ETC, ETC) I need the report to be generated like this TEST...
  8. Y

    Loop not working

    Private Sub Text8_AfterUpdate() Dim rst As DAO.Recordset Set rst = Me.RecordsetClone rst.MoveFirst Do While Not (rst.BOF Or rst.EOF) rst.Edit rst![Run] = IIf(Me.checkbox = True, "1", "2") rst.Update rst.MoveNext Loop Me.Requery Set rst = Nothing End Sub...
  9. Y

    Totals from Subforms According to Yes/No Boxes

    Been scratching my head with this one... How can I get the Total from the SubForm According to the Yes/No Boxes http://img28.imageshack.us/i/sformi.jpg The Totals for ID's 1, 2, 3 would be ID 1 = $2.00 ID 2 = $4.00 + $5.00 ID 3 = $5 TOTAL would be $16.00 Thanks! Danielle ________ DODGE...
  10. Y

    what's wrong with my code? Me.frmLastUpdated.Form.Recordset.AddNew

    Private Sub Form_AfterUpdate() Me.frmLastUpdated.Form.Recordset.AddNew "Comp_Name", "Daniel" End Sub Im inserting new data to a subform named frmLastUpdated which gives me lastest name that was changed to the form ________ Volcano Vaporizer Review
  11. Y

    filter current date?

    sorry really bad at vba thanks Private Sub Command8_Click() Dim mystr As String mystr = "curDate=Date()" DoCmd.OpenForm "frmEncounterPage" DoCmd.ApplyFilter "mystr" End Sub ________ Honda Nr500
  12. Y

    referencing id from original form and pasting to the other form

    very basic question... what am i doing wrong Private Sub Command40_Click() DoCmd.OpenForm "frmRimFindInformation" DoCmd.GoToRecord acDataForm, "frmRimFindInformation", acNewRec frmRimFindInformation.ID = me.id End Sub thanks =) ________ 330
  13. Y

    Drop Down Menu Auto Load on form?

    Right when I type something, I want the dropdown menu to appear instead of clicking on the arrow This is because I have 2 fields in the dropdown menu (Last Name, First Name) I can only see the Last Name Auto Completed. I have to have to click on the arrow thing to see the First Name. ________...
  14. Y

    changed autonumber to number...

    how can i change the number data type as autonumber? ________ Regi-Stick
  15. Y

    Recording what was deleted?

    Is this possible to record what was deleted? or your last action? Thanks ________ Free porno
  16. Y

    autocomplete in unbound combobox

    im trying to implement this to my unbound combobox http://www.tek-tips.com/faqs.cfm?fid=6295 My unbound record source is this SELECT tblTirecodes.ID, tblTirecodes.CODE FROM tblTirecodes ORDER BY tblTirecodes.CODE; how to i change the strSQL string in that format? Or how do i make it work...
  17. Y

    Converting numbers back to text?

    http://img404.imageshack.us/i/relationship1.jpg/ http://img687.imageshack.us/i/relationshipu.jpg/ I want vendor info to pull the text instead of the numbers is that possible? ________ The Girls Next Door Dicussion
  18. Y

    Unbound combobox filtering or searching

    I have 3 tables tblcodes - has the list of employee codes tblemployees - uses the list of codes they have a one to many relationship how can i use an unbound combobox using tblcodes to search for employees.code in a form it seems to grabbing the tblcodes.id instead of tblcodes.codes from the...
  19. Y

    Normalization for checkboxes?

    I have 30 fields checkboxes Is it possible to normalize the data to a single combobox but display it in the form as checkboxes Note: the backend is mysql I guess that's why I have number as data type ________ Vapir No2 Vaporizer
  20. Y

    How can my memo/text box expand so i can read the whole thing? access 2007

    Thanks You~ Edit: In a form where I'm reading the result not when I'm printing ________ Subaru Impreza Wrx Sti Specifications
Back
Top Bottom