Unable to reference info on a form (1 Viewer)

H

Hecronis

Registered User.

Local time

Today, 16:43

Joined

Apr 26, 2016

Messages

60

• Sep 14, 2017

• #1

Hey, I'm trying to reference some information that is on a form using query but for some reason I can't. If I reference any fields in the form using a query I'll get random things like Chinese characters, blank fields, or for one of the number fields on the form will return "q" in a query. I think something is corrupt considering it was working 2 weeks ago, and I tried running compact and repair but it didn't help. I'm really hoping I'm not going to have to recreate this page. Any suggestions?

 

Last edited: Sep 14, 2017

J

JHB

Have been here a while

Local time

Today, 23:43

Joined

Jun 17, 2012

Messages

7,732

• Sep 14, 2017

• #2

You could try to create a new database and import all into it.

 

missinglinq

AWF VIP

Local time

Today, 17:43

Joined

Jun 20, 2003

Messages

6,423

• Sep 14, 2017

• #3

The 'Chinese characters' thing is almost always a sign of corruption (unless you're in the Far East) and the first line of defense, as JHB suggested, is to create a new, blank file and Import everything int it.

Linq ;0)>

 

H

Hecronis

Registered User.

Local time

Today, 16:43

Joined

Apr 26, 2016

Messages

60

• Sep 15, 2017

• #4

So just importing everything should fix it, it wont just import the corrupted data as well? I wont have to recreate things?

 

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 07:43

Joined

Jan 20, 2009

Messages

12,852

• Sep 15, 2017

• #5

If importing the form to a new database also fails then you can try creating a new form in the new database and use the clipboard to copy all the controls across.

 

H

Hecronis

Registered User.

Local time

Today, 16:43

Joined

Apr 26, 2016

Messages

60

• Sep 18, 2017

• #6

Yeah its still doing the same thing but I was able to figure out a work around for it. Right now it will do until I have a chance to remake that page. Thank you.