Search results

Not sure where to ask this question so ill put it here in general. Im trying to get windows server 2012 task scheduler to open my access database. When the task runs all that I see happen is the locking file will appear on my desktop and I have to go to the task manager and kill it to make it...

Yea I do the same thing. I have a copy of the frontend and backend on my computer where I do all my testing and developing. But when I want the changes to go live on the live backend I have to ask for everyone to get out, make the changes, and then tell everyone to get back in. I cant copy my...

I have a split database with the backend on our server here at work that has several users in it all day. Since I'm still developing it while others are using it I have to announce to everyone to get out of the database to go in and add a field to a table or make any changes to the table. Was...

Another thing. If I copy a field that is bringing up the combo box and paste it and change the name. It's still bringing it up as a text box on a form. edit - It also seems to be working on all my other tables except this one... edit again - Little more info. My backend table is displaying...

Im using access 2010. It may not be in 2007, never used it so idk. And I know I can just grab a new one and bind it to my field im saying it's never done this before and the table design view and design view on the form are telling me two different things.

In the table in design view if you click on the field at the bottom there are two tabs on the lookup tab it says its a checkbox or combobox. And by drag I mean when you have a form in design view and you drag a field over from the add existing field list.

Today and yesterday I added new fields to a table and they are showing wrong when everything is right. I added yes/no fields and a combo box look up and when I drag them over to my forms they are just showing as textboxes and not a checkbox or combo box. When I look at the backend and look at...

Right on the money. Thanks

I have a query now that pulls records between 2 dates the user inputs on a form. The records have a Branch field, and a dollar amount field. I need a query to count how many of each branch shows up and sum the dollar amount for that branch. For example branch A shows up 5 times with a sum amount...

That was it! It works great now.

Well you put me on the right track I think but I still cant seem to get it to work. I put Set rst = CurrentDb.OpenRecordset("SELECT * FROM table WHERE DateField BETWEEN " & Me.txtStartDate & " AND " & Me.txtEndDate & "") And It runs and I get no error but when I got to my excel sheet...

Im trying to export a query to specific columns in excel and im using this code. Dim objXL As Object Dim xlWB As Object Dim xlWS As Object Dim rst As DAO.Recordset Set objXL = CreateObject("Excel.Application") Set xlWB = objXL.Workbooks.Open("filePath") Set xlWS = xlWB.Worksheets("Sheet1")...

I have a username combobox and a number combobox filtering a subform. If there is a userName but no number I want to pull all the records for that userName regardless of number and vice versa with a number and no userName. And if they both have something then both are being used for the filter...

I'm not sure i get what you mean. The 3 date fields are used many times in the database so I do need them. All i need is for the status of the record to change based on if there is a date in the field or not and certain dates over ride other dates.

I need a field to update based on other fields. Dont think they want me to give specifics on what im working on but, I have 3 date fields. Date1, date2, and date3. I have a status field that need to change based on if a date is entered. For example. If there is a date in Date1 field, the...