Search results

Hello All, I am trying to use the expression builder to get the latest date in a table in a form inside an unbound text box utilizing DLookUp. Have tried a bunch of different syntax options of the same formula.o_O None are working what am I doing wrong..... Any help is appreciated...

Hello All, I am trying to pull a number(Not string) from a form I am working on. I think my issue is syntax but can't figure this out and I have tried several version all ending up in #Error Domain = Access_Agreement expression = APN (number) criteria = lookup from a field from the form...

Hello All, I am trying to construct a update Query to add a space right before the last character. but am having a hard time:banghead:.... can anybody point me to the right direction. Example: Book Door Sliding Door Jam Should look like this after the Query Boo k Doo r Sliding Doo r Ja m...

Hello All, Is there a way to prevent the file path to show in the form. This is on the top of the form when its being run. (See Image). I looked in the options and didn't see any thing that will effect this. I was wondering if there is a way of doing this via VBA...... OS: Win 7professional...

Hello All: I have an applet in Access(2007). The applet logs calls and enables users to attach files to the call and if they choose, send an e-mail out. Not a VB programmer but I understand it. More of a spaghetti programmer. These are my issues……. 1. Need to be able to attach to...

Hello All. I have found the code below , It is function. I have managed to incorporate it to my form. The issue I am having is that I don't get any error, which is good, but I don't get the file saved either it seem nothing happens........ Can somebody hint me to the right direction...

Hello All.... I have been working on a Access(2007) applet. All is going well with an exception of not being able to open one of my forms in normal mode(not an edit mode). It seems no matter what i do the form opens in edit mode. this is with the little pencil to the left( See EM.jpg). I need...

Hello All. I have an existing query that will give me the number of dates for given month and year in Fiscal Calendar Year. QUERY: SELECT Count(Sch_Sampling_Date.Sch_Sampling_Collection_Date) AS CountOfSch_Sampling_Collection_Date, Year([Sch_Sampling_Collection_Date]) AS CalenderYear...

Hello All, I am kind of lost as to an approach to the problem I am having. I have a table with over 400,000 records. I need to export several attribute(name, date, num-1, num-2)from the table to *.csv or *.xls files with no more than 1000 record for each exported file. Can some body give me...

Hello All: I have been struggling with understanding Queries related to Time Series. I find it difficult to get the right answer or understanding how to ask the right question Access style…… Table below is a sample data/table example for my question. The intent is to build a query that...

I am trying to import a table from another database. from all the stuff that I look at this code should work. but it just sits there as nothing happens am I missing something..... DoCmd.TransferDatabase acImport, "Microsoft Access", _ "Path_To_Database;PWD=password;LANGUAGE=us_english;"...

Hello all: I am trying to use Allen Browne’s Extended DLookup() http://allenbrowne.com/ser-42.html namely ELookup(), But am running to a bit of problem. At first I got some syntax errors in which I figured out but now I am hitting a wall with No result…..I am hoping some of you might be able...

Hello All: In the code below I am creating a record with the INSET INTO statement and then Updating with additional info in various fields. it is not working the way I thought it would, so I am trying to create the record in it's entirety …… SQL_Grade_GUSD_ID = "INSERT INTO Grades...

Hello All: How can I make the following code shorter to use less line of code.... DoCmd.SetWarnings False SQL = "INSERT INTO Guardians (GUSD_Student_ID) VALUES (" & Me.GUSD_Student_ID & ")" SQL1 = "INSERT INTO Grades (GUSD_Student_ID) VALUES (" & Me.GUSD_Student_ID & ")"...

Hello All: I have made a cross-tab query which works fine. I also have made a report which is based on this cross-tab query. Due to nature of the cross-tab query the Value column(s) is dynamic. The report I made is based on all available data types (columns). The report works if all data...

Hello All. I am using the same form (form_x) to add new assignments and new tests. The form (form-x) gets invoked with two buttons (New Assignment – New Exam). In the form (form-x) I have a combo box by which I identify if the record is type Exam or Assignment. I am using the following code...

Hello All…. I have two tables (Student, Guardians), well there are more but these two are involved in this SQL…. Student_ID is the linker between the two table (many to one – multiple guardians to a single student). I have a form(frm_Student_Add). My goal is once I add a student (capturing...

Hello All: I have two forms, A and B. Form A is detail info of students. From Form A I am opening Form B to Add assigned tests. Once I Save and close Form B, I like to Re-freash form A so the record that was just entered in Form B shows up in Form A subform. I am not sure under what event...

Hello All: I am trying to build an access applet for my wife who is a K5 teacher. I am fairly new to Access and like to think I have fairly reasonable understanding of the relational databases. I however am not a programmer. I am not done with the applet yet so please don't judge it as is, I...

Hello All: This is very confusing:banghead:, maybe one of you guys can shed some light on this or give me a solution. I am trying to do a update query on a table. I have constructed a formula which is not working in an update query but it will work in a select query. I have the database...