Search results

I used a query on the SQL server to set some constraints, one of which is below ALTER TABLE dbo.FacilityInformation ADD CONSTRAINT RemoteConnection DEFAULT 'Server: ' + char(13) + char(10) + 'Clients: ' FOR [Remote Connection] ; Which gave me a layout of...

DELETE FROM dbo_db_AddNewTicket WHERE TicketID IN (SELECT TicketID FROM Temp); worked like a charm, and I was using both columns in another query that I copied to make the delete query, but you are correct in stating that TechnicanID is not needed

When trying to run the following delete query (Screen shot attached), I am getting "Specify the table containing the records you want to delete" It is due to the Criteria entries and I don't know how to fix it. Please advise thank you

if I do this, it orders correctly, however I'm not able to add any new records as its a query result. I did get it to work how I wanted, I just added a hidden TitleID field to the table and set that for the OrderBy.

This I know, If I enter [ContactTitle] in the OrderBy property, it sorts them alphabetically. Would I would like it to sort by is the TitleID of the associated title so instead of sorting the table as Capt Capt Dep Lt Lt Sgt it would sort it based on their ID from the titles table and would...

I'm not trying to sort the dropdown menu, i'm trying to sort the table by the selected value of the dropdown menu, see attached sample. I would like to sort the table based on the TitleID of the Title Dropdown

This particular table is the contacts table [Title] [Name] [WorkPhone] [CellPhone] [Email] and what I was hoping to accomplish was give the user the ability to insert a new row in the middle of existing rows to keep everyone with the same title grouped together. No biggie, i'll just order them...

See Attached

Revisiting this thread as I am running into another issue. What I would like to do is give the user the ability to insert a row with the right click menu, which I added that command, however whenever I right click and select it, I get the following error message The command or action "Insert...

That does work, however it also affects the layout of the database while in use, is there anyway to have it act like that only while in design mode so I could have each open in its own window, but if I change it to Form View, its the normal tabs/pop-ups as specified by the forms??

Is it possible to view a form, query, report, etc. in a separate window vs a tab while working on it? The reason i'm asking is I would like to be able to see the columns of one table while building my query in a separate window.

You can try something along the lines of Dim rst As DAO.Recordset Open "PATH OF TEXT FILE" For Output As #1 Set rst = CurrentDb.OpenRecordset("Select [DATA FIELD] from [TABLE] Where [CHECK BOX] = True", dbOpenSnapshot) Do While Not rst.EOF Print #1, rst![DATA FIELD] rst.MoveNext...

That's good to know, so what is the magic number of characters before its not longer group-able?

Please see attached, apparently its an issue with the nvarchar(Max) type as nvarchar(50) types show

SELECT * FROM EquipmentOrders WHERE EquipmentOrders.[Awaiting Payment]=1

Hello all, I have a select query to return all data based on a checkbox, which works great. The fields being returned are as follows: OrderID, Facility, Description, OrderDate, PurchNum, InvoiceDate, InvoiceNum I am trying to make a report to group on the Facility, however whenever I run the...

Thanks to both of you for the response, not sure why I didn't think about bumping then end string by a day. Changed the end string search to <DateAdd("d",1,[Forms]![TransferHistoryReports]![EndDate]) and it works perfect, thanks again. Just checking to make sure, but is it safe to assume the...

I figured something as such happened, no problem...

I have a table that is storing the date and time that a transaction occurs in the following format "10/20/2019 5:57:11 PM" I am trying to do a "Start" and "End" range search with >=[forms]![TransferHistoryReports]![StartDate] for the start string And...

After looking at this a little closer, I guess I was looking more for pre-populated field sources from the underlying form vs a different source object. I was able to make it work using unbound text boxes and the OpenArgs based on where it is opened from. I also have 2 other bound input fields...