Search results

so I did IT help desk 101 and restarted the computer and now it works.......sometimes i really hate computers

nope still 'no'.

I have a form I have spent the past week on showing in Design view but when i swap to Layout View or Form View its a blank white sheet. Help!!! I checked all the fields are visible "Yes" The query that is the record set is full of information. I am scrambling don't know what is going on.

Oh nice i didnt know that was a thing I have been doing those long exceptions all this time in regards to the threat adversary. Now back to the problem, I don't think i have explained it properly and with my code above it misrepresented what i want. I have thousands of these CNFs in my...

oh ok, I don't actually know how to write the SQL I just create the query in Access and open the SQL viewer and copy paste that over to the code.

Thank you, yeah I stopped at that point in the code because i didnt know how to go forward. I am soo nw I dont know what you mean when you say QBE I only did the code this way so far is because thats what i was taught. If there is a better way please help me I am starting to get into this...

Thank you for all the comments I will change how my variables are DIMd to not have them on 1 line. I still don't know how to do what they want me to accomplish. In the SQL there is a field "Fulfillment Group" where there are 16 different options that a CNF could be in at a given time. I want...

Dim dbCurr As DAO. Database Dim rsLate as DAO.Recordset Dim lateStr, cidrThreatStr as String Dim tmpCIDRCount, tmpJCRBValid, tmpRASA, tmpRASAHold, tmpCRIB, tmpCRIBHold, tmpDevHold, tmpTandE, tmpTandEHold, tmpReadyforAccept as long response = MsgBox("Have you selected the threat topic and...

I think i figured out a way to make this work but not sure if its possible.... I have a SQL for the query, can i make 5 different variables that equal the timeframes I am looking for and run the SQL + variable1, record data run SQL + variable2 record data, so on and so on inside the same command...

just counts in each. a requirement gets created with a need by date this requirement goes through approval then on to 4 stages of funding 4 stages of development if the need by date has passed at any time through this process it is considered late

Stage On time 0-30 days 31-90 days 91-365 days over a year 1 number of requirements at this time in this stage 2 3 4 5 6 7 8 9 So I want this to be shown, I have over 1000 requirements going...

I can make a table with each stage as a number and run a query to get all my requirments and the dates on them to get if they are late or not then do a dcount total into the table but I dont want to have to have 5 different subreports for each phase of lateness the requirement is.

hmmm I don't think I'm explaining this correctly, I am still in the brainstorming stage to figure out how to accomplish this task. I have a requirement that goes through 10 stages. I am trying to make a report that shows if the requirement is late to pass each stage.

I am trying to make a report that doesn't use 5 different subreports to calculate how late a requirement is. I want to display on time, within 30 days, between 30-90, between 90 and 1 year, and over a year. I know i can make a report with a subreport for each time frame with a different query...

Just a table in access, it is linked to sharepoint...I am going to see if i can change it in sharepoint. I treid changing it on a local unlinked table and it worked I think my error is sharepoint.

I am trying to change a data type from "Short Text" to "Long Text" because i want to put in something that is more than 255 characters. I am getting an error "Operation is not supported for this type of object" I am confused.....

so i have no idea what changed but through my panic i just copied the one that was working from my test DB to the Live DB and now it works......That is exactly what i did when i created the query in the first place....

Can someone help me find the error in this: SELECT Cnf.[Customer Organization], Cnf.[CNF ID#], Cnf.Title, Cnf.Status FROM Cnf WHERE ((Cnf.Status) Like "*SAVED*" Or (Cnf.Status) Like "*With*" Or (Cnf.Status) Like "*Submitted*" Or (Cnf.Status) like "*QA/QC*");

I want to choose this style of table and change the font color of the header to white. The table style is called "Grid Table 4 - Accent 1" I just don't know were to input it into my code so the tables show up like this.

Ok so now i want to make the table look like our standard table in Outlook. I have no idea how to actually code that but i know it has to go into the following line: aBody(1Cnt) = "<HTML><body><table border='1';'border-collapse:collapse'><thread><tr style='font-family:Calibri'><th>" _ &...