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!

Register Log in
  • Congratulations Rhinorhino 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: deesheeha
  • Content: Threads
  • Order by date
  1. deesheeha

    Disappearing File

    Im having the weirdest problem!!!!!! I have some code that allows the user to choose a file to import and then it imports the file using TransferText.... but when my code reaches the TransferText line, it ends, it doesnt import the file and the file disappears off the hard drive!!! Anyone got...
  2. deesheeha

    Insert Into query based on Field value

    Hiya! Im have a problem... I have a table called tbl_NoOfDuplicates and it holds a customer name, and a number showing the number of duplicates counted from a previous table... Customer NoOfDuplicates John Smith 10 Linda Kelly 3 What I want to do is add the customer name to another...
  3. deesheeha

    Excel VBA - Record Locking

    Hi, I wrote an Excel Macro in VBA which imports records into a SQL server database & an access database. The import went fine, however the users cannot edit or delete any of the rows imported because of a Write conflict error message. I have asked the users to restart their SQL server and the...
  4. deesheeha

    Runtime error 29068

    Hello all! Hope you can help me out. I have the following line of code: DoCmd.Rename "rpt_RedLetter_Collection_IRL", acReport, "rpt_RedLetter_Collection_Active" Everytime the code hits this report i get the following error: Run-time error '29068' Microsoft Access cannot complete this...
  5. deesheeha

    Attaching a Folder

    Hello! Im currently coding a database and a form i have a textbox called AttachedFolder and a button called btnFolder... Basically, i know you can bring up the browse box using the DoCmd.RunCommand acCmdInsertHyperlink but that inserts a hyperlink.... Im looking to be able to attach a...
  6. deesheeha

    Excel VBA - Selecting a Row

    Hi, Im pretty new to Excel VBA but have a good knowledge of Access VBA. My problem is the following: On every second row i have added a button in the first cell of the row. When i click on it, i want it to equal the row that the button is on. How do i capture not the row of what cell is...
  7. deesheeha

    Printing Filepath

    Hi, I have code thats reading in from a file on my local drive. there are 1000 html pages there and what its doing is its reading them in one by one and then printing them out. I want to add the filepath to the end of each page that it prints so i know what file they are talking about. can...
  8. deesheeha

    MySql Delete

    Hi, I just deleted a record from my SQL table by accident and i was wondering if there is a way of undoing this?? Dee
  9. deesheeha

    Weekly Reports

    Hi, Im looking for some kind of code that will read a table and write out records from the table for the last week... i have it working on a daily basis but i also want it to read all sets from sunday and every sunday start fresh. any ideas would be greatly appreciated. not even code just a step...
  10. deesheeha

    convert time to seconds

    Hi, i have a date variable which captures the time when a button is pressed. does anyone know how i can covert this to seconds?? as when its stored in a table its stored as an integer
  11. deesheeha

    Subforms/ADODB

    Hi Can anyone help me with this code?? I'm having a problem setting my recordset to a subform with my ADODB connection. Heres my code, and my error is on the highlighted line: Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim fld As ADODB.Field Dim sql As String...
  12. deesheeha

    mySQL /VBA

    hi, im reading data from a user, using this data to search a database and then outputting the results to a subform which is in dataview format. the problem im having is im adding 3 additional columns to the dataview and although i can add them, i want the user to be able to edit these columns...
  13. deesheeha

    VBA/mySQL INSERT INTO error

    Can any one help me? Im getting an error in the following line: CurrentDb.Execute ("INSERT INTO callactions(CallActionID, StoreNo, CallID, User, Queries, Action, AssignedTo, Note) VALUES (" & glo.CallActionID & ", '" & glo.GlobalStoreNo & "', '" & glo.GlobalCallID & "', '" & glo.User & "', '"...
  14. deesheeha

    INSERT INTO

    Hi, Can anyone see why im getting the following error: Run-time error '3134' Syntax error in INSERT INTO statement. Heres the statement thats giving me the error: Set rs = CurrentDb.OpenRecordset("INSERT INTO callactions(callactions.Actions) VALUE ('" & ComboAction & "') ; ") I've tried...
  15. deesheeha

    Records in Listboxes

    Im having a problem for the last 2 days which is annoying me! I have a listbox which reads in records from a table. i want the listbox to work that when you double click on a record in the listbox it opens a form specific to the record chosen.

Part and Inventory Search

Back
Top