Recent content by qupe

Mr. Hartman was partially right, the issue was that in the report was a grouped by [First name], and that is why it was prompting for the field name every time I run it. The issue is solved thanks for you help.

I have a table has two fields [First Name] and [Last Name], I want to create an expression in the query of both of them as single field. The issue happened when I deleted the parents fields. Access starts to show up the "Enter the Parameter Message".😓

When I create an expression query, should I keep the parents fields? e.g.: Expr = [First Name] & [Last Name] should I keep the parent fields in the query I mean [First Name] and [Last Name]?

I am not limited to array, I am opened to any other solution. "I made a query and grouped it to get the distinct value," if this may give another way?:unsure:

I looked for it, and its not clear. Please write any example or reference page.

Hi, As in the title: the main goal is to create a report for each subject and save it as PDF. this code do the job. Private Sub Command15_Click() Dim sql As String subcol = Array(14, 16, 30, 74, 289, 200548, 201103, 200594, 200569, 402031, 201105, 157) For i = 0 To 11 sql = "SELECT * FROM Y7M...

Hi every one, I am facing a new issue with the MS Access report, when I am creating a stander report of a query, the data is visible. When I am adding a group or a sort it become empty. any solution?

thanks for your suggestion it was helpful.I found some mistakes ,however that did not fix the issue. "does not work" means the SQL do not append new records to the table. but i change some of the names like instead of "subject 1" i used "subject_1" which help to fix it. thank you very much all ;)

Private Sub Command200_Click() Dim strSql, strSqlfees As String, i As Integer For i = 1 To 8 ' strSql = "INSERT INTO [Copy Of tblsyllpus] ( Studentname, subject, ExamDate, enddate, Qualification, Syllabus, Code, [Component Title], [Session], Duration, gradyear )" & "SELECT [Form responses...

i hope someone tells me the solution :D

Unfortunately i got the data base like that multiple entries for one record :banghead:

hi i have 8 textboxes and i have 16 append queries.Two for each one of the textboxes. Each one of these Queries has a criteria equal to the textbox. is it possible to write a loop to all textboxes and change the criteria depend on the textbox name? and i will use just two append queries...

thank you, in the beginning, i were using poster link and it was fine, but recently they change some thing with their sever, so the old link was not valid any more , and i have 70 shows, it is not easy task, then i found about the scraping , so i looked for it.

thank you very much. this is a code found on internet but it is not working probably for 1. i am using the main IMDB not what did you recommend 2. some debugs. Private Sub Form_Load() Dim IE As New InternetExplorer IE.Visible = True IE.Navigate "http://www.imdb.com/find?ref_=nv_sr_fn&q=" &...

hi i have a small db form series i watch, and i red about ability to query from web sites like imdb or myanimelist and i may get poster link or series episode number , i am not big programmer, So what do you have thoughts about this thing:confused: