hello once again,
i'm using this code to go to a certain record in a table:
Dim strRecord As String
strRecord = Me.List26.Value
DoCmd.GoToRecord acActiveDataObject, "Stopwatch", acGoTo, strRecord
the problem with this code is that it goes to the record number, not the id.... how can I tell it to go to the record it (primary key) instead of the absolute position number of that record?
So i have just completed my database and everything works fine. Now, my managers wants me to go back and do it again for other internal companies. Mind you that we have over 100+ and i am not in the mood of going through and doing something that is not my job. Anyways, all of the companies have the same names for columns, tables and files. for example, 123table for company 123, 124table for company 124 and so forth. This is how it is for every single company. Since all of the data is in one Database, i was wondering if i could write a code or something which in the beginning will ask what company "you are" and what company you want to "dealing with"
For me, my company will be 123 and i will be dealing with 456. So when i enter this in the beginning, it will auto populate the info. In other words, I want to name everything in the query "*table" and that * to be filled by the company number you enter. I was wondering if this was at all possible.
what do you put in the criteria in a date field to show records with a date = to today or less?
View 3 Replies View RelatedI have database where users can produce a quote. Each new quote gets a quote number,
when users add a item to the quote, they also add a DHR (daily hire rate)
The table records the item and adds the quote and the DHR.
I want to run a query so it shows the quote number and adds all the DHR's for that quote.
Can this be done in a query as an expression.
An individual posted a new thread today (3/14/08) (believe it was in the General Section) asking for a help with a UDF that wouldn't process. He received one response, then I came in with another response which I later edited to include more info. Saved it, checked back to ensure it was what I wanted -- it was.
Closed the browser, shut down the computer. When I later reopened this site, the thread was missing entirely. Did a search on my recent posts -- it's not there.
I'm baffled -- how does a thing like that work?
Bob
Hi guys am not sure if i got dis in d correct forum (forgive me if not)
Just wanted 2 know what's d diff btwn a thread & a post (if d's any)
Noks
I have a table that stores date/time in the Now() format, but I want to run a query that will format the date/time in "mm/yyyy" with MSAccess SQL.
Here is an example table:
Table1
------
IDDate
11-Dec-2004 12:24:06 PM
24-Apr-2005 5:04:18 PM
38-May-2005 8:13:52 PM
413-May-2005 2:27:57 PM
Here are the desired results:
Table1
------
IDDate
112/2004
204/2005
305/2005
405/2005
Hello,
Although, I have seen many threads in regards to displaying images in forms, I have not been able to find exactly what I'm looking for.
The solution I am looking for is to give the user the ability to browse for an image, select it and insert it into the form. From reading these forums and playing around with Access, one thign I am sure about is that I want to link the image (I couldn't believe how bloated access gets when embedding an image).
I thought of a great solution for linking images, but I have no idea how to achieve this. (This solution, in my opinion would be great not just for images, but for all kind of objects).
Since I am linking the image, I would like to be able to store the image in a "private database" folder, that way the image will not be tempered with. It is my understanding that if I wanted to do that, I would have to first place the images in that folder and then actualy insert them into the form. This seems kind of pointless to me, since it will create extra work for the user.
So basically what I would like to do in pseudo code is:
On Click, browse for image
on image select, save image to \database image folder
link image to \data image folder
display image in form
I think this would work really well for all kinds of document management (not just images) allowing the users to attach pdfs/images/documents to records with out worrying where they are stored, and knowing they will not be tempered with (I'm planning to place the folder somewhere on the server)]
Any ways, any help woudl be greatly appreciated, and if I do manage to come up with a solution on my own, I will be sure to post it here.
I have a Customer table in an Accounts Receivable late-payments database that has very basic fields:
CustomerNumber, Name, BillToAddress1, BillToAddress2, City, State, Zip, Phone
As we get changes from new invoicing activity, I need the table to update the contact info. So, we get a spreadsheet each day with new invoicing activity, some of which will already have customers in our database. I need to capture any new addresses or other contact information to update my current records. We append the new info to the Invoices table, then need to grab the new addresses and update the Customer table.
I don't know why I don't know how to do this, as it seems so simple. Any help is greatly appreciated.
Hi,
How can I have a query only run the records with Todays date only?
What do I put in the criteria for the date field?
Thanks.
Fen
G'day:
I am creating a dB that has several different "parts" to it and creates several different reports and such.
I am trying to create a form - frmExpenses that I can put down several different types of information to creates these multiple reports.
Part of the form has combo boxes based on information from other combo boxes.
I am having troubles getting the second ComboBox AgencyStaffCMBO populated based on the AgencyID from the first ComboBox AgencyIDCMBO.
Any help would greatly be appreciated!
What is the best way to determine start and end of a day? I am trying to pull all records that are time stamped with today's date and time. I tried >now()-1 but because hours are involved I end up with records from yesterday as well. I need to pull EVERYTHING that has today's date and time.
thanks!
j
Hi,
Is there anyway to retrieve the value of today's date?
Dedi
Hi All
I need to be able to do a count before and after the current date.
My table has fields named month and year and I need to find the count before and after the current month. Any help would be much appreciated.
ChrisD
Hi I have a form that I use to capture information. The "DateReceived" field prefills with todays date. I also have a "DateResolved" field that I would like to prefill with the current date, however that date would be different from the Date Received date. The reason for this is because user logs information then goes back into the form and closes the case by entering a Date Resolved. Thank you
View 3 Replies View RelatedI have an unbound text box. I would like to use the Iif function so that if someon'e preferred address is B (business) It returns the field [BUS JOB TITLE] and if it isn't B it returns [BUS JOB TITLE] and then [BUS EMPLOYER] on the next line. I tried this:
=IIf(([PREF TYP]="B"),[BUS JOB TITLE],([BUS JOB TITLE] & Chr(13) & Chr(10) & [BUS EMPLOYER]))
And it's returning "#ERROR". Help! I need to finish this today for a big meeting. Thanks!
This is probably an easy criteria but I'm getting close to COB and I have to have it in today.
I have a DOB as (DD Mon YY 04 Jul 79) in which I need to create a column for thier age. Then I have to show all the people who are over 60 years old. I can't even get thier age to show correct. Any help. Thanks
I'm looking to pickup the cases where the date last paid is greater than 60 days. Can someone help me
select id_case,
dt_last_pay
from noldba.case_rollup;
I have a query that is pulling data from a table containing a Tamestamp field. I want to set the query to pull my data but don't include anything that was logged in TODAY. How can I set this in my criteria?
Thanks
Hi,
Is there anyway to add criteria to a query so when a report is run it prompts you for:
Show all records entered today or hit enter for all records?
Thanks.
I use this for filtering other data but I cannot seem to make it work with a date..
Like "*" & [Enter Part of The OFFICE or Enter For All Records] & "*"
Thanks.
Fen How
Hi guys,
I need to finish the Asset Management System I have been creating today.
The main Asset Form works fine for Data Entry. However when I view existing records, the Model of the Asset (I.T Equipment) appears blank.
The reason for this is:
I have three tables linked in the following way:
Manufacturer > Model Group > Model
When an Asset is recorded in the DB, the user must select a Model.
To minimise duplicating data I decided to only store the Model ID in the Asset Table. This way, if I need to view the Manufacturer and Model Group, I can just do a reverse lookup based on the Model ID.
Problem:
The Manufacturer and Model Group are unbound combos. The Model is a bound combo filtered by the Model Group filtered by Manufacturer (aka Cascading Combos).
However, as I am not storing the values for Manufacturer and Model Group in my Asset Table, when viewing existing records, all combo boxes are blank.
Has anyone got a solution to this problem. I downloaded an example by Pat Hartman that requeries the filtered combo on the forms current event. However in that example the main combo was stored in the underlying table.
Any suggestions. Would really like to knock this one on the head today.
Can post an example DB if it would help
Many thanks
BF
Hi i know it is simple but can someone tell me how to work out an age of someone using their date of birth and the date now please. thanks i cannot remember the formula.
View 1 Replies View RelatedI need to find records for the day before after 5 pm and today before 8 AM,
I'm using access 2010, the field type is a timestamp, (mm/dd/yyyy hh:nn:ss)
I'm doing it manually using date()-1 and date(), then eliminating the records before the day before that we received before 5 pm and eliminating the records we received after 8 AM.
Theres gotta be a code for this..
Hi
I have a table which has a date field in it, where the default value is Now().
How do I get this field to automatically update in the table to "today's date"?
Thanks
Maria
I have a date/time format field.
"8/21/2007 10:02:34 PM" is what my column shows.
What would I add to the criteria to the query to find all records added today?
at the end of the day my user needs to run a query that will show everything from today. Thanks.
Hi,
I have placed a calender object in Access 2003 on a form of mine and would like it to show the current date. Is there a way to set a default? IF it is code, where does it go?