Search results

I want to incorperate a button that locks a certain portion of my form but my form is still quite long... Is there a way which I can lock multiple fields at once or do i have to do: Field1.Enabled = False Field2.Enabled = False Field3.Enabled = False Field4.Enabled = False and so on...

i have 3 OPTION buttons that decide the color however... option buttons only have "Got Focus, Lost Focus, Mouse Down, Mouse Up, Key Down, Key Up, Key Press" why dont they have "On Update"... what am I supposed to use to tell when the button has been pressed?

I have set up a group of 3 buttons to select between on my form which works fine. However I want this to be a bit more visual than it is so Id like to introduce a traffic light system which lights up RED ORANGE or GREEN depending on which one has been checked. Im not too sure how I would go...

As an example lets say I have a table listing some cars: im making a form with two combo drop downs with the ability to select car make or model. Car Model is Unique so if the car model is entered, I will force the car Make into the other combo box however, If i select "Mercades" for...

I want to be able to store large amounts of text (possibly) in a memo field but I am not aware what memo field can allow. Id like to be able to enter paragraphs of text with the use of line breaks and also indents (can be done via the "Enter" key for line breaks and either "TAB" or multiple...

yeah, im using data validation... i want to keep the back end of the database well away from the users... so im going to lock that up so they cant tamper with it. Then i would use an unbound form.

Ok, heres a bit of a guilty secret... I've been programming databases for over half a year now but im still not quite sure of something... I need to create a form to input records (or modify records) however im unaware of the methods that could be used to actually put the data into the...

Apologies for not making it clear. I am using this command to enter data: (ive stripped it back a bit so its smaller, i dont need to show all of it anyway) CurrentDb.Execute "INSERT INTO [Initial Request] VALUES ( " + strType + "','" + strRequester2 + "','" + strTime + "')" and the...

Hi, first off, i dont know much about SQL so I wont be able to help that much however... I have a simple command If (IsNull(strRequester.Value) = False) And (strRequester <> "") Then strRequester2 = strRequester.Value Else If InsertFlag <> False Then MsgBox ("Requester details can...

ok i got it to work, here was the issue: the sql command is set to a string so you can execute it later, so everything must be a string (even the checkbox12), then the value that the chkbox12 is needs to be assigned to that string to add it onto the rest of the string the other issue was...

strTime is a variable which is a date, im not 100% sure how its working now but, i got the UPDATE code to work, just not the INSERT to work.. tomorrow I will post the code for UPDATE that I used and also post what the date is from so you can see how that works and yeah im sure its the...

the column Im wanting to fill is a "yes/no" column, not a string (but I could change it to a string i guess...) is it just a case of doing something like... if me.chkbox12.value = -1 Then checkbox12 = "Yes" Else checkbox12 = "No" End If however that is still putting them as...

I think the data type is now unbound... I have managed to get everything to work apart from getting the record into the database... strSQL = "INSERT INTO [Completed] VALUES ( " + strCode + "," + strOperation + ",'" + strCompleteDate + "'," + _ strParts + "," + strSize + ",'" +...

What appeared to be a simple task has turned into a nightmare... In a current form I want to display a checkbox that can be checked or unchecked. Based on if the box is checked or not, a value will be placed in a field when the record gets updated or created... however ive fallen at the...

hmm... ok so ive ran into another issue If I want to incorporate cases with words... am I not going to have to write: If cmbcolor.Value = "Red" Or "Blue" Or "Green" Or "Black" Then number = 1 End If Also is it possible to make Locked fields visibly different from unlocked fields?

ahh thanks for that. The name "numeric" is a text string and not a number, its confusing but it can have letters in it too In fact, I dont only have 2 options "Red"/"blue", i have a lot more... which means im going to have to list them all with Me.cmbcolor before each of them -sigh- at...

I have a macro like so: Private Sub cmb_Numeric_AfterUpdate() If Me.cmbcolor.Value = "Red" Or "Blue" Then Me.cmbnumeric.Value = "12" End If End Sub however this gives me an error and im not sure why... can anyone explain why. or give me a good work around?

That enabled me to get hold of the recordset all i need to do is "click the search button". I tried accapp.Run Command10_Click but that didnt work... Is there any way to activate the macro procedure done by clicking on the search button?

Hi, I have a database dump in excel that gets sorted out via a macro to leave me with the "important records of the week". I would then like the ability to click on a link to the access database which opens the database form, puts in the relevent record ID and then clicks on the "Search button"...

Im totally new to SQL developing but ive been asked to attempt this job XD I am required to extract a specific piece of information from a sql database. Im using Oracle SLQ Developer and I need to look within the "Views" section to find the information. The problem is that there are a lot of...