Search results

I tried the following suggestion off of another post but it deleted everything, even though there was a matching ID in the equipment table. DELETE RMAs FROM RMAs INNER JOIN FacilityEquipment ON RMAs.RMAID<>FacilityEquipment.[RMA ID] This works to delete any records that match, but of course...

Wondering if someone can help me out on a query... I have a RMA form containing a RMA table with a RMAID field, Facility Name, Facility Address and Date. On my Equipment table I have several fields with one of them being a matching RMAID field. What I would like to do is whenever I close the...

I figured it out, earlier I was messing with a timestamp field and decided to not use it, however the existing records were affected by it. I wiped the table and entered new records and everything is working as desired....

I have a FacilityNames table with a FacilityID and Facility Name column, I also have a FacilityEquipment Table with several fields and they are related by the FacilityID. From time to time we need to transfer equipment between facilities so I am just changing the FacilityID for the selected...

Perfect, for some reason I was thinking that would be considered like a mouse over trigger so I didn't even try it. thanks again !!

Is there a way to mimic the OnClick process that occurs with a text box for a ComboBox? I have a hidden field that highlights whenever the record is selected, which works great. The following code is set in the Form_Click event and then the hidden field is conditionally formatted to highlight...

thanks for the responses, it will be a day or 2 before I can test them. This is only 1 record that will have multiple "Completed" check boxes, however I was just testing on one of them. i.e. Orders Complete, Paperwork Complete, Orders Shipped, etc. I am putting this on the form "On Load"...

Wondering if someone can help me out with the following: I am getting the Data Type Conversion Error on the Rs([Equipment Order Due]) part [Equipment Order Due] = "DateTime" type in SQL and formatted to MM/DD/YYYY text box on the Access side [Equipment Order Complete] = "Bit" type in SQL and a...

As I suspected, the constraints specified in the query disappeared after adding a new column, however anything set with a default value in the table setup, i.e. bit field set to not allow nulls and a default value of ((0)) remained. (see attachments) On a side note, I noticed there are still...

I'll test it tomorrow, both before and after and report back!!

From what I gathered after adding a new column to the table or renaming an existing column, or changing the type, it automatically dropped everything as I wouldn't get any defaults when adding a new record, unless I reran the query. Not sure if there's another way of doing it, but I wasn't able...

One thing I noticed with Edge was some of the add-ons / extensions I needed to use, i.e. GoGlobal for GraphOn, kept identifying it as Chrome so therefore wouldn't install correctly. Of course that was after it first came out and I haven't tried it since as I just use Chrome for everything so...

I don't have access to it right now but I just basically repeated the whole Alter Table statement for each column that I wanted to specify a default criteria. I just changed the constraint name to match the column, added DEF ,for default, behind it and then specified the criteria. I have 6...

Disregard, I was trying to use the wrong column in the FOR statement

Is it possible to setup multiple column defaults? EX: Column 1 : Defaults X, Y, Z Column 3 : Defaults 1,2 I tried using 2 different Alter Tables statements in SSMS, which completed successfully, but now I am getting a "String or binary data would be truncated" error when I try to add a new...

Thanks to both sonic8 and theDBguy. Setting it in access didn't work, but running the command in SSMS did the trick. Thanks again !!

currently nvarchar(Max) but I can make it whatever as there is no need for formatting

Whenever I add a new record, I would like the default value for the column to populate with Clients: Server: I'm using Access for the FE and tried to set it on the default value there as well but haven't had any luck so far.

I'm thinking I already know the answer, but Is it possible to set a multi line default value for a column in a SQL table? i.e. Clients: Servers:

Why is that? I made the PDF and send it to our sales people, the fill it out and send it back. Currently I am hand jamming their info into the DB, but with the help of TheDBGuys code to parse out the fillable form, I am planning on using that to import the info from each field, which matches...