rudeman76
Last Activity: Oct 15 '08, 09:01 AM
Joined: Oct 2 '07
Location:
-
awesome, works perfect now. Thank you very much -
sorry,
the txttime is my dtpicker. i didnt explain thatLeave a comment:
-
i set it at form load.
the min and max lines i added to see if that was my issue. It still didnt work.Code:txtTime.MinDate = "00:00" txtTime.MaxDate = "23:59" txtTime.Value = Format(Time, "Short Time")
Is this wrong, the way i did it?Leave a comment:
-
dtpicker problem with dtptime
Hi,
I have a form that is a daily log. I use dtpicker for the user to enter in the time. At form load, I set the time as the current time. The problem i am having is when the user changes the time and goes to the next step, it does not take the new time, it uses the current time. For example, if it is 12:30pm and the user enters in 12:15pm, it uses 12:30 as the time. i am using dtpicker.value to get the info. I am new to using... -
hi all,
I figured it out. I had: Jet OLEDB: Database Password = sgsd
it should have been: Jet OLEDB:Database Password = sgsd
no space after OLEDB:
Amazing how much headache a space in a wrong spot can cause
AndrewLeave a comment:
-
I have tried different aproaches to this. It seems as soon as I add a password to the DB it dont work. Can anyone help me pleaseLeave a comment:
-
could not find installabe Isam
Hi,
I have a datagrid with the datasource linked to an ADODC. I had the Adodc set up through the properties when I first set it up (I do not know why I did this). I now have changed it to set programically. Now i am getting a "could not find installable Isam" error. I went to connectionstrin gs.com and as far as I can see, i am doing it correctly.
...Code:adoEvents.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
-
i forgot to add, i am using vb6Leave a comment:
-
embedded object
hey,
I have been trying to find a way to embed an object (either Word document or Excel spreadsheet) into a form. I got it embedded fine. What I wanna do now is have it so when the user double clicks the document, word or excel will open wit the document. Then when they close it, it will save as a specified name that the program has given it. Then when the form with the embedded document is opened again, it is blank again. I hope... -
I have been using Masked edit control. I can still enter in invalid times. I not sure how to get it so you can only enter in valid times.
AndrewLeave a comment:
-
input mask in text box
Hi,
I have been trying to find the answer to this for a couple days now. What I have is a textbox (txtTime) that the user will enter a time into. What I want is that the user can only enter in the time. I have tried to use a mask edit textbox and set the mask to ##:##, format to hh:mm, PromptChar to 0. I can still enter in numbes that arent time. eg. 30:76. I cannot find anything in textbox properties to help. I want the user... -
query with 2 linked databases
Hello,
I have 2 linked databases. I have one that is emptied into the other at the end of the week. Is there a way I can set up a query that will search both databases and give me the info on a single recordset? for example, In one of my tables I have the user enter in a bag number and tag number. What I want to do is be able to set up a query and have it search both linked tables for the tag number and return it into a single form or... -
thanks, that worked awesome.
I am now getting an error when I use the removeitem. It tells me the name selected is not in the list.
...Code:If IsNull(Combo25.Value) Then Rst.MoveFirst Do While Not Rst.EOF If Rst!position = "Security" Then str = Rst!employee x1 = Left$([str], InStr([str], ",") - 1) & " "Leave a comment:
-
Hi,
I have been playing around with this. I have the Combo-boxes bein populated from a table using the AddItem. I put this in the gotfocus of each combo box. Once it populates the combo-box, I use the removeItem to remove the other combo-boxes. It is working ok. Problem now is when I created the table, I had the employees entered in as "Lastname, Firstname". The comma in the middle is putting the firstname on the next line....Leave a comment:
-
removing from combo box
hello,
I have 6 combo-boxes on a form. They are all populated by the same query. They are for the user to select the 6 employees that are on shift. Is there a way to remove the employee from the rest of the combo boxes once their name has been selected? I just want to make sure the user does not enter the same employee twice.
Andrew -
hi,
Is there a way to put the image onto a Word document or Excel spreadsheet?
AndrewLeave a comment:
-
The first part about the spellchecker worked awesome. Thanks
As for the Blob, I found it kind of hard to understand. Might be just me (and it being 2 AM).
AndrewLeave a comment:
-
working with word and pictures
Hello,
I am working on an incident form. I have 4 set text boxes and up to 4 drop-down boxes on the form. The user enters in the date then time. I have 4 option buttons for the user to select the number of security involved. When the user selects the number of security, the corrisponding drop-down boxes appear (eg. if they select 3 security, 3 drop-down boxes appear). The drop-down boxes have a list of names (populated by a query). ... -
I feel real stupid right now,
I was missing one line.
[code]
DoCmd.RunSQL strAppend1
[/code}
this should have been right after the first line.
thanks for all your help though, I really appreciate it,
AndrewLeave a comment:
-
hey,
I may not have been clear. My delete statement works fine, its the Insert part I am not sure about. I am trying to use insert to take the data from my "concentrat e cans" table and put it into "concentrat e cans1" table. The code works fine for 6 other tables, but for some reason it does not work with this one. It is supposed to take the info from the first table and put it into the second. I have this set...Leave a comment:
No activity results to display
Leave a comment: