I am fairly new to MS Access and just have a fairly simple question. When doing text box checks I always check IsNull(textbox) and textbox <> "". Then today it occured to me that the text boxe...
Congrats to boag2000 on reaching 1M points, becoming the latest Access genius!
http://www.experts-exchange.com/M_2293853.html
Way to go, Jeff!
I am having repeated issues with a shared database that I occassionally use remaining locked after I have closed it and even closed Access. It is clearly my machine that is locking it, not an...
Ok, I'm trying to run a SQL statement in Access that looks like this:
SELECT location.locationName, Count(job.jobId) AS total, job.jobStartDtTm
FROM (job INNER JOIN jobdetail ON job.jobId ...
I am trying to discern what the formula is to convert a hex # to a DateTime.
In a file I am trying to parse, the Hex Value is 992947609 and I know that it is equivalent to 05/07/2007 07:01 ...
I have an existing table for service ticket history that shows problem and resolution descriptions in seperate records linked by the ticket number. I need to combine the descriptions, keyed on...
I need to export 3 queries and save as 1 text file. I need this for our bank, AP Positive Pay.
The queries are:
qryHeader (One Line - First Line)
qryDetails (Beginning at the second li...
I need vba code for an access form to delete records from table "jcngrantcontact" if the grantid is 0. The form where I am putting the code is not based on the table that I want to delete rec...
When I went over what my manager wanted I discovered I was wrong in what I wanted to ask so I will try again,
IWhat I need is a Do Until For Next Loop that goes until Day14 is reached
Read ...
How do I link a field in Access 2007 file to the "tasks" in Outlook? Note that I do not want to link contacts but rather tasks. I am using Access 2007 and not Access 2003
I'm trying to re-use a fairly simple query.
Basically, the value for my fields criteria is within the form name.
I want a bunch of forms to be able to use this same query.
Each form has a...
Hi guys,
In Oracle I can throw a Script that create a Function like this.....
create or replace function......
begin
end
Can I make this in MS Access?? How? What kind of object is...
In access, I am using the formula '=Environ("Username")' in a text box to identify the logon of the current user. When the access form is run in Citrix, it returns '#Name'.
Is there a form...
MS Access help gives clear steps to create clustered index. I need to create clustered index using SQL statements how do i do that?
I get syntax error near the keyword "Clustered". Same state...
I will be importing 50 to 100 rows from an Excel spreadsheet into access on a Daily basis. Each row will have 4 cells (columns). Each cell will have no more than 20 characters.
Approxim...
I need to enter a default value in a table field that calculates the Fiscal Year based on the same table's Month field. The month field's default value is: Month=Format(Date(),"mmm")
If th...
Hi,
Is there anyway via a query to delete a record in my table, if certain field is not numeric.
Delete * from tbl_test where field1 is not numeric;
Thanks
I am new to Access so my question may sound long winded.
I am building a phonebook database for multiple (sister) companies with multiple locations. I have constructed 3 tables so far.
1 - E...
When compacting and repairing a database, Access doesn't actually compact the current copy of the database, it just saves it as db1.mdb? Am I correct?
If so:
I am building an application...
I am getting MS Access 2000 and/or 2003's standard record locking message ( WRITE CONFLICT record is being edited by another user. save changes, copy changes to clipboard, drop changes). Thi...
I have a database that was being used by two users on the same full DB, but when 3 came, I split it. They are each on their own FEs, linked tables to the main copy BE, and are being kept from...
I have this little Access program and when I run it I want that it takes up the entire screen. How can I hide the Access menus and ribbons?
Command Button to run query and refresh subform isnt working:
I have two forms (they are essentially the same, just sized differently for different size computer screens):
Frm_Value_Reque...
I have some code to update my linked tables if the database they are contained in has a new location. When I run it I get an invalid argument error on the .refreshlink method.
I have the following XML response after making a post to a URL. I am trying to write a VBA function that will get the NodeValue of the <soap:Text ...> node which is basically the error messa...
