Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dulla
  • Content: Threads
  • Order by date
  1. dulla

    Jtwt Script Modification

    The following code pulls recent tweets from twitter and feeds them to your website. I'm trying to figure out a way to change the date of the recent tweet from 1 week (default) to 1 month. Any ideas? (function($){ $.fn.jtwt = function(options) { //Declare defaults var defaults = {...
  2. dulla

    Sql wont run in VBA

    Hello i cannot get this statement to execute in vba: Private Sub Operation_AfterUpdate() DoCmd.RunSQL ("SELECT Last(UnitRate.UnitRate) AS LastOfUnitRate FROM UnitRate RIGHT JOIN EmpTicket ON UnitRate.Operation = EmpTicket.Operation;") End Sub i get the error: a run sql action requires an...
  3. dulla

    Concatenate Values

    Hello. I am trying to assign many values to one of my fields, TicketScan. Some values will be from a main form (Roll) and some on the subform (Bundle)that the TicketScan field is in itself. These are the values i would like to concatenate: Form_Roll Objects: RollID TotalUnits MarkerType...
  4. dulla

    Creating New Records in Subform

    Hello. I am trying to create multiple records in a subform when a button in the main form is pressed. Is this possible?
  5. dulla

    Sending Info to Server

    I am trying to sending a file to my server. I have obtained a script that i cannot get to work. the html is here: http://www.marshonsfashions.com/file_upload I have set the permissions and changed the variables, yet i still get 'server error premature end of script headers' as an error. any...
  6. dulla

    File Upload

    Hello. I am trying send information with a file upload on a form straight into an email account. The fields get sent however the file upload wont get sent. Is there anyway to send information to an email account with the file upload to show up as an attachment? here is my html form. I have not...
  7. dulla

    Using MultiSelect Listbox

    Hello. I am having trouble using a multiselect textbox. Initially, i was using a regular combo box to capture information for clients. In the combobox, only 1 value could be selected from the list. I currently have 40 clients that have only one value recorded for the 'business type' field. Now...
  8. dulla

    Choosing more than one list value

    is there any way to choose more than one value in a combo box that would be recorded in 1 field? as in holding down the ctl key and choosing more than one option? or would i just have to create different fields for this? thanks. ameen
  9. dulla

    Opening on Last record

    hello. i am try to set the default to open on the last record of the subform that i have. when i try the following: Private Sub Form_Current() DoCmd.GoToRecord , , acLast End Sub it works, but the record is locked, i cant add new record or navigate. when i try this command (DoCmd.GoToRecord ...
  10. dulla

    Query based on last date

    how do i run a query to pull up the records that are affiliated with the last date of entry. i have a field called 'process date' to capture date, but i need to bring up the records that are the latest so i can display their current status. i don't want to do it by lastrecord because some...
  11. dulla

    Capturing a value from another form

    Hello. I am trying to update the value on my Client Stages (main form). The value should be equal to the Name field on my Service Provider (subform). Once the name value is recorded in the subform i would like this value to appear in the SP Name field in my main form. How would i do this...
  12. dulla

    Disable Mouse Scrolling wont work!

    i have looked at the link and it works great for the sample db. but i can't get it to work in my db. i keep getting the message: "The expression On Load you entered as the event property setting produced the following error: User-defined type not defined *the expression may not...
  13. dulla

    Disable scrolling function

    i am trying to disable scrolling functions caused by the mouse. each time i use the middle scrolling button on the mouse it scrolls through all the records each time it is rolled upward or downward. how do i disable this function? thanks. ameen
  14. dulla

    setfocus on another form

    hello. i am trying to set focus on a field in another form after click an option. i have this code: Private Sub Submit_Grant_AfterUpdate() If Submit_Grant.Value = "-1" Then Form_Grants.Grant_Name.SetFocus End If End Sub and nothing happens. i've also tried: Private Sub...
  15. dulla

    Adding days to a date

    hello. i need to add 30 days to a given date and display it in another textbox. so when a user enters the date in a textbox, i need that date + 30 days in mm dd yyyy format to display in another textbox. thanks. ameen
  16. dulla

    Weekly Alert

    How do i get a weekly alert to display with a reminder in it? thanks. ameen
  17. dulla

    Capture the year of a date

    hello i am trying to base the value of a field on date which is entered by the user. so if 'date_received' is entered as 1/23/03, i would like the value of the field 'past1' to equal 2001, 'past2' to 2002, etc. is there a way to separate out the year to execute this calculation? thanks. ameen
  18. dulla

    Setting Default Value to Previous Record Value

    hello. i am trying to set the default value of a field (client score) to the value of this field in the previous record. how do i do this? the table that this field is a part of is called Counseling Session and it is on the many side of a one to many relationship with a table called Clients...
  19. dulla

    Lname, Fname fields VS. Full Name field.

    i need to import lots of data into access from text delimited files. Many of the source dbs that i am importing from have one 'contact' field for the name, which combines first, last, and middle. in my access db i have 3 separate fields for this because if i need to look up alphabetically i can...
  20. dulla

    Display Data in Report

    Hello. I am trying to display data from 3 queries in a report which shows quarterly data. i am having trouble displaying the query that pulls the quarterly data per year. i would like it to be as: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Totals in five columns and have the data be...

Part and Inventory Search

Back
Top