Search results

  1. A

    Insert not populating new fields

    I have an insert query that has been working just fine. I added three new columns (Paid, Balance, Invoiced) to both tables that I am using in my query. The query will insert the new records that don't exist in the one table just fine but it is not populating the new columns. :banghead: Any...
  2. A

    Using SQL Pivot table results in MS Access

    I have query that produces a pivot table (see below). I want to use those results that in a MS Access report. Normally I would use a view for this but I can't make it a view because of the #temp table part of the code. I tried to paste the code directly into a pass-through query but it errors...
  3. A

    Passing Parameters to SQL

    I have a stored procedure that inserts a new line to a table when pressed from a button on the form. The code behind the form is grabbing the Utility_read_ID as a variable and passing that to the stored procedure via a Pass-Through query. The code below seems to work with the exception that I...
  4. A

    Does it matter?

    The database I am working on has Access as the frontend and SQL as the backend. I have noticed that both peices of code will work. I want to know if it really makes a difference in which one I use. Dim stDocName As String stDocName = "rpt_MAMC_invoice" DoCmd.OpenReport stDocName...
  5. A

    File sharing lock count exceeded

    I am trying to add a autonumber to my table and getting the following error: File sharing lock count exceeded. Increase MaxLocksPerfile registry entry. I have no clue what this means or how to fix. I am not able to edit the registry.
  6. A

    Time Elapsed

    Hello... I am trying to get have a column that will compare two dates (start date and Must Complete by Date) and come back with the time elapsed by hour and minute. I can get it give total minutes but I need that to be broke down to how many hours and what minutes are left. I've been racking my...
  7. A

    INSERT input box

    Hi... I has been unemployed for two years but now I am not back to work so my VBA skills are rusty... How do I get this to work: Dim strInput As String strInput = InputBox("[Enter Check Number, eg 143469:]", "Enter Check Number", 0) 'Append records to...
  8. A

    Calculate between End date and next start date

    I have a table that has the following feilds: Person Start Date End Date John Smith 10/1/2006 1/14/2007 John Smith 2/18/2007 5/31/2007 What I want to do is calculate the number of months between the 1st end date and the 2nd start date. Any ideas on how to do this? Thank you in...
  9. A

    need help with complex data validation

    I am developing a form to process training taken by caregivers. On the form I have a field where the user will select the class. After the class is selected I must validate if the caregiver can actually take the class or not. This depends on how many times they have tried taking the class or if...
  10. A

    How to hide fields on forms using vb

    Hello fellow developers, I have two forms that I am working with: The Switchboard and a member/provider listing form. From the switchboard depending on which command button gets clicked opens up the member/provider from. On the member/provider form I have two fields: member field and a provider...
  11. A

    How do I open a from and a subform based on criteria?

    I have a form that opens up for the user and allows the user can pick a member name. What I want is that once member name is selected the Main form (Providers) opens up at the members name (Subform). I can get the main form to open up with the correct provider but I am having trouble getting it...
  12. A

    Datevalue

    In Excel there is a function called Datevalue() that will return the dates computer serial number. See below example: Formula Description (Result) =DATEVALUE("8/22/2008") Serial number of the text date, using the 1900 date system (39682) =DATEVALUE("22-AUG-2008") Serial number of the text...
  13. A

    What is an Overflow error

    Hello, I am working with a query and i am getting an overflow error. Anyone know what it means and how to get rid of it? Thanks,:confused:
  14. A

    Tracking Share of Cost

    Hello fellow developers. I need a query to help me track share of cost for clients. Anyone have any ideas? This is what I am working with. sorry it didn't paste very well. My problem is that my query keeps subtracking the share of cost and I want it to stop subtracking the share of cost once...
Top Bottom