Search results
-
A
Read a file and import its data into a table
stuck up with the entry form. :(, Anybody ! -
A
Read a file and import its data into a table
Try that too, did not work. The add new record in the query remains disabled. -
A
Read a file and import its data into a table
Attached the screenshot of the linked table in a query, not sure i was doing the rite way. -
A
Read a file and import its data into a table
For manual entry, do i need to create another table with the relevant fields ? Tried using the query but that only displayed existing records, could not add new records. -
A
Read a file and import its data into a table
need to validate a date from a table. DLookUp("[LicenseID]","tblLicense","[LicenseExpiry]=<Date()") was looking for something like the above. How can i correct that ? Greater than today then message box and else nothing -
A
Read a file and import its data into a table
Yup the error was If Trim(Mid(TextLine, 9, 12)) = "" Then Basefare = 0 Else Basefare = CDbl(Mid(TextLine, 9, 12)) End If added the part in red and problemo solved :) -
A
Read a file and import its data into a table
Basefare as double as for all -
A
Read a file and import its data into a table
leaving the manual form aside, for some reason BaseFare when 0 returns an error as "type mismatch" but the code seems to correct to me. :banghead:If Mid(TextLine, 9, 12) = "" Then Basefare = 0 Else Basefare = CDbl(Mid(TextLine, 9, 12))... -
A
Read a file and import its data into a table
Ummmmm 24/7 ? sorry kinda new to certain stuffs. Well yes the query is working fine after few corrections in the code and linking the PK :) Need to get the manual entry form correct. -
A
Read a file and import its data into a table
Never had to come across creating forms from a query but here there seems to be a need. I did try making the current query into a form for manual entry but the form when displayed in the form view goes completely blank. How can i create this form ? -
A
Read a file and import its data into a table
Figured that out too....whew ! :) -
A
Read a file and import its data into a table
Aite ! having bad day:banghead:.......Figured out everything just need help with post 216:( -
A
Read a file and import its data into a table
I guess there is a glitch. The FileID does not seem to be populated to other tables its just repeating the ID. If Left(TextLine, 3) = Trim("A02") Then 'First A02(PAX) line Pax = Trim(Mid(TextLine, 4, 30)) tkt = ALC & Trim(Mid(TextLine, 49, 10))... -
A
Read a file and import its data into a table
ah yes, how could i forget that ? got it, done. all ok, now for some error traps. was trying the below and it was working before If DCount("PaxID", "tblPax", "[Ticket#]=" & tkt) Then 'Find ticket # Duplicate i get an error "data type mismatch in criteria expression"only when condition is met... -
A
Read a file and import its data into a table
that's what makes oneself different from the others :) -
A
Read a file and import its data into a table
all seem to be working well except the paxSeq. how do i add the paxseq from tblpax to the tblPaxFareValue ? tired the concept used in for the FileID, the PaxID came correct but the PaxID in tblPaxFareValue was repeating. -
A
Read a file and import its data into a table
Not sure if i got it correct but here it is Set RSFiles = CurrentDb.OpenRecordset("tblFiles") Set RSPax = CurrentDb.OpenRecordset("tblPax") Set RSPXFare = CurrentDb.OpenRecordset("tblPAXFareValue") Set RSSector = CurrentDb.OpenRecordset("tblSector") FileID =... -
A
Read a file and import its data into a table
Yup careless mistakes :( I was going to ask you about how to populate the FileID for each table from tblFiles for all the tables and the paxseq for this table. I only know the addnew part not the edit syntax. How do i add the FileID to each table and paxseq -
A
Read a file and import its data into a table
Ooops ! my bad. did not set the variable to the table. Done now.