Search results

I get a very strange error when trying to create a find duplicates query. When i try to select a table that has duplicate values it brings up a message box and it says that i must pick a table that has at least one field that's not a memo or OLE data type. I look at my table and I have niether...

I have a name field in this format: smith, john Is there a way to split this into 2 separate fields in a query? I looked up the split function, but it's saying that this function doesn't exist. I also thought this might work, but it doesn't. SELECT left(name,instr(name,",")-1) as LastName...

i'm just wondering if anyone knows of a way to re-format an excel file. i have a file with a bunch of data on it with different columns. then i have a certain layout that this excel file must be in before i can use it. let's say i have original file as follows: column a - age column b - name...

i have a form with 2 tabs and a sub form on each of those tabs. form1, subformA, subformB on tab control - tabctrl - pageA, pageB. how can i set focus from one tab to another without actually clicking the tab? i tried this: TabCtl.Pages("page2").SetFocus it's comming up with an error - "object...

I have 3 tables: tblFunctionalArea FAID, FAName, Active(y/n) tblSubFunctionalArea SubFAID, SubFAname, Active(y/n) tblLinkFAwithSubFA FAID, SubFAID What I need is all possible Functional Areas listed on a form where you can click on active checkbox to activate that Functional Area. Then on...

I can't figure out how to sort a field in Ascending order. this is what i have: <asp:TemplateField> <HeaderTemplate> <b><u>Live Date</u></b> </HeaderTemplate> <ItemTemplate>...

I had 2 tables in regular MS Access originally. Eventually everything got moved to a SQL server and both of the tables now reside on the sql server. I had a pretty tricky DCount() statement on one of my forms for a click button event: If DCount("ProjectStaffID", "qryAvailableDatesCheck"...

I have a report and I want to put a field on that report that a user enters into a prompt. Is there a way to do that at all? I want to prompt a user to enter a field and then put the value of the entered field into a report. Thanks.

I have a database where people are entering data into in constantly. Now I was told that someone else needs to go into the database and check integrity of data entered. There are a few buttons that I don’t want a “data verifiers” to click on, but “data entry folks” should be able to. Is there...

I can't seem to figure out how to close current form. I have form1 and I open form 2 from form1. I can't figure out how to close form1 when form2 opens. Any help would be greatly appreciated.

I recently moved my Access tables to a SQL server. I have been at this for a while now and can't seem to figure it out. On one of my forms I have a pretty large If statement that deals with DCount: If DCount("ProjectStaffID", "qryAvailableDatesCheck", "(((Forms!frmProjectStaff!Start1 < Start1 Or...

Is there a way to dynamically allocate a certain range of days if I know a start day? I have a form where I have a date called startofproject and I want to allocate all work week days from that start date + 90 days. I’m assuming it should be some sort of make table query that will delete all...

I'm having a problem with printing my report on a color printer in color. It still comes out in Black and White. I checked all the settings and I couldn't find anything that says print in black and white only. Any ideas how I can fix it? Thanks.

I have 2 cascading combo boxes on Form1. After I select one things out of dropdown0 and then select another thing out of dropdown2, I click on a button that opens another form - Form2- depending on values selected from both of those comobo boxes. That works good. What happens is when I come back...

I have a form with some Note fields on it. I needed to track changes every time any of the note fields changed. I got that part to work and I put it in the Before_Update even as I'm using Note1.Oldvalue as well as Note1.Value for my changes. The problem that I'm having with this code is that...

I have a DLookup() function on one of my reports: =DLookUp("[TaskStartDt]","tblDatesInfrastructureAndTools","[TaskID] = 52 And [ProjectID]=[Project_ID]") I created a new text field and placed this function in it – this works very well. After that I realized that I want to sort on that...

I have a DLookup Statement for one of my fields: =DLookUp("[TaskStartDt]","tblDatesonlyPM","[TaskID] = 16") in this tblDateonlyPM there is also a FK to my Project table - ProjectID. What I want is to be able to add to this DLookup statement something that will make sure that ProjectID from...

Hello. I'm building a history table to keep track of some changes that occur on one of my forms. Here is what I'm using to build my history table: Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tblDateCycleTestingChanges", dbOpenDynaset) With rs .AddNew ![CycleTestingDatesID] =...

I’m wondering if there is a way to incorporate Microsoft Project and Microsoft Access together. I have a database for projects and I also have a project plan created in MS Project. Rather than having to type in Start/End date for each and every task into my database (which will be a lot of...

Is there a way to code something that will say do Undo All changes. I have a button called Exit without changes…and I would like to be able to undo everything that a user has just done on the form. Thanks.