Search results

I'm looking for a function in Access 2007 that will allow me to run a query that for a date field will only return the dd/mm/yyyy, and strip the time that is at the end of the line. I've done some searches, but all I've been able to come up with is Trunc(), which apparently is only an Oracle...

I have what should have been a relatively easy Count() query that I just can't get to return the correct information. Here's what I have: SELECT ci_lookup_status.CL_STATUS, Count(ci_lookup_status.CL_STATUS) AS CountOfCL_STATUS FROM ci_issue_status INNER JOIN ci_lookup_status ON...

I have a field called status, and on the "After Update" Event procedure, if the status = closed or iATO a separate form pops up asking for what date the system will expire. The pop up works great, but when you go to close the main form, you get a message "The record has been modified by...

Is there anyway to force anyone in an access database out? We have a locked access 2007 DB that I have visually confirmed no one is in, but the lock remains. Is there any way to clear it? Thanks

I have a button called btnVendor that I want on click to open the form [Vendor Details] where the vendor is = value of the current record. So, I attempted this: Private Sub btnVendor_Click() DoCmd.OpenForm [Vendor Details], , , "Issues.Vendor = Vendor.ID" End Sub Currently when I click...

I'd like to know if it is possible to setup a bar chart with conditions? What we want is if the field with_group: = group1, have the bar go out to a certain point on the x axis. = group2, have the bar go further out on the x axis = group3, have the bar go even further out (and so on and...

I'm trying to run a simple query in Access 2007 to show the difference between two dates, but only have it calculate weekdays (I don't care about holidays). I throught doing "w" would only show weekdays, but it is calcuating weeks. SELECT tblWithGroup.[ID], tblWithGroup.[Issues_ID]...

I am trying to update a date/time field in a subform, and when I get to the line in the code telling it to set end_date = Now(), I get Run Time Error 2448: You can't assign a value to this object. If Me!group_ID = Null Then Me!group_ID = Null Else If Me!group_ID = Forms![Issue...

Not sure if I am posting this in the right place... I have a form frmDateRange that has 2 text boxes, startdate and enddate that have afterupdate events attached to them. The only thing that happens is startdate and enddate are put into variables. What I would like to do is pass those...

I am relatively new to databases, and brand new to programming in general. My background is mostly in hardware, networking, and security but I am looking to expand into VBA and databases. Can anyone recommend a good book that will help me get started understanding not only how to program in...

I'm trying to debug some code, and see what is getting returned from a dlookup search, so I tried to put a MsgBox in that would display the dlookup result. Dim groupID As Variant groupID = (DLookup("ID", "tblWithGroup", "issues.group_ID = " & [ID])) MsgBox("check me",vbOKOnly, "Check...

I'd like to know if it is possible to add a new record, and then take the ID (PK) of the new record, and have it stored as a variable for use in a different area. So, if I do: Private Sub form_AfterUpdate() Set rs = CurrentDb.OpenRecordset("tblWithGroup") .AddNew !Issue_ID = me.ID...

I have a form in Access 2007 with an "On Got Focus" procedure that is supposed to store the current value for a field. Private Sub with_group_GotFocus() Stop Dim OldGroup As String OldGroup = Me.with_group End Sub Then, the after update procedure is supposed to take that old field value...

How would I set a variable to a field that is in a table not controlled by the current form? The form I'm trying update is controlled by the Issues table, and I need to grab tblWithGroup.ID as string GID Problem is, the Issues table also has a field called ID...so when I set the variable to...

I am trying to track projects as they get moved from responsibility center to responsibility center, and eventually run totals on "total days assigned" so we can start to trend where bottlenecks are, and which group has issues for the longest period of time. (the DB is an Access 2007 DB) So...

Is it possible to have a field only show in a report if it is not null? I have a report that I want to show the closed_dt field, only if a system has been closed. For all open issues, I don't want to have the field show at all. Just wondering 1: if this is possible, and 2: if anyone has any...

I am trying to write an If statement into the VB event procedure in Access 2007 for a field called Status on a form called [Issues details]. What I would like, is If the status = "Closed" Then Set the close_dt in table Issues to Now(). Both Status and Close_dt are in teh Issues table, but...

First off, I apologize, but I am not adept at Access 2007 yet, and am still fumbling through some basic tasks, BUT...I have a report setup called rptFullDetails that contains all the information I want to report on. I put a command button on my Issue Details form that will load the...

I have an Access 2007 DB we are using to both track issues, and do some project management on. My boss wants to add a function to it where it will show how many days a project has been assigned to a specific location (these projects will get assigned to us for testing, then assigned to another...

Ok, I have worked this query up one side and down the other. It's simple, so it shouldn't be giving me so many problems! All I want is a query that doesn't show anything with a status of "Closed", "Cancelled" or "Unfunded" Here's my query... SELECT Issues.* FROM Issues WHERE...